Oct 03 2021 10:53 PM
Hi All,
can someone please help with the following logic that I would need in VBA:
sheet1-4: row data with coulmn headings
sheet5: summary table with 4 rows of column headings representing the coloumn headings of sheet1-4 respectively (there are empty cells in some of the headings)
I would need a macro that searches sheet5 column headings in rows 1 to 4, finds them in sheet 1-4 respectively and copy pastes the respective columns into sheet5 under the respective heading for sheet1 starting in row 2, for sheet2 starting in row 100, for sheet3 staritng row 200 and for sheet4 starting in row 300.
I very much appreciate your help with this.
Oct 05 2021 01:10 AM
Oct 05 2021 05:19 AM
Oct 05 2021 07:28 AM