I have a workbook with multiple sheets that I need to summarize in another workbook by sorting data in a specific way. The source data (see the "Sample Data.xlsx" file that is attached) has tons of information that needs to be summarized so that it is easy to use. What I need to be able to do is once a user selects the file to import into the "Cost Compare v1.xlsm" file is search through the cost tables in the "Sample Date.xlsx" file and if there is a cost on a line, then certain values from that line are copied to the Cost Summary worksheet in "Cost Compare V1.xlsm". Every time there is a cost in a given month (Jan 2011 to December 2012), then I need to copy the Employee Classification and Name from Columns A and B of the source file to Coumns C and D in the Cost Summary worksheet; copy the JV partner (SES or TT, see cells A8 and A55 in source for examples) from the source into column B of Cost Summary worksheet; copy WBS (13 digit code in A3) from source to column A of Cost Summary worksheet; and the cost and hours, and the associated month from the source to the Cost Summary worksheet. So, for a given line in the source file, there could be up to 24 lines in the Cost Summary worksheet, if there is a cost for each month in the 2 years. I have been trying to figure out an easy way to do this, but so far have been stumped. Any help would be great, and thanks ahead of time!
Cost Compare V1 can be found here:
https://docs.google.com/leaf?id=0B5...g3ZWYtYTY5NzgxZTM1NGRm&hl=en&authkey=COeKjMYE
and Sample Data can be found here:
https://spreadsheets.google.com/ccc...jlTeTBOX001M2RMVnBONEE&hl=en&authkey=CJKd97MM
Cost Compare V1 can be found here:
https://docs.google.com/leaf?id=0B5...g3ZWYtYTY5NzgxZTM1NGRm&hl=en&authkey=COeKjMYE
and Sample Data can be found here:
https://spreadsheets.google.com/ccc...jlTeTBOX001M2RMVnBONEE&hl=en&authkey=CJKd97MM
