View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mm mm is offline
external usenet poster
 
Posts: 37
Default 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