Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Load Data from ver 1 to ver 2
Hi
I am looking for a Macro to load data from version 1 to version 2 of the same file with manual input. There are protected cell in this file and contain formulae which I do not want to be updated. Only the data that is in the unprotected cell in the spreadsheet. If any one can help me that would be great. Thanks Yawar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Load Data from ver 1 to ver 2
This will return the value in cell A1 of Sheet1 of the workbook called
Version1.xls located in the path/directory shown......modify and replicate to fit your circumstances. ='C:\Documents and Settings\My Documents\[Version1.xls]Sheet1'!A1 Vaya con Dios, Chuck, CABGx3 " wrote: Hi I am looking for a Macro to load data from version 1 to version 2 of the same file with manual input. There are protected cell in this file and contain formulae which I do not want to be updated. Only the data that is in the unprotected cell in the spreadsheet. If any one can help me that would be great. Thanks Yawar |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Load Data from ver 1 to ver 2
Hi I was actually not looking for manual input I am looking for
updating data without having to manually typing the formula. Any one there to help me please. CLR wrote: This will return the value in cell A1 of Sheet1 of the workbook called Version1.xls located in the path/directory shown......modify and replicate to fit your circumstances. ='C:\Documents and Settings\My Documents\[Version1.xls]Sheet1'!A1 Vaya con Dios, Chuck, CABGx3 Hi I am looking for a Macro to load data from version 1 to version 2 of the same file without manual input. There are protected cell in this file and contain formulae which I do not want to be updated. Only the data that is in the unprotected cell in the spreadsheet. If any one can help me that would be great. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Macro data selection line delete | Excel Discussion (Misc queries) | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |