If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
Rapid input Via datasheet | RudyR_Seattle | General Discussion | 4 | January 31st, 2005 01:33 AM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |