Hi All
I have a simple copy and paste macro that copies a specific block of data from several sheets (the ranges are manually entered). However I need somethign that is dynamic and not static since I have found these ranges entered have changed. The code would need to find the first blank cell at each interative pasting too.
The sheets I am copying from are called: 2008, 2009, 2010 and 2011 in work book revenue allocations. The pasting sheet is Revenue allocations in work book Summary.
Thanks in advance
Will
I have a simple copy and paste macro that copies a specific block of data from several sheets (the ranges are manually entered). However I need somethign that is dynamic and not static since I have found these ranges entered have changed. The code would need to find the first blank cell at each interative pasting too.
The sheets I am copying from are called: 2008, 2009, 2010 and 2011 in work book revenue allocations. The pasting sheet is Revenue allocations in work book Summary.
Thanks in advance
Will
