If I could get the codes in columns E7-I7 to populate after a drop down selection is made from the column in A1, then I could upload into our accounting system. I have over 300 of these to enter each month for different locations. I don't have any experience in Macros, but certainly willing to learn. Thanks for your help!
Please also add manualy the expected result in your file.
what is the record in A1?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
A1-A25 are the various types of Revenue that comes into our clubs. I would like to make a drop down box that our clubs could just click on and add the amount paid and the codes to the right would populate when they select the revenue source from the drop down. Thank you for your help!
Think this can be solved with using vlookup formula's in E7:I7 but will need The revérence mapping between The drop down possibilities in column A and the corresponding codes for columns e through I.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks