I have two Workbooks (Quote.xls and number.xls)
Quote.xls contains a Worksheet called CopySheet .
Cell C8 in CopySheet contains a number (say 1000)
which is generated from Sheet1 Cell A1 in Number.xls.
We have Quote.xls open
I need a macro in Workbook Quote.xls which will :-
a) Open number.xls (file location is q:newquotesystem)
b) Look at Sheet 1 Cell A1 .
c) Increment the number in Cell A1 by 1
d) Copy the contents of A1 to Cell C8 in worksheet "CopySheet" in
Workbook Quote.xls
e) Save & Close Workbook Number.xls
f) Return to CopySheet in Workbook Quote.xls
All help appreciated Ted
Quote.xls contains a Worksheet called CopySheet .
Cell C8 in CopySheet contains a number (say 1000)
which is generated from Sheet1 Cell A1 in Number.xls.
We have Quote.xls open
I need a macro in Workbook Quote.xls which will :-
a) Open number.xls (file location is q:newquotesystem)
b) Look at Sheet 1 Cell A1 .
c) Increment the number in Cell A1 by 1
d) Copy the contents of A1 to Cell C8 in worksheet "CopySheet" in
Workbook Quote.xls
e) Save & Close Workbook Number.xls
f) Return to CopySheet in Workbook Quote.xls
All help appreciated Ted