wo0ter
01-06-2012, 02:22 PM
Hi,
I'm new to this forum. Just started working as a research analyst for a media company and we work with huge spreadsheets pretty often. I'm looking into learning VBA in free time, but I have a question off the bat. Here's my dilemma:
I have 3 excel files, each of them with multiple worksheets. Within a file, each worksheet has identical rows, but different columns. Across all 3 files, the rows and columns are different. In the data field, there are numbers and blanks (representing zeros). So-- is it possible to consolidate all this information into one excel file, while summing up fields with an identical row and column?
I've attached an example of what I'm trying to do. I think it will help to visualize what I'm trying to do.
Any help of advice is much appreciated. Thanks!
I'm new to this forum. Just started working as a research analyst for a media company and we work with huge spreadsheets pretty often. I'm looking into learning VBA in free time, but I have a question off the bat. Here's my dilemma:
I have 3 excel files, each of them with multiple worksheets. Within a file, each worksheet has identical rows, but different columns. Across all 3 files, the rows and columns are different. In the data field, there are numbers and blanks (representing zeros). So-- is it possible to consolidate all this information into one excel file, while summing up fields with an identical row and column?
I've attached an example of what I'm trying to do. I think it will help to visualize what I'm trying to do.
Any help of advice is much appreciated. Thanks!