Thanks to those who take a look at this and help!
Suppose the file consists of 2 worksheets
For the both sheets:
Cell A1 have date: 25-Mar-02
Can I have a Macro button so that it inputs (when pressed) this formula into Cell C1 (BOTH Sheets): =C:test[Valuation 25-Mar-02.xls]Ingenium'!$E$11
Note: the date within the file name corresponds to the date in Cell A1 for both sheet.
Suppose both sheet's Column A has already been filled with date. The next step I wish the macro to do is whenever I press the button it will fill the formula mention above into C2 (for both sheets). I must ensure Cell C2 formula (in both sheets)have the file name with the date correspond to their sheet's Cell A2's date.
when I press the button it will do the same to cell C3 with both formula reading the dates in cell A3 (for both sheets)
As I am very new to macro Please asist step by step of how to create a macro button and where to put the VB code...
Many Many Many thanks to the helper,,,
Deeply appreciated
This message was edited by chaju on 2002-03-27 00:03
This message was edited by chaju on 2002-03-27 01:45
Suppose the file consists of 2 worksheets
For the both sheets:
Cell A1 have date: 25-Mar-02
Can I have a Macro button so that it inputs (when pressed) this formula into Cell C1 (BOTH Sheets): =C:test[Valuation 25-Mar-02.xls]Ingenium'!$E$11
Note: the date within the file name corresponds to the date in Cell A1 for both sheet.
Suppose both sheet's Column A has already been filled with date. The next step I wish the macro to do is whenever I press the button it will fill the formula mention above into C2 (for both sheets). I must ensure Cell C2 formula (in both sheets)have the file name with the date correspond to their sheet's Cell A2's date.
when I press the button it will do the same to cell C3 with both formula reading the dates in cell A3 (for both sheets)
As I am very new to macro Please asist step by step of how to create a macro button and where to put the VB code...
Many Many Many thanks to the helper,,,
Deeply appreciated
This message was edited by chaju on 2002-03-27 00:03
This message was edited by chaju on 2002-03-27 01:45