I have an macro but I need to modify it to the autofilter value will be the content of a cell in an other worksheet. I upload a little sample also.
The autolfilter value could be the B2 cell in "Loading prg" worksheet.
Please Login or Register to view this content.
Last edited by ccsmith; 02-01-2011 at 09:45 AM.
Your example indicates the criteria was in C1 so this should work:
Please Login or Register to view this content.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thank you for your prompt reply. It is working perfectly.
Can you also give me an solution if the value is greater than cell C1 on the other worksheet?
Example: autofilter value >6 (every value which is greater than it)
Just this:
Please Login or Register to view this content.
Dom
Thank you. Great work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks