Reference cell in previous worksheet to then add +1 for serial pag
You sure can, without knowing the cell or its contents, i can't be exact but
if the last cell is on sheet1 column A cell 10 then wherever you want the
answer:
=Sheet1!A10+1
change Sheet1! to the sheets name and A10 to the cell that its in.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.
"Thames" wrote:
I want to print a serial number on previously printed gift cards. The gift
cards are printed 2-up on 8.5x11 stock. I thought I could create a 50 sheet
workbook and print 100 cards at a time by printing the workbook, using my
card stock in my printer tray. Am wondering if there is a way to reference
the cell in the preceeding worksheet, then add a +1 value.
|