I have worksheet one & worksheet 2. I want to compare the data from worksheet 1 to worksheet 2 but some of the data from worksheet 1 are not available in worksheet 2. How do i do that?

It depends on what your doing, lets just say you want to compare two curves to the same data. First off save the fitted valurs from each model in the worksheet, which you can do by checking the "fits" in the storage dialog. Save the fits for all models you want to compare which I call fit1 and fits 2.
Then you create a scaterplot and display the
Following pairs, original response and predictor data. Fits 1 predictor data fits 2 predictor be sure to check overlaid on the same graph on the multiple graphs dialog. After you create a graph you need to teek it by adding connect lines. Click on the data point on the scatterplotin the menu choose, edit> Add> data display "connect line". This will connect lines to all your datasets, unfortunately you don't want that don't sweat it easy fix to make that go bye bye slowly double click on the connect lines on the original data, which selects the specific connect line, if you do it to fast it will bring up the dialog to edit all connect lines so slowly double click you know like a finger spasm lol. Anyways right click and choose edit connect lines choose custom scroll up and choose none and thats it tour done. Hope this helped

The calculator has different worksheets.
To access TVM worksheet, press [2nd] and any TVM key : N, I/Y, PV, PMT or FV
To enter Amortization worksheet, press [2nd][AMORT]
To access Cash Flow (problem with unequal cash flows) Press CF, or NPV, or CPT or IRR
To access BOND worksheets press [2nd][BND]
For depreciation worksheets press [2nd][DPR]
For statistics, use [2nd][DATA], or [2nd][STAT].
There are other worksheets [2nd][Delta%], [2nd][DATE], [2nd][PROFIT], [2nd][BRKEVN],[2nd][MEMory].

These shortcuts will not get you anywhere if you do not consult the manual.

hi Samajane,

I understand the you excel file has data that is stored column wise. Well you can first convert the column wise data to row wise data and then import it to you word.

To convert the column wise data to row wise data.
1.Select the data in your worksheet.
2.Right Click -> Copy
3.Create a blank worksheet.
4.Goto Edit - > Paste Special
5.Check the Transponse Option
6.Press OK.

Now you have converted your column wise data to row wise data and now u can import it to your word and print mailing labels

Try this:
1. Find the copy of the workbook on which you will merge the changes. In Excel, go to "File > Open" and find the file.
3. Click "Tools > Compare" and "Merge Workbooks." 4. Look for the files you want to merge and add them into the current file. 5. Click “OK” to merge the files. This is your master copy of this workbook. 6. Save the file.

=if(isblank(vlookup(Sheet1!A1,Sheet2!$A$1:$B$4,2,0)),"",vlookup(Sheet1!A1,Sheet2!$A$1:$B$4,2,0))

Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

it sounds like you are going over the limits of the program these are the specs. I would recommend dividing up the data if you can. or moving it to a database that can act like excel and hold more data.

1. Open up both workbooks.
2. Copy one worksheet from one workbook to another using.
Right click on the tab of one book and Select "Move or Copy"
3. A dialog box will appear..Next to the "To book" select the workbook you want to move it to.
4. Be sure to select the 'create a copy' box in the bottom left of the dialog box.
5. Sort each worksheet by students name. Data..Sort.
6. Copy the scores from one sheet to another.
7. You then you can manipulate the scores and compare anyway you like by using formulas in different columns.

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?

You can add a reference from the worksheet 1 to all other worksheets

Is it OK?