2007 - copy rows to master

[shondag]

Help please - - I have approx. 10 wrksheets with 1 as my master. They are all formatted the same with same column titles. As information is entered in a row in 1 or any of the 9 worksheets, I would like the information to be copied to the master worksheet in the next available row. Does this make sense? I am fairly good at Excel but know NOTHING about VBA. Being able to do this would make my NEW boss very happy - LOL. Hope I can get some help.

Shonda Gauthier
Lafayette, LA

 

[shondag]

For the most part it is working great. As I input data in the other worksheets it feeds in to the summary sheet. But if I try to look at the summary sheet it opens a window to the file location. Am I supposed to input the worksheet names where it says "worksheet" for every worksheet??

 

[shondag]

I'm sorry - the previous error was because of old data hidden in the files. I have it all cleaned and working now. The ONLY issue I seem to be having is it puts a copy of the header row below the rows that are being filled on the summary page (from subsequent worksheets).

 

[jbeaucaire]

Looking at the code, it is copying the data from each sheet from row2 downward. Obviously if your headers go down further than row1, you will need to adjust the A2 to A3, or A4, wherever the first row of "data" begins.