Question about Microsoft Office Excel 2003 for PC

4 Answers

How to connect one sheet to another sheet

Connect

Posted by on

  • arbs Jan 28, 2009

    how to copy datas and formulas from a sheet to other sheet



  • Danny Durbin
    Danny Durbin Jul 01, 2014

    You can either do as what is described in solution #2 or you can go to cell you want to copy, copy the contents in the cell and then go to the sheet you want the data and formulas copied and do a paste function.

×

4 Answers

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

How i connect one excel sheet to another excel

Posted on Feb 02, 2009

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 67 Answers

If you have a cell need to get a value from another sheet this is the formula. Like, if you have a cell in the sheet1 one and it need to be equal to the cell in the sheet 2 and the source cell number is D4, this what you put in the cell.
=Sheet2!D4

Posted on Feb 20, 2009

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

How to connect one sheet to anothr sheet in microsoft excel?

Posted on Jan 13, 2009

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Just what are you wishing to do, when you say connect one sheet to another

Posted on Dec 21, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Tools protect workbook& sheet


Open the protected sheet... Go to edit and click select all. Go back to edit and click on copy. Open a new excel sheet, go to edit and click on paste. Now you have the copy of the protected sheet without the protection.

Jan 23, 2009 | Steinberg Cubase Studio 4 Upgrade Version...

1 Answer

Excel 2003 / 2007 vba code


A similiar thing happened to me once and I used the format
"Sheets("Lab Work Order Master").Copy(,ActiveSheet)" instead of
"Sheets("Lab Work Order Master").Copy After:=ActiveSheet"

You may also want to try using a sheet index instead of "ActiveSheet" to refer to your sheet.
P.S. Don't forget to rate me. Wish you the best.

Oct 17, 2008 | Microsoft Office Standard for PC

2 Answers

Excel formulas


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.

Sep 13, 2008 | Microsoft Computers & Internet

3 Answers

Excel 2007


default.aspx?assetid=za790050001033Show All default.aspx?assetid=za790050011033Hide All
  1. Select the sheets on which you want to change the gridline color. default.aspx?assetid=za790050001033How?
    When you enter or change data, the changes affect all selected sheets. These changes may replace data on the active sheet and other selected sheets.
    To select Do this A single sheet Click the sheet tab. default.aspx?assetid=za060521711033 If you don't see the tab you want, click the tab scrolling buttons to display the tab, and then click the tab.
    default.aspx?assetid=za060521061033 Two or more adjacent sheets Click the tab for the first sheet, and then hold down SHIFT and click the tab for the last sheet. Two or more nonadjacent sheets Click the tab for the first sheet, and then hold down CTRL and click the tabs for the other sheets. All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.). Note If sheet tabs have been color-coded, the sheet tab name will be underlined in a user-specified color when selected. If the sheet tab is displayed with a background color, the sheet has not been selected.
    default.aspx?assetid=za790050001033Cancel a selection of multiple sheets
    To cancel a selection of multiple sheets in a workbook, click any unselected sheet.
    If no unselected sheet is visible, right-click the tab of a selected sheet. Then click Ungroup Sheets on the shortcut menu.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, click the color you want in the Color box. To use the default gridline color, click Automatic.

Jan 18, 2008 | Microsoft Office Professional 2007 Full...

5 Answers

Formula required


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

Dec 04, 2007 | Microsoft Excel for PC

1 Answer

Formula


You can copy any selected cell(s), and then in the sheet you want a link in, select 'Paste Special' from the Edit menu, and then choose 'Paste Link.' I have assumed that you're working in Excel, since you mentioned sheets. The pasted link will update any time you open the second sheet with the links in it.

Oct 13, 2007 | Microsoft Office Standard for PC

1 Answer

Excel Sort Across Sheets


Hi Raymond, I have a solution for you. Asuming your 'main' sheet is Sheet1. On Sheet2, in the same line as your data on sheet1 (i.e. A5 on sheet1 is JIM), then on A5 on sheet2, enter a link ( the = ) and enter. copy this formula down. Do the same with Sheet3 linking to Sheet1. When you sort Sheet1, Sheet 2 and 3 will follow. Hope this helps. Regards DeltaC

Sep 11, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Excel 2003 for PC Logo

Related Topics:

412 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18333 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...