Question about Microsoft Office Standard for PC

How do I add a number from one work sheet to another in excel ?

Example wrksheet 1 (P1=2) need P1 in work sheet 2 to =3

Posted by on

• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

You can access numbers from another worksheet by using the formula (=SheetName!P1)
That would access cell P1 on the worksheet called "SheetName"

Posted on Jan 12, 2009

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

Related Questions:

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

1. All formulas begin with an equals sign (=).
2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
3. Other formulas refer to different functions such as SUM, AVERAGE and others.
For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
4. Formulas can be combined with operands.
For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
5. Functions can be nested within each other.
For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

How do you calculate the cubed root of a number or 5th root of a number?

For cube roots, use the cube-root function in the MATH menu. For example, to calculate the cube root of 8, press MATH 4 8 =

For other roots (including cube root), use the xth-root function in the MATH menu. For example, to calculate the fifth root of 32, press 5 MATH 4 3 2 =

Mar 02, 2011 | Texas Instruments TI-83 Plus Calculator

I Have list of numbers in coloumn in a sheet & i want its uniqe record in another sheet how it to do?

You can use some add in for Excell, can be found much of them on internet. Or follow this instruction: http://www.cpearson.com/excel/Duplicates.aspx for any brainstorming :)

Mar 11, 2009 | Microsoft Computers & Internet

Excel System error &H80004005 error

Hello dear
I am also getting same issue on excel so I was getting many problem to work in MS Excel 2007. So I have solved it this issue and I am happy to share the solution with you all.

Solution:

• Click on Excel Button which are displaying on left top corner.
• Click on Excel Options.
• Then click on Add-Ins option.
• You can find a Manage field in the bottom. Select Excel Add-Ins and click on Go button
• You will find a Add-Ins window. Please un-check all Add-Ins except Analysis toolpak and Analysis toolpak VBA.
• Click on OK button.
• Close excel file and open again excel file.
Now you will resolve this issue and didnt get any problem again.

Thanks

Software Configuration Management Engineer
Lahore - Pakistan

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

Need to Add Dates in Excel

Here is one way I just tried:

Say the date purchased is in A1.

You want the Est Life in A2.

In A2 type: =A1+(3*365)

For 5 years: =A1+(5*365)

Try it out!

Note: You will need to format the cells to Custom>mm/dd/yyyy

Nov 21, 2008 | Microsoft Excel for PC

Excel formulas

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

Oct 09, 2008 | Microsoft Excel for PC

Excel question

You can import data from one sheet to another. If you want to bring a total from Sheet 1 to Sheet 2, then in Sheet 2 enter [=sheetname!cell] (without the brackets of course. You will now have the data from Sheet 1 in a cell in Sheet 2 and you can do anything you want with it. One note: if the sheet name has a space in it (Sheet Name) you have to enclose the name in single quotes; that tells it that the whole thing is the name. For example, Monthly Sales, A10 is the total for last month; to put it in this month for a running total, you would enter in Sheet 2 ['Monthly Sales'!A10] (without the brackets again). Now you can have a running total between the two sheets.

Aug 19, 2008 | Excel (SS8SATAS5128400R)

Reference other worksheet in excel

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

Mar 13, 2008 | Microsoft Excel for PC

Instructions
FAQ
Disclaimer

--------------------------------------------------------------------------------
Password recovery software (Word, Excel, Outlook, Exchange, Visual Basic modules, Access, Winzip, Lotus 1-2-3, Lotus Organizer, Lotus Wordpro, Backup, Project, FileMaker, Schedule+, Money, Paradox, Act!, Mail, Windows NT)
Instant password recovery (Instant online recovery service for password protected MS Word and Excel files. Free online preview of encrypted file content. )

NB! This program can't remove file protection, i.e. if you are unable to open the file, this program won't help you. You could try Excel Key to remove file protection. If you need to crack the VBA-password try this one.
This Excel add-in (password.xla) works fine in Excel 5.0 and above (including Excel 2000, XP and 2003).
This program will remove passwords of any length, also passwords containing special characters.

Feb 23, 2008 | Computers & Internet

Open Questions:

Related Topics:

88 people viewed this question

Level 3 Expert

Level 3 Expert