Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,365
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,365
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving a line chart data point revises data table value in Excel ' Ed Smith Charts and Charting in Excel 2 November 16th 12 02:03 PM
Moving a sheet from one Excel file to another? Kathy Excel Discussion (Misc queries) 6 April 28th 09 03:32 PM
How can I get a moving Clip art o move in my Excel file??? Jessica C. Jara Excel Discussion (Misc queries) 1 July 7th 06 06:15 PM
moving file from excel to word Clovis Excel Discussion (Misc queries) 2 April 8th 06 04:28 PM
I lose cell comments in Excel when moving a file via a USb drive Marvyn Excel Discussion (Misc queries) 0 January 19th 06 06:02 PM


All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"