Hi,
I am trying to crate a macro to populate a summary sheet so that I can compare several Publishers results together. (see attached file).
Within the summary sheet the columns starting "400" all denote a publisher who has their own sheet within the workbook. All of the publishers sheets follow the same layout exactly.
I need Cell B3 to populate from the last cell (with data) in Row 10 (of that respective pubs sheet)
I need Cell B4 to populate from the last cell (with data) in Row 11(of that respective pubs sheet)
I need Cell B5 to populate from the last cell (with data) in Row 12(of that respective pubs sheet)
If somebody could get me this far I can certainly do the rest myself.
Many thanks for any and all help.
Cheers
Jon
Bookmarks