Vlookup between two sheets with in a workbook to pick latest value via VBA

[Anand307]

Hello

I am looking for a specific issue to resolve with the help of VBA,

· We have two sheets within the same workbook

· “Consolidated sheet has the latest data in it, now we need a vlookup via VBA to update the figures in column I , J and K in “Archived Breaks” tab from “Consolidated Sheet” tab, We can use the below as unique identifier

TAB name

Consolidated Sheet

Archived Breaks

Unique Identifier

CPID

CPID

Column

E

G


· After vlookup is complete paste special the values for three column I , J and K in “Archived Breaks” tab.

· Last step, now the unique ID’s that are present on “Archived Breaks” tab needs to be found on “Consolidated Sheet” and delete the rows in “Consolidated Sheet” .

· Remove filter.

 

[Anand307]

Sorry the Unique ID format above might be confusing. Please refer the below details with easy notes.

· We have two sheets within the same workbook

· “Consolidated sheet has the latest data in it, now we need a vlookup via VBA to update the figures in column I , J and K in “Archived Breaks” tab from “Consolidated Sheet” tab, We can use the below as unique identifier

TAB name - Consolidated Sheet Archived Breaks
Unique Identifier - CPID CPID
Column - E G
Notes ( In “Consolidated Sheet” tab we use Column “E” as unique ID and in “Archived Breaks” tab we use column “G” as unique ID)


· After vlookup is complete paste special the values for three column I , J and K in “Archived Breaks” tab.

· Last step, now the unique ID’s that are present on “Archived Breaks” tab needs to be found on “Consolidated Sheet” and delete the rows in “Consolidated Sheet” .

· Remove filter.

 

[Anand307]

somebody in forum please help. Metioned to remove filters in case added while deleting rows.