| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy data across workbooks
I want to create a master workbook with data entered for multiple divisions
and create a summary page that will auto update when the master is updated. I have tried a simple =, but it will only bring 1 cell at a time. When I drag from the right corner it just repeats that first cell or if I pull a few cells and high all and drag it repeats those cells. How can I copy multiple rows and columns? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copy data across workbooks
Not sure I completely understand your problem, but it sounds to me like your
formulas are absolute. In other words, when you are typing in the formula it looks something like =[Book1]Sheet1!$A$1. If you take out the dollar signs in front of the column letter and row number, I bet you solve some of your copying problem. "Copy multiple cells" wrote: I want to create a master workbook with data entered for multiple divisions and create a summary page that will auto update when the master is updated. I have tried a simple =, but it will only bring 1 cell at a time. When I drag from the right corner it just repeats that first cell or if I pull a few cells and high all and drag it repeats those cells. How can I copy multiple rows and columns? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copy data across workbooks
Maybe also check ToolsOptionsCalculation to make sure you are set to
"Automatic" Gord Dibben MS Excel MVP On Wed, 11 Jan 2006 11:54:02 -0800, "chi_town_eric" wrote: Not sure I completely understand your problem, but it sounds to me like your formulas are absolute. In other words, when you are typing in the formula it looks something like =[Book1]Sheet1!$A$1. If you take out the dollar signs in front of the column letter and row number, I bet you solve some of your copying problem. "Copy multiple cells" wrote: I want to create a master workbook with data entered for multiple divisions and create a summary page that will auto update when the master is updated. I have tried a simple =, but it will only bring 1 cell at a time. When I drag from the right corner it just repeats that first cell or if I pull a few cells and high all and drag it repeats those cells. How can I copy multiple rows and columns? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| combining and sorting data from two workbooks | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Macro to Synchronize data frm svrl workbooks & columns to 1 workbo | Excel Discussion (Misc queries) | |||
| Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
Linear Mode
