Hi,
Is there a VBA alternative to using a frequently used look up table? E.g. In the look up table there would be 2 columns Directorate & DirCode, where Directorate is a full name and DirCode a code (in reality there would be further columns for other organisational levels).
Instead of me having to navigate to and open the file with the look up table, and then write out the vlookup formula, can I store this table in VBA and use it from there?
Many thanks.
You could read it in on workbook open, store in on a hidden sheet with a defined name, and use that name in the formulae.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Could that be stored in a PERSONAL file?
You could, but personally I would not. You could however save it in another Hidden workbook saved in your XLStart folder. That would give similar access to the data.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Ok, thanks guys. I'll look into these options.
Posting Permissions
Reply With Quote
