Naming Same Cell on Different Sheets

[Patish]

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

[patel45]

not for me, attach a sample file with current and desired data

[HaHoBe]

Hi, Patish,

at the end of the print job for "TypeB Invoice" maybe just add:

Please Login or Register  to view this content.

This would increase the number in Sheets TypeA Invoice by one and the lionked cell as well. No need for a name there in my opinion.

Ciao,
Holger

[Patish]

Holger

I have tried it and it works. The number increments on Sheet TypeA Invoice. Thanks a lot and much appreciated.

See ya

Patish

[Patish]

Holger

I have tried it and it works. The number increments on Sheet TypeA Invoice. Thanks a lot and much appreciated.

See ya

Patish