Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Moving data from one excel file to another
I would like to move data from excel file to another. I would like for the
existing data with column names to automatically fill into the second file with the same column names but in different column locations. I know I can cut and paste...but can I just match fields like when I work with databases?? Is this possible? Thanks, H |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Moving data from one excel file to another
Yes, easier to follow along once and see how it's done:
Open both workbooks involved. Lets say that you want the contents from Book1 on Sheet1 in cell A1 on a sheet in Book2 at H1. In Book2 go to the sheet and cell H1 and type in an = symbol Select Book1 and go to Sheet1 and then click cell A1 and press the [Enter] key. If you look at H1 in Book2, the formula will look like this: =[Book1]Sheet1!$A$1 You could have typed that all in by hand if you wanted to, but the method just given is 'safe' and guarantees that the formula is written properly - important for early use. Now you could 'fill' this formula on down column H in Book2 to (try) to copy all of the things in column A over in Book1. Won't quite work yet - you need to change the address of the cell from absolute (with the $ symbols), to relative (without one or both of them). Removing the $ from in front of the A (A$1) will permit the column to adjust if you fill to the right in Book2, removing the $ from in front of the 1 ($A1) will let the row number increase as you fill the formula down the sheet in Book2. If you remove them both (A1), then you can fill both to the right and down the sheet in Book2 and retrieve all of the results over in Book2. Hope this helps. "audif" wrote: I would like to move data from excel file to another. I would like for the existing data with column names to automatically fill into the second file with the same column names but in different column locations. I know I can cut and paste...but can I just match fields like when I work with databases?? Is this possible? Thanks, H |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Moving data from one excel file to another
Works out great...thanks for the assist!
"JLatham" wrote: Yes, easier to follow along once and see how it's done: Open both workbooks involved. Lets say that you want the contents from Book1 on Sheet1 in cell A1 on a sheet in Book2 at H1. In Book2 go to the sheet and cell H1 and type in an = symbol Select Book1 and go to Sheet1 and then click cell A1 and press the [Enter] key. If you look at H1 in Book2, the formula will look like this: =[Book1]Sheet1!$A$1 You could have typed that all in by hand if you wanted to, but the method just given is 'safe' and guarantees that the formula is written properly - important for early use. Now you could 'fill' this formula on down column H in Book2 to (try) to copy all of the things in column A over in Book1. Won't quite work yet - you need to change the address of the cell from absolute (with the $ symbols), to relative (without one or both of them). Removing the $ from in front of the A (A$1) will permit the column to adjust if you fill to the right in Book2, removing the $ from in front of the 1 ($A1) will let the row number increase as you fill the formula down the sheet in Book2. If you remove them both (A1), then you can fill both to the right and down the sheet in Book2 and retrieve all of the results over in Book2. Hope this helps. "audif" wrote: I would like to move data from excel file to another. I would like for the existing data with column names to automatically fill into the second file with the same column names but in different column locations. I know I can cut and paste...but can I just match fields like when I work with databases?? Is this possible? Thanks, H |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Moving data from one excel file to another
Works out great, thanks for the assist!
"JLatham" wrote: Yes, easier to follow along once and see how it's done: Open both workbooks involved. Lets say that you want the contents from Book1 on Sheet1 in cell A1 on a sheet in Book2 at H1. In Book2 go to the sheet and cell H1 and type in an = symbol Select Book1 and go to Sheet1 and then click cell A1 and press the [Enter] key. If you look at H1 in Book2, the formula will look like this: =[Book1]Sheet1!$A$1 You could have typed that all in by hand if you wanted to, but the method just given is 'safe' and guarantees that the formula is written properly - important for early use. Now you could 'fill' this formula on down column H in Book2 to (try) to copy all of the things in column A over in Book1. Won't quite work yet - you need to change the address of the cell from absolute (with the $ symbols), to relative (without one or both of them). Removing the $ from in front of the A (A$1) will permit the column to adjust if you fill to the right in Book2, removing the $ from in front of the 1 ($A1) will let the row number increase as you fill the formula down the sheet in Book2. If you remove them both (A1), then you can fill both to the right and down the sheet in Book2 and retrieve all of the results over in Book2. Hope this helps. "audif" wrote: I would like to move data from excel file to another. I would like for the existing data with column names to automatically fill into the second file with the same column names but in different column locations. I know I can cut and paste...but can I just match fields like when I work with databases?? Is this possible? Thanks, H |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Moving data from one excel file to another
You're welcome. Generally this is called 'linking' between two workbooks.
The info in the 2nd workbook will always reflect the content of the original as long as the original is available to update thru the links. "audif" wrote: Works out great, thanks for the assist! "JLatham" wrote: Yes, easier to follow along once and see how it's done: Open both workbooks involved. Lets say that you want the contents from Book1 on Sheet1 in cell A1 on a sheet in Book2 at H1. In Book2 go to the sheet and cell H1 and type in an = symbol Select Book1 and go to Sheet1 and then click cell A1 and press the [Enter] key. If you look at H1 in Book2, the formula will look like this: =[Book1]Sheet1!$A$1 You could have typed that all in by hand if you wanted to, but the method just given is 'safe' and guarantees that the formula is written properly - important for early use. Now you could 'fill' this formula on down column H in Book2 to (try) to copy all of the things in column A over in Book1. Won't quite work yet - you need to change the address of the cell from absolute (with the $ symbols), to relative (without one or both of them). Removing the $ from in front of the A (A$1) will permit the column to adjust if you fill to the right in Book2, removing the $ from in front of the 1 ($A1) will let the row number increase as you fill the formula down the sheet in Book2. If you remove them both (A1), then you can fill both to the right and down the sheet in Book2 and retrieve all of the results over in Book2. Hope this helps. "audif" wrote: I would like to move data from excel file to another. I would like for the existing data with column names to automatically fill into the second file with the same column names but in different column locations. I know I can cut and paste...but can I just match fields like when I work with databases?? Is this possible? Thanks, H |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
Moving a sheet from one Excel file to another? | Excel Discussion (Misc queries) | |||
How can I get a moving Clip art o move in my Excel file??? | Excel Discussion (Misc queries) | |||
moving file from excel to word | Excel Discussion (Misc queries) | |||
I lose cell comments in Excel when moving a file via a USb drive | Excel Discussion (Misc queries) |