Hi All
I have a Workbook of two invoices on two different Sheets that I want to print seperately but using common invoice number. The macro increments the invoice number on "TypeA Invoice" Sheet in cell N3 and there is a link on "TypeB Invoice" cell N3 to the reciprocal cell on Sheet "TypeA Invoice". What I am trying to do is like this: Since the Macro is linked to Sheet "TypeA Invoice" and the number is incremented on cell N3, I want to be able that when I want to print "TypeB Invoice" (a seperate Macro) I want the number to increment on Sheet "TypeA Invoice". To do this I need to name the cell on "TypeA Invoice" for the Macro of "TypeB Invoice". If that is so, how do I do that?
Is that clear enough?
Thanks
Bookmarks