Sleeper: VBA macro instead of IF statements?

[beni]

Hi-

Workbook1 contains the source data:

Column A (ID)/column B (authorName)/column C (title)/...
2/John Doe/Gardening
3/Jane Doe/Plants
3/M. Smith/Trees
...
The data needs to be returned to workbook2 and placed in *specific* columns depending on the ID value. The 'authorName' should always be returned to column 1; but the location of 'title' varies depending on the ID:

So, if the ID in book1 is 3, then in book2 place 'authorName' in column 1 and 'title' in column 3; if the ID is 2, return data to columns 1 and 5.

Is there a macro that will do this? Thanks!

[venkat1926]

i wonder how book1 will know that apple is a fruit. as you have configured you can only get either animal or car or fruit
no need for a macro use vlookup. introduce a first column for the numbers
so in book2 you have something like this

A pdf animals/cars/fruits
3
=VLOOKUP(A2,[Book1.xls]Sheet1!$A$1:$C$7,2,FALSE)

=VLOOKUP(A2,[Book1. xls]Sheet1!$A$1: $C$7,3,FALSE)

[beni]

I edited my original post to better explain what I am trying to do. Thanks.