I am working on consolidation of all sheets and map previously consolidated status,

I have one code which is working perfectly till consolidation, now i need a code to vlookup a status from previous consolidated sheet to current consolidated sheet.

-- This is previous consolidated sheet
Untitled.png

-- Current consolidated sheet
Untitledt.png

I want to map if data is there after column C in previous sheet with headings to current sheet starting from D column. I am able to map column D with my code but i need to map rest of the non-blank columns also.

Please Login or Register  to view this content.
Any help greatly appreciated.

thanks in advance.


Cross Post: https://chandoo.org/forum/threads/ma...-column.39604/

Cross Post: https://stackoverflow.com/questions/...ticular-column