Hi there,
I am new to the forum and not good with VBA coding at all. I have a workbook with 3 raw database worksheets that get updated every week. From this I have set it so that 6 other worksheets combine and receive the relevant data in terms of specific categories. I have a final worksheet detailed Report 2 in which I would like to display the 6 worksheet data sets in there respective categories.
The 6 worksheets have multiple blank spaces and therefore I need these removed in the summary. I also would like the tables in the final Report 2 to be one cell below each other (6 tables with headings of respective worksheets).
I would be greatly appreciated if someone could help me out with this?
Thanks.
Bookmarks