Question about Computers & Internet
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
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jan 28, 2016 | Computers & Internet
Oct 01, 2015 | Computers & Internet
Sep 02, 2015 | Broderbund PrintMaster Platinum 16
May 02, 2011 | Pc America Restaurant Pro Express
May 30, 2010 | Pc America Restaurant Pro Express
Feb 04, 2009 | Intuit QuickBooks Pro 2007 Full Version...
Jun 02, 2008 | Electronics - Others
303 people viewed this question
Usually answered in minutes!