Problem with VLookup.....

[M G Henry]

I have a problem involving 2 workbooks... and I think that VLookup is
the answer however there is a glitch.

The first workbook had had people entering for a very very long time,
job number job description and job writer in that order... column a,
b, c respectively.

The second work book is going to pull information about specific jobs
based on the person that wrote them. so the order of the columns
would have to be job writer job number job description, or c,a,b

What I want to get is the order of columns reversed when I transfter
them to the second workbook.

I have a page that will hold an exact copy of the job log from the
first workbook that will be updated dynamically by a macro, however is
there a way to write something that will revise the order of the
columns so that in the second workbook, vlookup could be used to find
the data ? or is there an easier way to approach this....

Thank you in advance for your assistance.

 

[Pete_UK]

You can record a macro while you insert a new column A, then cut/paste
column D (the old column C) into this new column A, and then
incorporate the code into your existing macro.

Alternatively, you could use an INDEX/MATCH combination instead of
VLOOKUP, so that you dont need to move the columns at all.

Hope this helps.

Pete