Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull data from worksheets with a batch file?
I have several workbook with a seperate sheet for each week; the same data is
always in every row. Is there a way to pull data (e.g. ='07-03-2006'!$F$60,'07-03-2006'!$H$60,'07-03-2006'!$J$60,'07-03-2006'!$L$60,'07-03-2006'!$N$60) from a worksheet with a batch file or some command line utility? It would really simplify my day if I could automate this process. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull data from worksheets with a batch file?
Hi Alex
If you want links then use this macro for cells in workbooks http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Alex" wrote in message ... I have several workbook with a seperate sheet for each week; the same data is always in every row. Is there a way to pull data (e.g. ='07-03-2006'!$F$60,'07-03-2006'!$H$60,'07-03-2006'!$J$60,'07-03-2006'!$L$60,'07-03-2006'!$N$60) from a worksheet with a batch file or some command line utility? It would really simplify my day if I could automate this process. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
How do linked worksheets exist with data on an external device | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
How to pull data out of an excell file with multiple tabs | Excel Worksheet Functions |