Ok - I am new to using excel but my boss wants me to create a formula or macro or print function or something that will do the following:
She has a one page worksheet with 4 cells. Each cell represents a label for a piece of machinery that we sell. We have hundreds of pieces going out each day. She wants to be able to print many copies of this one page but have the serial numbers ascend automatically. Does that make sense? I hope so....
So for instance:
Cell#1 has serial number RAW52634, Cell #2 RAW52635, Cell #3 RAW52636 Cell #4 RAW52637 . So when we print the first copy the numbers will be correct, but she wants the program to know that on copy 2 the serial numbers should be Cell#1 RAW52638, Cell #2 RAW52639, Cell #3 RAW52640 Cell #4 RAW52641 and so on.
I dont know if this is possible or simple - I don't usually get asked to do these kinds of things. I am just the receptionist....
Thanks for any help....
Bookmarks