I am a complete newbie to excel.
Is it possible to create a sheet that exports its data to a different worksheet which is printed and a different workbook for archival purposes?
I'll give the scenario:
I would like to enter a new customer's name, address, phone number, and item they bought into a sheet (B1:B4) and hopefully click a button.
I would then like it to export that data to the next available row (A2:D2, A3:D3, etc) on a different workbook so that I can archive all of my customers (getting it to fill the next row seems to be the biggest challenge for me so far) and also export the same data to sheet 2 of the original workbook.
Sheet 2 is organized as an index card to keep a hard copy in a tickler file and is printed.
After that, I hope it could clear the original cells so I can type the next customer's info. It would be a bonus if it would automatically print the card when I click said button, but that may be asking too much.
If someone could even tell me where to start I'd gladly do the research to formula's etc myself.
Thanks in advance.
Take care.
-Bill
Is it possible to create a sheet that exports its data to a different worksheet which is printed and a different workbook for archival purposes?
I'll give the scenario:
I would like to enter a new customer's name, address, phone number, and item they bought into a sheet (B1:B4) and hopefully click a button.
I would then like it to export that data to the next available row (A2:D2, A3:D3, etc) on a different workbook so that I can archive all of my customers (getting it to fill the next row seems to be the biggest challenge for me so far) and also export the same data to sheet 2 of the original workbook.
Sheet 2 is organized as an index card to keep a hard copy in a tickler file and is printed.
After that, I hope it could clear the original cells so I can type the next customer's info. It would be a bonus if it would automatically print the card when I click said button, but that may be asking too much.
If someone could even tell me where to start I'd gladly do the research to formula's etc myself.
Thanks in advance.
Take care.
-Bill