Somebody very kindly coded me the macro below to copy a portion of a table defined by a cell reference (E1)
I need to try and utilise this to copy data from a number of different tables on sheet1 and consolidate them into a table on sheet2 but I’m having a little trouble, I’m assuming it will be a case of altering the following![]()
Please Login or Register to view this content.
To function as:![]()
Please Login or Register to view this content.
But not exactly sure how to express this in VBA?![]()
Please Login or Register to view this content.
Attachment 256073
Bookmarks