| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting for calculations
I am setting up a standard for my office. I have electrical schedules on
multiple worksheets, and i would like to create another worksheet that would automatically pull information from specifics cell on all the other worksheets so i can run a calculation. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extracting for calculations
Can you please be a little more specific?
A formula such as =Sheet2!A1 will return whatever values is in A1 of Sheet2 to the cell holding the formula best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "blkscrpn5" wrote in message ... I am setting up a standard for my office. I have electrical schedules on multiple worksheets, and i would like to create another worksheet that would automatically pull information from specifics cell on all the other worksheets so i can run a calculation. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extracting for calculations
For This one project i had 35 worksheets that i would need to grab
information from 5 specific cells so that i can add or multiply certain factors. I know the formula =Sheet2!A1 would do the job, but with so many it is time consuming. What i am looking for is maybe a macro that will pull all the information to one location so i can calculate what i need to. "Bernard Liengme" wrote: Can you please be a little more specific? A formula such as =Sheet2!A1 will return whatever values is in A1 of Sheet2 to the cell holding the formula best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "blkscrpn5" wrote in message ... I am setting up a standard for my office. I have electrical schedules on multiple worksheets, and i would like to create another worksheet that would automatically pull information from specifics cell on all the other worksheets so i can run a calculation. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extracting for calculations
=SUM(Sheet1:Sheet5!A1)
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "blkscrpn5" wrote in message ... For This one project i had 35 worksheets that i would need to grab information from 5 specific cells so that i can add or multiply certain factors. I know the formula =Sheet2!A1 would do the job, but with so many it is time consuming. What i am looking for is maybe a macro that will pull all the information to one location so i can calculate what i need to. "Bernard Liengme" wrote: Can you please be a little more specific? A formula such as =Sheet2!A1 will return whatever values is in A1 of Sheet2 to the cell holding the formula best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "blkscrpn5" wrote in message ... I am setting up a standard for my office. I have electrical schedules on multiple worksheets, and i would like to create another worksheet that would automatically pull information from specifics cell on all the other worksheets so i can run a calculation. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting First Name | New Users to Excel | |||
| extracting last name | Excel Worksheet Functions | |||
| extracting dd from dd/mm/yy | Excel Worksheet Functions | |||
| extracting IF | Excel Programming | |||
| extracting IF | Excel Programming | |||
Linear Mode
