I am currently trying to copy a bunch of lists from 1 workbook to another, but after I paste the range that contains the list and I go to a cell that should contain a list, it no longer appears.
My lists are dynamic and they are grabbing their values from other workbooks that I also copy to the new workbook through VBA.
I need a way through VBA to copy a list from one workbook to another, keep the formatting of the list and change the reference in the list to the sheet in the new workbook.
Any help will be greatly appreciated.
My lists are dynamic and they are grabbing their values from other workbooks that I also copy to the new workbook through VBA.
I need a way through VBA to copy a list from one workbook to another, keep the formatting of the list and change the reference in the list to the sheet in the new workbook.
Any help will be greatly appreciated.