Hi,
I am trying to create a macro to consolidate all files in one folder into one file, column A will capture each file name, column B onwards will copy information in each file.
E.g.
Files to be consolidated data start from column D30 all the way to column I, I'd like to copy all the information (from D30 to last row in column I) of its text only (no formula),
into conso file B2 all the way to column G. (one file's information paste below next)
I got a macro to do similar work I used before, not sure how to modify it to use for above purpose, (range changed etc.) is anyone can help to modify the macro? Thank you!
Bookmarks