TonySondergeld
New Member
- Joined
- Jul 11, 2009
- Messages
- 31
I have a little trouble with this one.
I have three combo box that I required the value of each box to lookup the data in Sheet 1 Column E, F, G and when a match is found return row number so that all data in Column H, I, j, k, L are placed to Sheet 2 in the next available empty row.
However the returned data has to be placed into the required data table so Column H go to Sheet 2 column E and I to G, J To I, K to D and L TO J. I hope this enough info here let us know if more is required.
Thanks for the help to anyone who any answer can one.
I have three combo box that I required the value of each box to lookup the data in Sheet 1 Column E, F, G and when a match is found return row number so that all data in Column H, I, j, k, L are placed to Sheet 2 in the next available empty row.
However the returned data has to be placed into the required data table so Column H go to Sheet 2 column E and I to G, J To I, K to D and L TO J. I hope this enough info here let us know if more is required.
Thanks for the help to anyone who any answer can one.