I have a workbook that has 6 sheets the personnel sheet has dropdown list from b10-b65 and I need it to auto populate c and d from data in employees sheet e and f if the name matches from employees sheet a2-a188... can this be done?
I have a workbook that has 6 sheets the personnel sheet has dropdown list from b10-b65 and I need it to auto populate c and d from data in employees sheet e and f if the name matches from employees sheet a2-a188... can this be done?
Consider using the VLOOKUP formula - See Excel help for details.
Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks