Question about Business & Productivity Software
If Sale Line 100 is an Excel Template then it is simple.
The Templates are just preformatted spreadsheets which are edited just like any other spreadsheet.
If you mean that you are using the Template to create another document but wanting all the fields to be the same as the Invoice then I suggest the following method:
Copy the Template fron Worksheet 1 onto Worksheet 2.
Add and remove any fields that you wnt to add or remove (Prices would be deleted on this copy and the title would be changed from Invoice to Delivery Docket, etc)
Then (on Worksheet 2) in the fields that you want to be the same - click on the cell you want the same Data in and hit the = sign. Then go to Worksheet 1 and Click on the cell that you want the data to be the same. Hit Enter. This will send you back to Worksheet 2 and you will see that any data entered into the cell in Worksheet 1 will now also appear in Worksheet 2.
Repeat this process for all the cells you want copied from worksheet 1.
When you complete the data in Worksheet 1 (the Invoice) all the data selected will automatically appear in the cells selected on Worksheet 2.
Try this on worksheet 2 select cell A1, type =, then open worksheet 1 and select B1. You will be returned to worksheet 2 and the formula in cell A1 will now read =Sheet1!A1. Enter anything into Shhet 1 A1 and you will see that it appears in the appropriate cell on Sheet 2.
When you want to print off the Invoice and the Delivery Docket - you only have to open each Worksheet and hit Print and a copy of each worksheet will be printed giving you an Invoice and a Delivery Docket with the appropriate info on each printout (eg if you exclude prices from the Del. Docket then after completing all the details in the Invoice will create a Del Docket with all the relevant information other than the prices.
Does this answer your question?
Posted on Apr 25, 2008
Tips for a great answer:
Jan 28, 2016 | Business & Productivity Software
Oct 01, 2015 | Business & Productivity Software
Feb 04, 2015 | Pc America Restaurant Pro Express
Jan 27, 2014 | Intuit QuickBooks Business & Productivity...
May 02, 2011 | Pc America Restaurant Pro Express
Sep 13, 2010 | Pc America Restaurant Pro Express
May 30, 2010 | Pc America Restaurant Pro Express
Feb 04, 2009 | Intuit QuickBooks Pro 2007 Full Version...
299 people viewed this question
Usually answered in minutes!