Use combo box to have get a result. I upload my files help me please.
Good day. I’m using combo box but I don’t know to code it in macro anybody can help me please ??
I have 5 sheet named (HHS1(TP), HHS2(TP) , RESULT , HHS1(DC), HHS2(DC) ) The Result Sheet is the sheet that I want the code inside.
I want to paste the result for RATE PER TRIP, MOB , AND DEMOB. Im using combo box to see quickly the data I want to see. Thank you so much. I hope you can help me. Thanks GODBLESS always.
Hi Jason,
Instead of a bunch of combo boxes you might use a Pivot Table instead. See my new sheet called PT Answer where I've done the TS1 problem. Making the filters correct the values will show up. There is no code needed for the pivot tables. You can do 3 more Pivot Tables for the other three sheets if this answer works for you.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hello sir Marvin P how did you do that sir ??
Hi Jason,
Jump on YouTube and watch some of the Pivot Table videos. You have my example, so play with it using Excel 2013 and it might be easier than my trying to explain what I did.
ahh sir Marvin. Thanks for your idea, GODBLESS. actually the youtube here in our office is disable.
Hello Sir marvin I how move into filter Area the Field ? i get some error
adasd.jpg Here's my print screen sir.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks