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.
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
Bookmarks