Question about Microsoft Computers & Internet

Khanpur,new delhi

110062

Hi,

I am sorry we didn't get the complete question? Kindy state that once again.

Thanks.

Posted on May 28, 2009

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

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

=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets

A2 is the cell I want to look up

Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $

2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns

0 is the value to complete the formula

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets

A2 is the cell I want to look up

Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $

2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns

0 is the value to complete the formula

Feb 11, 2009 | 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

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

Sep 16, 2008 | Microsoft Computers & Internet

washing machine is not working properly kindly advise who can repair in south delhi in Devli Village, Near Khanpur, New Delhi-110062

Jul 03, 2008 | Whirlpool Calypso GVW9959K Top Load Washer

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

It is actually very simple on the new worksheet in the first row just type:

in cell - A1: =[Book1]Sheet1!A1

in cell - B1: =[Book1]Sheet1!B1

in cell - C1: =[Book1]Sheet1!C1

etc.

Where Book1 is the worksheet(filename) and Sheet1 is the sheet with the data, just drag down the results with the magic square and continue to do so on all of your data worksheets.

Let me know if you need more help

and Please use our community and not emails

Good luck

Daniel

in cell - A1: =[Book1]Sheet1!A1

in cell - B1: =[Book1]Sheet1!B1

in cell - C1: =[Book1]Sheet1!C1

etc.

Where Book1 is the worksheet(filename) and Sheet1 is the sheet with the data, just drag down the results with the magic square and continue to do so on all of your data worksheets.

Let me know if you need more help

and Please use our community and not emails

Good luck

Daniel

Dec 18, 2007 | 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

Sep 13, 2017 | Microsoft Computers & Internet

17 people viewed this question

Usually answered in minutes!

×