Question about Microsoft Office Standard for PC

1 Answer

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

1 Answer

  • 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
  • 17 Answers

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

What are the formulas in grading the grades uisng microsoft excel


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

1 Answer

Formula for cell that is not blank


You can use IF and ISBLANK. Put this formula on Sheet 1 D1:

=IF(ISBLANK(Sheet3!AM2),"x","")

You can replace "x" by any other value you need.

Mar 04, 2010 | Microsoft Excel for PC

1 Answer

What is the use of vlookup in excel?


The VLOOKUP function is a handy one to know when you want Excel to lookup a value in one place and insert it in another. For example, let’s say you have a list of all of your customers on a sheet named “Accounts” and an invoice on another sheet named “Invoice”. When you type in their account number on the Invoice, you want Excel to fill in the name of the customer and their address (and this information is included for all customers on the Accounts sheet). A VLOOKUP will do this for you.

Here's a tutorial that will help:

http://www.timeatlas.com/mos/5_Minute_Tips/General/Learning_VLOOKUP_in_Excel/

Jun 12, 2009 | Microsoft Excel for PC

1 Answer

SERIAL NO OF BILL


Place the numer to be update in one cel
In anither cel say cel=cel+1 because of the alpha "S" here you need to combine 2 things.
3 formulas in excel.
right string
add 1 to val(3charactersfromright)
combining s with converted new serialnumer
Personally I prefer Foxpro for these tasks.
For large amount of numbers this is no excel task.
Have no english excel here. Look up the easy function types.
You need no visual basic for this.

Apr 10, 2009 | Microsoft Excel for PC

1 Answer

Excel formula related to a date range


Use the IF and Date functions together. On sheet 3, put the birthday (3/15/1954) in cell B1, put the beginning date (1/1/1946) in cell C1 and the ending date (12/31/1964) in cell D1.
Then on Sheet 1, but the following formula in the cell you want an X to be placed in.
=IF(AND(Sheet3!B1>=Sheet3!C1,(Sheet3!B1<=Sheet3!D1)),"X"," ").
Make sure you type the formula Exactly as it appears.

Mar 20, 2009 | Oracle Database Enterprise Named User Plus

2 Answers

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 Business & Productivity Software

5 Answers

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

Muhammad Waseem Alvi
Software Configuration Management Engineer
Lahore - Pakistan

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

1 Answer

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)
That will add 3 years.

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

2 Answers

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

1 Answer

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

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

88 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...