View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
as a starting point:
http://www.rondebruin.nl/copy2.htm

"kalz" wrote:

Hello,

I'd like to set a macro which helps to copy and paste rows of data from
several wksheets into one consolidated worksheet. As this needs to be done in
regular interval and the rows of data in the original files can vary from
time to time. I do not know how to perfectly and automatically do such
consolidation using macro.

Pls help,
thx