importing data...keeping data on same row

S

shamee

If I import some data through a database query.....and that query take
up 5 colums and x number of rows. If I want to put my own data i
column 6 that relates each row.....how do I format the cell/column s
that it always moves with the row if my query returns the row in
different place than first time.... I hope I am making sense!

thanks a bunch...I'll sure try to repay the favor
 
D

Dave Peterson

Is there a unique key in your data?

maybe you could use a separate worksheet, populate it with all your data. Then
put an =vlookup() in that 6th column to retrieve your data based on that key
value.
 
Top