I am trying to set up a gift certificate program for the company I work for.
Using Excel, I have one sheet called payment info. and one sheet called gift
certificate. I want the user to be able to simply type in the information on
"payment info." and have the gift certificate "fill itself out". The problem
comes the second time I want to fill one out, as the cells on the gift cert
page are pointing to the first row on the other page, not the second. Is
there a way to have the gift cert page automatically advance one row so that
it takes the data that is at the bottom of the payment info. page? Any help
would be appreciated.