Hello everyone,
im stuck in a current task as I am new to VBA.
In the example doc, there are 3 tabs.
I want to be able to copy all the values of the 4 lists until their last row with values in the the "Copy" tab and paste them into the "Paste" tab in E3 as a unique list.
My issue is that in my original doc(As i tried to reppresent in this doc) the values in the lists contain formulas with a iferror, and so when i try copy them and paste to last row, i get huge gaps between the lists.
So essentially i want to copy all the lists until the last row with values and paste them.
I hope i was clear with my explanation, if not i am more than happy to re explain.
I thank you in advance.
Bookmarks