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
|