If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Export data from the same cell from multiple spreadsheets into a n
Hi,
I am working with weekly timeshets in Excel and I am using the same form every week, but save it as a file named "Timesheet 20100122" for a week ending on Fri, Jan 22, 2010 (Our accounting week period). Therefore the daily hours appear every week in the same cell. I would need to export these hours to another - summarizing - spreadsheet (For example and invoice spreadsheet) somehow automatically. Any help would be welcomed. Thanks for your help, Cheers, |
#2
|
|||
|
|||
Export data from the same cell from multiple spreadsheets into a n
Try
http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Babuppa" wrote in message news Hi, I am working with weekly timeshets in Excel and I am using the same form every week, but save it as a file named "Timesheet 20100122" for a week ending on Fri, Jan 22, 2010 (Our accounting week period). Therefore the daily hours appear every week in the same cell. I would need to export these hours to another - summarizing - spreadsheet (For example and invoice spreadsheet) somehow automatically. Any help would be welcomed. Thanks for your help, Cheers, |
Thread Tools | |
Display Modes | |
|
|