Hello all.
I have a workbook with several worksheets within it - 15 to be exact. The latter 12 are named by individual sales reps. These sheets themseleves populate information on the rep's sales from A2 to G2, and down to row #100. Of course, not all of these rows are filled everyday - usually anywhere from 5-10 are filled. The third sheet in the workbook is named ESN Summary. What I need to do should be simple (I think), but I cannot figure it out. I have tried recording a macro for this, but I cannot get it right...I want a macro that will read only the populated rows from the rep sheets and copy them to the Summary sheet. The summary sheet looks exactly the same, except that all the information that would be copied over would actually move over a column (i.e. the first copy would populate B2:H2), because A2 is an additional column - "Rep" - where I would like the macro to insert the name from the sheet it copies from. (I hope that makes since). Of course, I can filter it and organize it later, but I would like for the macro to run automatically and copy after every entry on the rep sheets, that way all information is always up to date. I also of course need to loose no information, so maybe if the macro can be told to go the next row after every entry, but I think this might make all of my data spread out on my summary sheet, so maybe it would be better to have the macro run from a command key, like Ctrl + t, or something...I don't know....
I really appreciate any and all help!
thanks!
ragamuffin