K
Kiwifella
Hi there all you Gurus out there!
I have created a macro to create a unique invoice number in a work book, but
for my specific purpose, each time I create a new invoice number i want to
record this in a rolling register in a separate spreadsheet & workbook.
If i have another spreadsheet open I found I can do this, However not when
the 2nd (register/record) work book is closed. I tried recording a macro
whcih included opening the destination work book, but this would not run when
I trialled it.
Can I do this?
Alternatively, can i program excel in such a way that every time I open
workbook A, workbook B also automatically opens so that I can write to work
book B as a register/record?
Huge thanks for your help, if anyone does know, I am a begininer so please
be very specific. I don't know how to "write macro codes" as such, I have
just been recording macros the easy way.
Thanks
I have created a macro to create a unique invoice number in a work book, but
for my specific purpose, each time I create a new invoice number i want to
record this in a rolling register in a separate spreadsheet & workbook.
If i have another spreadsheet open I found I can do this, However not when
the 2nd (register/record) work book is closed. I tried recording a macro
whcih included opening the destination work book, but this would not run when
I trialled it.
Can I do this?
Alternatively, can i program excel in such a way that every time I open
workbook A, workbook B also automatically opens so that I can write to work
book B as a register/record?
Huge thanks for your help, if anyone does know, I am a begininer so please
be very specific. I don't know how to "write macro codes" as such, I have
just been recording macros the easy way.
Thanks