JV, if I understand your question properly it seems to me that a COPY, PASTE
SPECIAL, PASTE LINK would do the trick.

Gilles
"jv" wrote in message
...
I have a worksheet that I have to adjust the information to get the results
I
need. I them want toi create another workbook putting the results in
certin
columns.

first workbook
columa a
last name first name first name
Column b
foumula to move just last name
Column c
Formula to move first name first name

New Work book

column d last name
column e first name first name