Hi,
This is related to a post that was solved for me yesterday.
Within a recorded macro I'm trying to use a filter on another sheet.
The criteria to be used on the filter is determined by what a user enters in another cell.
I've tried to use the macro to copy this cell and paste its contents into the filter but that doesn't work.
Can anyone tell me how to resolve this issue?
The user does not have access to the sheet that the filter exists in for privacy reasons.
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi,
I've attached a cut down version of the file.
Password to unprotect sheet is "Brutus"
Password to unprotect workbook is "BrutusSH".
The first macro is to confirm password. it should copy the users name to row 20.
The second should pick up the name of the user and apply it to filter in "Team" then copying the ID column in Team to the tab "Costing".
This is where I'm getting caught. The macro has the name in quotation marks and is not updated by copying the cell in row 20. I'm not sure how to get this filter updated by the user.
Hi,
Can anyone help with this?
Try this. I,ve combined both codes into 1. So password check is done and when OK rest of code executes else msgbox to retry.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thanks bakerman,
That works perfectly.
Had hoped to understand how you could do it but I'll have to go and study VB to understand it - needed to do it anyway.
Again, works beautifully - thanks again.
You're welcome and thanks for adding rep points.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks