Marco to perform vlookup and copy and paste in new worksheet

[teton88]

hi,

I have two reports that I need to run every day, I'm trying to create a macro that would run a vlookup formula using information in one report as the lookup value and information in the other report as the table array and then copy and paste any return values into a new workbook.

The report name containing the information with the look up value is Detail Values and using the values in column K and the report that I want to see if the values are in (table array) would be Inventory Report, column R.

I would like any returned values to be copied and pasted into a new workbook and labeled "Room Issues"

All the reports will be saved in the same folder: C:\Rooms Reports, so not sure the best way to go about accomplish this task.

[daffodil11]

We'd need to know the full table array address and what nth column you're trying to return.

Where are these reports? Are they different files or different tabs? Where do the values you're looking up begin in K? When you output to the new workbook, where do you want them?

Assuming you provide the necessary details, something along the lines of:

Please Login or Register  to view this content.