Question about Microsoft Excel for PC

Ad

Just type on the cell you want to display it on sheet2: SUM(Sheet1!A1:A2)

"sheet1" is the name of the sheet where the data is "A1" is the beginning cell for the sum formula and "A2" is the end cell

Let me know if you need more information

Posted on Apr 23, 2008

Ad

Sort the number on cell as desending order

Posted on Apr 21, 2008

Ad

Table

Posted on Apr 15, 2008

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

Posted on Apr 12, 2008

Hi,

a 6ya Technician 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 repair professionals here in the US.

click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

cells are referenced by column and row. columns use a letter reference and rows use a number reference. to reference pages use the page name. For example if you are entering a formula in a cell on a page named sheet2 and part of the information is located on the page named sheet1, you would use a reference as follows:

sheet1!C3 This reference is for the cell on the page named sheet1 in the third column and the third row.

Hope this helps

sheet1!C3 This reference is for the cell on the page named sheet1 in the third column and the third row.

Hope this helps

Apr 09, 2014 | Microsoft Excel for PC

To have the contents of the cell change from something you input into something else, you would need to put in a macro using VBA. You'll need someone who knows VBA to help with that.

OR... It is a lot easier to get similar results, if you are ok with using a few more cells to do it. The item# will remain where it was entered, and the product name will have to go in a different cell. In that case, you can use a lookup formula.

To do this, lets say your item# is entered in cell 'Sheet1'!C1, and you want the product_name to display in cell 'Sheet1'!D1. On another sheet (lets say sheet2) In cells 'Sheet2'!A1:B5 input the item#'s in the first column (column A1:A5) and input the matching product-names in column B1:B5. This is your lookup data. This sheet can be hidden if you want In cell 'Sheet1'!D1, use a vlookup formula that will look at the item# and find a match in the list, and display the product name for you. =vlookup('Sheet1'!C1,'Sheet2'!$A$1:$B$5,2,false)

This will display N/A# if the number can't be found.

OR... It is a lot easier to get similar results, if you are ok with using a few more cells to do it. The item# will remain where it was entered, and the product name will have to go in a different cell. In that case, you can use a lookup formula.

To do this, lets say your item# is entered in cell 'Sheet1'!C1, and you want the product_name to display in cell 'Sheet1'!D1. On another sheet (lets say sheet2) In cells 'Sheet2'!A1:B5 input the item#'s in the first column (column A1:A5) and input the matching product-names in column B1:B5. This is your lookup data. This sheet can be hidden if you want In cell 'Sheet1'!D1, use a vlookup formula that will look at the item# and find a match in the list, and display the product name for you. =vlookup('Sheet1'!C1,'Sheet2'!$A$1:$B$5,2,false)

This will display N/A# if the number can't be found.

Feb 15, 2013 | Microsoft Excel for PC

Just put the following formula in the cell you want the number to change.

=sheet2!b1 the B1 is the cell on sheet 2 or whatever cell you want to link to. Whatever you put in cell B1 on sheet 2 will automatically change on the cell on sheet one you place this formula in.

=sheet2!b1 the B1 is the cell on sheet 2 or whatever cell you want to link to. Whatever you put in cell B1 on sheet 2 will automatically change on the cell on sheet one you place this formula in.

Apr 24, 2009 | Microsoft Excel 2003 (065-03992) for PC

Assumption:

**sheet2** cell **a1** like this:

**=IF(Sheet1!e1<>"",Sheet1!b1,"")**

The formula will check**sheet1 **cell **e1**, if there is any number or text put in there, the value of **Sheet1 **cell **b1 **will be copied to **sheet2 **cell **a1**. If you don't supply any number or text in **sheet1** cell **e1**, there's nothing will appeared in **sheet2 **cell **a1**.

If you want some text will display when there's no value in**sheet1** cell **e1 **just change the formula like this:

**=IF(Sheet1!e1<>"",Sheet1!b1,"NONE")**

You can modify it as your like. Just copy the formula to another row in**sheet2 **column **a**.

P.S.: If this information was helpful, please rate this solution.

- we work on
**sheet1**, cell**b1**as description of material and cell**e1**as quantity figure. - we will put the transfer the text in cell
**b1**to**sheet2**cell**a1**if you have entered some value in**sheet1**cell**e1.**Otherwise**sheet2**cell**a1**will left empty or display some text as**"NONE"**or as you wish.

The formula will check

If you want some text will display when there's no value in

You can modify it as your like. Just copy the formula to another row in

P.S.: If this information was helpful, please rate this solution.

Mar 12, 2009 | Microsoft Windows Vista Home Basic for PC

Go to the cell you want this total in.

Type this formula:

=SUM(IF(Sheet2!C1:C10="EME",IF(Sheet2!N1:N10=1,1,0)))

make sure you end the formula with CTRL - SHIFT - ENTER which makes it an array formula. If you forget, go back to the cell with this formula and press F2 (to edit the cell) and press CTRL - SHIFT - ENTER to convert it to an array formula (Excel will show a little {...} around the formula).

Type this formula:

=SUM(IF(Sheet2!C1:C10="EME",IF(Sheet2!N1:N10=1,1,0)))

make sure you end the formula with CTRL - SHIFT - ENTER which makes it an array formula. If you forget, go back to the cell with this formula and press F2 (to edit the cell) and press CTRL - SHIFT - ENTER to convert it to an array formula (Excel will show a little {...} around the formula).

Dec 21, 2008 | Microsoft Excel for PC

hello

yes it is.

example

sheet1

A1 (50)

A2 (50)

sheet2

(A1)=

"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1

ok let me explain

in A1 and A2 in sheet1 you got 50 and 50 like numbers.

in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.

did you get it?

dont know else how I should explain it...

good luck

yes it is.

example

sheet1

A1 (50)

A2 (50)

sheet2

(A1)=

"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1

ok let me explain

in A1 and A2 in sheet1 you got 50 and 50 like numbers.

in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.

did you get it?

dont know else how I should explain it...

good luck

Oct 09, 2008 | Microsoft Excel for PC

on sheet2!a1 type =sheet1!a1 - anything you type on sheet1!a1 will appear on sheet2!a1

Sep 17, 2008 | Computers & Internet

Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

eg if i want to add to numbers

in sheet 1 i have the value 20 in cell B3

in sheet 2 i have the value 10 in cell B4

thus the formula would be:

=sheet1!B3+sheet2!B4

in sheet 1 i have the value 20 in cell B3

in sheet 2 i have the value 10 in cell B4

thus the formula would be:

=sheet1!B3+sheet2!B4

Mar 13, 2008 | Microsoft Excel for PC

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

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

97 people viewed this question

Usually answered in minutes!

formula from which i can enter details from one sheet to another sheet automatically

×