arunlgt
03-06-2010, 08:52 PM
Hi Everyone:
My company's head office sends a spreadsheet everyday with the following title format "todaysdate_BBH_Data" = "20100303_BBH_Data".this spreadsheet can come via a email or be transferred directly into a specific network drive for example "T:\Risk".In this worksheet everyday there is information in specific cells( always at cell CD1) that has to be transferred automatically into a master worksheet-lets call it FundPerformance.xls.The data has to be transferred to the first empty cell in column D.
eg :
20100303_BBH_Data(Sheet1:cell CD1) ------> FundPerformance(Summary:first empty cell in column D)
There is ofcourse a lot more to this project.Any help on getting me started on this I would be extremely grateful
please note for security reasons I am unfortunately unable to post the workbooks here.
My company's head office sends a spreadsheet everyday with the following title format "todaysdate_BBH_Data" = "20100303_BBH_Data".this spreadsheet can come via a email or be transferred directly into a specific network drive for example "T:\Risk".In this worksheet everyday there is information in specific cells( always at cell CD1) that has to be transferred automatically into a master worksheet-lets call it FundPerformance.xls.The data has to be transferred to the first empty cell in column D.
eg :
20100303_BBH_Data(Sheet1:cell CD1) ------> FundPerformance(Summary:first empty cell in column D)
There is ofcourse a lot more to this project.Any help on getting me started on this I would be extremely grateful
please note for security reasons I am unfortunately unable to post the workbooks here.