I'm trying to find a solution to an issue
I have a user enter an employee numbers in column I and could be as many as 14500 rows..I have a drop down in column J which is just from data validation.
I then autopulate columns K to T using a vlookup on the entries in column I
The issue I have is that the master dataset changes each month so an employee might be in Dept A this Month and Dept B next month so if I overwrite the masterdataset next month this will overwrite the original entry eg Dept A which I need...
I'm not sure if I am explaining too well...one question is that is there a way to freeze an entry as soon as vookup done and remove the vlookup formula after populated?
I might have to go down the route of various lookups for named ranges for each of the months but the datasets are big and around 14500 rows overall.
Not sure if there is a soultion for this but if anyone has any ideas I would be extremely grateful.
I have a user enter an employee numbers in column I and could be as many as 14500 rows..I have a drop down in column J which is just from data validation.
I then autopulate columns K to T using a vlookup on the entries in column I
The issue I have is that the master dataset changes each month so an employee might be in Dept A this Month and Dept B next month so if I overwrite the masterdataset next month this will overwrite the original entry eg Dept A which I need...
I'm not sure if I am explaining too well...one question is that is there a way to freeze an entry as soon as vookup done and remove the vlookup formula after populated?
I might have to go down the route of various lookups for named ranges for each of the months but the datasets are big and around 14500 rows overall.
Not sure if there is a soultion for this but if anyone has any ideas I would be extremely grateful.