| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Pulling Cells from Different Tabs and Files
The first file 2 should say file 1.
"bscuga" wrote: I want to have a formula that I can automatically pull cell c100 from tab 1, tab 2, etc...from file 2 and pull cell d87 from tab 1, tab 2, etc... from file #2. How do I automate this like when you create a regular formula using the same tab and dragging and Excel populates the new cells with the new formulas (for example: first formula is a1-b1, second formula is a2-b2). I want the formula to automatically be like =[file 1]tab1!$c$100/1000 for formula 1 and formula 2 to be =tab1!$d$87/1000. The second set of formulas should be =[file 1]tab2!$c$100/1000 and =tab2!$d$87/1000. I want as I drag, to have the tabs automatically change. Does anyone know how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot pulling Multiple tabs | Excel Worksheet Functions | |||
| pulling data automatically from one spreadsheet to another | Excel Worksheet Functions | |||
| pulling data from one file to another automatically | Excel Discussion (Misc queries) | |||
| Pulling info from multiple worksheet tabs? | Excel Discussion (Misc queries) | |||
| automatically updating cells in other files. | Excel Discussion (Misc queries) | |||
Hybrid Mode
