G
Guest
Hi all,
I know this should be obvious and easy but I can't find the answer anywhere,
probably because I don't the terminology.
Anyway, my wife has an Excel worksheet with rental data for her business,
things like name, address, nights staying, etc. (Sheet 1) and so I made
another sheet in her workbook as an invoice (Sheet 2) and embedded the data
from Sheet 1 and now don't laugh but I can't figure out how to get the
invoice to "move" through the rows of Sheet 1 (i.e. have a drop-down or
something to change the invoice data (Sheet 2) from Mr. Jones' info on row 3
of Sheet 1 to Mr. Smith's info on row 7 of Sheet 1).
Sad to say, the only way I've figured out how to do it is to do a Find and
Replace of $3 to $7 on my invoice sheet to accomplish this...not very
effecient.
I know this has to be an obvious feature...feeling pretty stupid...please
help...
I know this should be obvious and easy but I can't find the answer anywhere,
probably because I don't the terminology.
Anyway, my wife has an Excel worksheet with rental data for her business,
things like name, address, nights staying, etc. (Sheet 1) and so I made
another sheet in her workbook as an invoice (Sheet 2) and embedded the data
from Sheet 1 and now don't laugh but I can't figure out how to get the
invoice to "move" through the rows of Sheet 1 (i.e. have a drop-down or
something to change the invoice data (Sheet 2) from Mr. Jones' info on row 3
of Sheet 1 to Mr. Smith's info on row 7 of Sheet 1).
Sad to say, the only way I've figured out how to do it is to do a Find and
Replace of $3 to $7 on my invoice sheet to accomplish this...not very
effecient.
I know this has to be an obvious feature...feeling pretty stupid...please
help...