I want the data when typed into cell A1 in sheet 1 to automatically show in cell A22 in sheet 3

VLOOKUP(A1,Sheet2A2:B20,2,FALSE)

The assumption here is A1 in Sheet 1 is the cell you want to reference, This cell can be pasted - Any problems let me know.

on sheet2!a1, type sheet1!a1 to link entries on sheet1! to sheet2!

type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.

I think I have a way for you to get this done. Open a.xls and then open b.xls. In b.xls, create a formula in any cell that you want to be updated based on the data in a.xls. For example, if you want cell A1 in b.xls to stay updated with the data from cell A1 in a.xls, your formula in A1 of b.xls would look as follows:
[a.xls]Sheet1!$A$1

You can also create such formulas by following these steps:
1) Open a.xls and then open b.xls.
2) Place your cursor in the cell that you want to update dynamically in b.xls.
3) Enter the equals sign ("=").
4) Click on the "Window" menu in the top menu bar.
5) Select a.xls from the bottom of the menu items in the Window menu.
6) Click on the cell that contains the data that you want.
7) Hit Enter.
If you do all of these steps, you should find yourself back in b.xls with Excel having created the right formula for you. As a test, you can switch to a.xls and make a change in the source cell, and then you should be able to switch back to b.xls and see that same update.

Good Luck, hope this meets your need!
Regards,
RichMTech

Hi Hss Holdings,

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table
table_to_check = the table you want to find the data from
column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.
range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here
B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)
G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)
etc

[formula in the new Category Column]

=RIGHT(A1,LEN(A1)-SEARCH(" ",A1,LEN(A1)-11))

Where A1 is the cell that stores the Business names.

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?

CHOSE THE PERTICULAR CELL WHERE THE SUM IS GOING TO BE DISPLAYED AND HYPERLINK IT IT WITH SHEET 2

Hi, I am not really sure if I get your exct meaning, so would I be correct in saying that you wish to copy all the data and structure from DCT INFO across to DCT. If this is correct so long as the dollar data is formatted in the first worksheet to currency then when it is pasted it will maintain its formating into the next sheet.

One question though...Do you wish to change the data on the DCT INFO sheet and wish it to be automatically changed in the DCT sheet?

If yes then you will have to write the following formula into the DCT cells:- =DCT INFO!A1 (where A1 is the first cell of data in sheet DCT INFO that you wish to duplicate.) You can then use auto fill by selecting the cell you just typed the formula in to and then placing the cursor onto the small black square in the righthand bottom of the cell and clicking the left mouse button and holding and dragging down to whereever your data ends. For example A30. Repeat this with the column B.
Let me know if tis is not entirelt what you require and I will try to help further.
Regards
SeaJade

at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks