Im trying to use a VBA vlookup of sorts to copy and paste the value in CUSTOMERREVIEW!R29 to the correct row in CUSTOMERSUPPLIERPRODUCER Column O based on the value in CUSTOMERREVIEW!I5 and whenever the user changes the value by selectign a different customer in the list. Please help.
Better yet I almost have it figured out. I placed the code in the CUSTOMERSUPPLIERPRODUCER sheet. But I have to hit enter for it to work. Which is a problem because I use a drop down list to select a company which changes the value in I5. Any advice?
To solve the problem I got rid of the developer drop down list and used the Data List option, moved a round a few cells and walla. Problem solved. I still love this site, I'm getting better.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks