Excel to Excel Import and Data Mapping

[Virginia]

I have a question and I haven't quite been able to find the answer.

I have an excel spreadsheet....It has 4 colums and each row has data:

Col1 Col2 Col3 Col4
Data1 Data2 Data3 Data4

I have a second excel spreadsheet that only has two colums and no rows of
data:

ColA ColB

What I want to do is import the data in Col1 and Col3 in my first
spreadsheet into ColA and ColB...so not only do I want to "import" the data I
need to be able to map the columns.

So far, all I've been able to do is import all four columns into my second
spreadsheet.

Yes..cut and past might work...but the data is associated so I'm trying to
figure out how to "map" between the two.

This is Excel 2007.

Any suggestions or links to information will be greatly appreciated!
Thanks!
V

 

[Rich/rerat]

Virginia,
If you are going to still going to enter data on sheet1, and want to have Col1 &
Col3 from Sheet1 reflected on Sheet2, you can link those sheets.

On Sheet2

ROW1=Column Headers
A2 put: =IF(Sheet1!$A2="","",Sheet1!$A2) then drag down the column
B2 put" =IF(Sheet1!$c2="","",Sheet1!$c2) then drag down the column

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


I have a question and I haven't quite been able to find the answer.

I have an excel spreadsheet....It has 4 colums and each row has data:

Col1 Col2 Col3 Col4
Data1 Data2 Data3 Data4

I have a second excel spreadsheet that only has two colums and no rows of
data:

ColA ColB

What I want to do is import the data in Col1 and Col3 in my first
spreadsheet into ColA and ColB...so not only do I want to "import" the data I
need to be able to map the columns.

So far, all I've been able to do is import all four columns into my second
spreadsheet.

Yes..cut and past might work...but the data is associated so I'm trying to
figure out how to "map" between the two.

This is Excel 2007.

Any suggestions or links to information will be greatly appreciated!
Thanks!
V