I have no experience with VBA VLookUp functions.
I have built a dashboard that is updated each day.
It is about service tickets.
Each ticket has a serial number as an index and incrementing. I am adding comments and notes to each ticket in a specific column. Everything is stored on a daily sheet.
When I update the next day – I read all tickets from the on-line server, to a new sheet, and then I want to bring the comments from the recent sheet.
I would like to learn how to use Look Up functions to copy all the old comment to their respective rows (indexed) on the new sheet.
I would also be happy to learn how to copy the formatting of the comments.
Hi,
You haven't supplied any data so it's hard to understand what your data looks like.
Please, always supply sample data and show your expected result.
I don't know why you want to use VLOOKUP or VBA for this. Sounds like Power Query would do the job. But maybe I don't fully understand what it is you want to do.
Please supply those sample files.
Regards
Phil
If you still think you need to use VBA and Vlookup after reading Philip's post then look at this link for a quick tutorial
http://www.cpearson.com/Excel/CallingWorksheetFunctionsInVBA.aspx
