Extracting for calculations

B

blkscrpn5

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.
 
B

Bernard Liengme

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
 
B

blkscrpn5

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Macro... 8
Combining Multilple Worksheets Into One 6
Combo box selection will not calculate 5
Running macro operations in serial fashion 6
Creating different worksheets from a main worksheet 3
Copy and paste same cell from a number of sheets into a new sheet 3
Duplicating worksheet based on range and changing worksheet name 3
How to update all links before re-calculation for macro? 1

Top