Advance Cell Number Every Time Excel is Opened.

[jock95]

I have built a Purchase Order in Excel and was wondering if I could have the # representing the PO # advance 1 everytime a To: cell is changed?

Thanks,

 

[SkipVought]

Hi,

THis is a VBA question Forum707

Skip,
[sub]
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [/sub]

 

[Rich24]

Hi all,

I'm looking to do pretty much the same thing. Can I put a template on the network, giving access to 4 or 5 users, and advance the number each time the PO is printed? I know nothing about VBA. I know I need to learn sometime, but hopefully not on this assignment. I just don't have the time right now.

If this is not possible, does anyone have any other ideas?

Thanks, Rich

 

[xlbo]

did you not read Skip's response

There is NO way to do this other than via VBA

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question