MrTinkertrai
04-22-2008, 12:39 AM
Hi all,
I've got the following I want to achieve:
In cells A2:A41 i've got a list of 40 entries
In cells G2:G41 I have a VLOOKUP formula.
Some cells in G2:G41 give a #N/B when the VLOOKUP formula is applied.
I would like to make a macro which automatically copies the contents of the cells in A2:A41, whenever that particular cell in col G gives an #N/B.
Example:
Let's say in cells G23, G30, G35 and G38 give an # N/B.
I would like to automatically copy the contents of cell A23, A30, A35 and A38 copied starting in cell A44.
This one has kept me busy for a few days now, but I can't figure it out how to do it.
I hope I've made clear what I like to get done and I hope someone can help me out with this one.
Thanks in advance :yes
Greetz,
Mike
I've got the following I want to achieve:
In cells A2:A41 i've got a list of 40 entries
In cells G2:G41 I have a VLOOKUP formula.
Some cells in G2:G41 give a #N/B when the VLOOKUP formula is applied.
I would like to make a macro which automatically copies the contents of the cells in A2:A41, whenever that particular cell in col G gives an #N/B.
Example:
Let's say in cells G23, G30, G35 and G38 give an # N/B.
I would like to automatically copy the contents of cell A23, A30, A35 and A38 copied starting in cell A44.
This one has kept me busy for a few days now, but I can't figure it out how to do it.
I hope I've made clear what I like to get done and I hope someone can help me out with this one.
Thanks in advance :yes
Greetz,
Mike