macro help

S

shabutie

I am having "fun" trying to set up a macro to select a page of a
workbook. i am having to save the workbook on the page i want the info
to be placed in, then running the macro, this is becoming a probem
since i am having to do this, when i know i am over looking a section
of a formula to look for the correct page to paste the info from the
other workbooks to complete this. can anyone tell me what i need to add
to make this work to its full capability,

help a poor man out
 
S

shabutie

well i guess what i am trying to do is, the macro is taking opening th
8 sheets and placing them on a workbook, from that workbook( CaR
transport.xls), it takes it and paste this onto a bigger workboo
(01CALL ARRIVALS.XLS), i want it to paste this data on to diffren
workbook pages depending on the day, they are diffrent depending on th
page on the final workbook,

How do i have the macro make sure that it is pasting the data on th
correct page?

any info i can get would be helpfull, i dont think this is that tough
just need to add a find page command to the macros script???
this is the area where i need it the workbook labled "01 CAL
ARRIVALS.xls is the workbook where i need it to find a page


Range("B15").Select
Application.CutCopyMode = False
ActiveWorkbook.Save
Range("B17").Select
Windows("04 CArR Transport.xls").Activate
ActiveWindow.SmallScroll Down:=9
Range("B28:K41").Select
Selection.Copy
Windows("01 CALL ARRIVAL.xls").Activate
With ActiveWindow
.Width = 326.25
.Height = 433.
 
Top