By double click can you filter multiple sheets at the same time

J

jobnadar

New Member
Joined
Feb 10, 2022
Messages
1
Office Version
  1. 2016
Hi Guys

I would need your help. I have one file excel with ten sheets. One list of vehicle accidents in a year and then overall details accidents, next type of accident like engine failer etc.

I would like to write a macro that with a double click on an Vehicle no in the sheet and it goes in the other sheet "vehicle no" for filtering the data all sheets

Can you help me?

thanking you

Jobnadar
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You must log in or register to reply here.

Similar threads

F
  • Solved
Double click to copy a cell to the next empty cell in a different column and sheet (VBA code)
Replies
3
Views
278
kevin9999
K
A
  • Question
Xlookup, Vlookup and/or VBA for finding, matching and inputting data to separate sheet
Replies
0
Views
524
AlfredDB
A
A
  • Solved
Double-click event macro auto filter multiple columns on different worksheet
Replies
6
Views
682
ac7
A
A
  • Solved
Bringing data together from different sheets as it is added
Replies
5
Views
488
Andrew1234
A
F
  • Solved
Double click and jump to another sheet with the same data
2
Replies
11
Views
576
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,215,006
Messages
6,122,666
Members
449,091
Latest member
peppernaut

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top