Hi,
I have a master sheet "hist" which has item ID, dataID,Type
and in workbook "Sam.xlsx" i have the same Item id's in column D
With column D(item ID) as refernce in sam.xlsx & i tried to bring dataID from "hist" doin a vlookup.
But this loops in hist only til the "D"row count of sam.xlsx I want it to check til the last row of hist sheet and apply the vlookup formula in sam.xlsx
but hist is updated each time, the row count increases.Please Login or Register to view this content.
Bookmarks