Yusuf
Active Member
- Joined
- Jun 1, 2004
- Messages
- 337
Hi everyone
I need to find the last cell to the right and enter a value in the cell after this.
But first, I have to find the correct match down. (This I can do, but not including the bit above, xlup...)
Example.
A1 = cat & A2 = Brown
A3 = dog
A4 = rabbit
A5 = cat & B5 = Grey
If Column B, C, D etc... have values alongside the names in ColA, then the code must find the first empty cell and fill it with A2.Value
The result in this example will mean that Cell C5 = 'Brown'
Any help with this will be much appreciated
Yusuf
I need to find the last cell to the right and enter a value in the cell after this.
But first, I have to find the correct match down. (This I can do, but not including the bit above, xlup...)
Example.
A1 = cat & A2 = Brown
A3 = dog
A4 = rabbit
A5 = cat & B5 = Grey
If Column B, C, D etc... have values alongside the names in ColA, then the code must find the first empty cell and fill it with A2.Value
The result in this example will mean that Cell C5 = 'Brown'
Any help with this will be much appreciated
Yusuf