Hi Hui, thank you for the information... the header is included in case a report/pivot needs to be created by the end user. I have attached the excel file. i have no idea how to write the code to do the vlookup... do you have any existing make that i can edit to make it work with my data?
I don't know how to use the vlookup(concatenate) function using bva.
I need to use the values in column b and column c.
then I need to go to the list in i2:j3 (or this list can be located in sheet2) to match the values which have been concatenated.
Then i need to copy and paste the result in...
Hi, here is a sample of the data,
I don't know how to use the vlookup and concatenate function in VBA.
I need to place the result in E2. read some example but the code gets too complicated... i need to keep it clean and simple.
thanks!!
I need to a code vbs in excel that will find an specific value (TI), copy the row with the value and the row above, and paste into a new worksheet, then it needs to loop back and find the next instance and do the same task.
5209845561ab u m aaa-aaa HU CI 4/19/2013 21:24 4/19/2013 21:24...