Ok, I have a code that is working great, except for two things. I'd like to have the information on the Summary sheet start on Row 6, and have the names of the worksheets the info came from in Column A.
Also would like to have the Summary automatically update if I enter new data into the individual sheets, and to know, if I format the Summary sheet previously to running the macro, will it keep the formatting? (ex. hide columns etc)
I hope this is enough information, and any help will be greatly appreciated.
in to first empty column "B" of summary sheet, which is probably "B1". If you wish the copy to start at Rows 6, the easiset option would be to fill in data(Suspect heading) in "B1-B5", so that the next empyt would become B6.
Now I just need to figure out how to get the sheet names in column A, and I can probably clear all the data from "Summary" before re-running the macro to update, instead of having it go automatically.
Unfortunately it seems to be over-copying the sheet names, and is copying row 5 from some sheets. Would it be easier if I uploaded a copy of my WB for you to see what I'm trying to do?
Ok, here goes. What I'm looking for is: the corresponding client name only beside their information, only ranges A6:K(end) <- could be only one line on some clients, or up to 50 (or more) on others, not the column headers, and not the "Template" sheet. I hope this makes sense. I'm really sorry it's been so complicated, but I really do appreciate all your help!
SO close! Now all I need is for it to not copy the 'empty' rows. I can't say enough how much I appreciate all your help. This would've taken me weeks to get this far :D
Okay, There was a code which deletes a row if column "B" is empty, I removed it because I was not sure its purpose, I have now put it back. If you wish to delete a row if columns G, or F are zeros, you can change this line of code from "B" to either G, or F.
If Cells(i, "B") = "" Then"
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks