How would I go about writing a macro can for a number like 950 put in the cell next to it HR and for 970 put in Accounting and so on so forth. I need it to fill in Dept name based on what is in column A.
How the spread sheet is set up
Column A Column B
Dept # Dept Name
950 HR
980
960
970 Accounting
999
So do you have a list of codes and departments in your spreadsheet like the example above? Assuming that list is in column D and E say then you can just use VLOOOKUP
in B2 enter
and drag down
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
I do have a list of codes, the reason i want a macro is because I am putting together one big macro to do a bunch of stuff on this one spread sheet. So this is part of it after it runs this it will do something else.
to use it in VBA refer to it using WorksheetFunction.Vlookup
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks