Click on a Cell to Filter Another Worksheet

[tmarie]

I have a workbook with two worksheets. Worksheet 1 has a list of Devices, Worksheet 2 has a list of all the Devices and related features. Worksheet 2 is a Table. I want the user to click on a device from the list on Worksheet 1 that will go to Worksheet 2 and show only the rows for that device (filter the worksheet automatically). I am a novice at VB code. Can someone help me please?

Thanks!
Tina

Office 365 Version

[Mumps1]

It would be easier to help and test a possible solution if you could attach a copy of your file.

[tmarie]

I think I attached it. Let me know if it didn't attach. Thanks!

[Mumps1]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your NNVRemotes sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet.

Please Login or Register  to view this content.

Instead of clicking on a device from the list on Worksheet 1, you have to double click the device. I did it this way in case someone accidentally single clicks on a device. If you don't want to double click and use just a click, then replace the very first line of code with this one:

Please Login or Register  to view this content.

[tmarie]

Double click is good! Thank you! One last request, how do I have it go to the NNV worksheet to show the filtered list after the double click?

[Mumps1]

Try:

Please Login or Register  to view this content.

[tmarie]

You are a genius and saved my day!! Thank you sooo much

[Mumps1]

Thank you so much for the kind words and you are very welcome.

[tmarie]

Hi Mumps1!
Need your expertise again if its not a bother. I created a macro and assigned it to the button on the NNV worksheet. What I am attempting is for the user to click the button when information entered for this Remote is completed and it will take you back to the NNV Remotes worksheet and the cell to the right (B1, etc) so they enter more information. I used the copy and find but it recorded it as a static value. I tried the selection.paste and it did not work. Can you help again? I attached the file so you can see what I have done so far.
Thanks!
Tina

[Mumps1]

I'm sorry but I don't quite follow what you want to do. Please describe in more detail, step by step, referring to specific cells, rows, columns and worksheets using a few examples.

[tmarie]

When the user double clicks a RemoteID on the NNV Remotes worksheet it takes them to the NNV worksheet and filters the list for the Remote ID. (This part was already coded thanks to you! Its the next part I need help with.) Then the user will enter information in the cells for the filtered list. After the user is complete, user will click the button which will take the user back to the NNV Remotes worksheet to enter a completion date in column B for the RemoteID that was filtered.

I need to make this as user-friendly and simple as possible for the individuals who will use this workbook. They will either forget to do a step in the process or don't know how to do something as simple as filtering a list.

Any help or suggestions you can offer is greatly appreciated.

Thank you!
Tina

[Mumps1]

Assign this macro to your button:

Please Login or Register  to view this content.

[tmarie]

Once again you are genius! I see how you worked this, I am definitely learning a lot from you.
Thanks so much for helping me, I'll try not to bug you again this weekend.
Have a wonderful weekend!
Tina

[Mumps1]

Thank you and you as well.

[tmarie]

DISREGARD - I FIGURED THIS OUT WITH YOUR CODE! Thanks tho!

Hi Mumps1! I looked at your code and was trying to figure out how to add the Remote ID from the NNV worksheet to the email in the subject line. You have some code I have never seen before. I copied some of the code, but it puts the row number instead of the Remote ID. I got everything else to work except for this. Can you help please?

[Mumps1]

Glad it worked out.

[tmarie]

Hi Mumps1-
I figured the code to add the remote ID to the subject line based on your code. But what I am trying to accomplish now is saving the file as the remote ID that shows filtered. Attached is the code I have so far. Possible to take a look and help me out on this?

[Mumps1]

Try:

Please Login or Register  to view this content.

[tmarie]

Ahh Yes! Thank you Mumps1 you are a PRO!!! I did change the path to attach the file to the email which worked out perfect! I have one last request if you have a moment, and this is above my head. When the user enters a name in columns C and D for a remote ID on the NNVRemotes tab then double clicks in the remote ID to be taken to the filtered list on the NNV P2P Verification Form, how can I have the values from both cells be entered into cells C3 and F3 on the NNV P2P Verification Form? The values can be cleared and overwritten each time, I only need the values for the pdf copy.

I wasn't sure if this could be included in the Sub Worksheet_BeforeDoubleClick module.

Tina

[Mumps1]

Use this macro to copy/paste the cells.

Please Login or Register  to view this content.

I had a closer look at the PDF macro to correct what I thought were some errors. This is the revised version:

Please Login or Register  to view this content.

Was it working properly for you before?

[tmarie]

Hi Mumps1! Thank you...once again GENIUS!! Yes it was working but I can see where you cleaned it up. Everything looks and works great! Thanks again for helping me out, I am sure the users will be happy to see how simple it is to use this workbook.

Have a wonderful weekend! Tina

[Mumps1]

My pleasure.