Hi please me create a VBA code for consolidating multiple workbooks into 1 worksheet or master file.
I have multiple workbooks saved in location: C:\Users\Files = (all workbooks has random filename)
Each workbooks has only a single sheet with different sheet name
I wanted to only consolidate the data in Column C, starting from range C7 going down to the last existing data in column C (data's are random) to all the workbooks saved in location: C:\Users\Files
Also I'm hoping to have it save as a macro enabled-workbook
Please help me I have tried some VBA codes but none are working for me.
Hope to get a response. Thank you in advance
I have multiple workbooks saved in location: C:\Users\Files = (all workbooks has random filename)
Each workbooks has only a single sheet with different sheet name
I wanted to only consolidate the data in Column C, starting from range C7 going down to the last existing data in column C (data's are random) to all the workbooks saved in location: C:\Users\Files
Also I'm hoping to have it save as a macro enabled-workbook
Please help me I have tried some VBA codes but none are working for me.
Hope to get a response. Thank you in advance
