|
| 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
January 11th, 2006, 07:16 PM
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
January 11th, 2006, 07:54 PM
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
January 12th, 2006, 12:20 AM
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?
|
| 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 |
Linear Mode
