| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy from three sheets to one
I'm sure this is very straightforward but...
I'm trying to copy columns A to D from sheets 1 to 3 into a master sheet. My difficulty is that the datasets are of different sizes so a record macro is no use. Sheet 1 has multiple ranges (a3:d36, a40:d47, a51:d55, a59:d71) which don't change. Sheets 2 and 3 are frequently updated and so change in size. So, basically, I'm looking for a bit of code to paste this stuff into a master sheet. Sounds easy enough. Well, that's what I thought. Thks in anticipation, MM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy cell info to other sheets, other sheets dont contain all row. | Excel Worksheet Functions | |||
| move or copy sheets doesn't copy format | Excel Worksheet Functions | |||
| Copy the first row to other sheets. | Excel Programming | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
| Copy sheets | Excel Programming | |||
Threaded Mode
