Hello all,
I need to consolidate data from multiple rows of one workbook into a single row in another workbook. Ideally I would be able to consolidate these rows:
Any help you could provide would be incredibly appreciated!
Thank you
Hello all,
I need to consolidate data from multiple rows of one workbook into a single row in another workbook. Ideally I would be able to consolidate these rows:
Any help you could provide would be incredibly appreciated!
Thank you
Last edited by brgr4u; 10-23-2013 at 10:50 AM.
no jpg please, but xls files
If solved remember to mark Thread as solved
I am trying to get VBA code to consolidate the data in this book into another workbook where column A 'Customer Name' is 'LKQ' and each column is a summation of the original data. There are approximately 2500 cases like this I need to work through.
Thank you!
lkq raw data.xlsx
I am assuming you have multiple sheets. I have created a summary sheet where all the data from each sheet will be merged.
It does not matter if it is a single sheet.
Sorry about that, it works great!
Thank you!!
Last edited by brgr4u; 10-21-2013 at 02:03 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks