Copy a row to another sheet if a value is x [Closed]

Report
-
Hello,
I'm searched around and can't really find anything that answers my question or I can understand.

I'm quite able with excel but not great with macros.

Basically I have a spreadsheet where I have around 10 sheets, 1 sheet for each type of machinery, and on each sheet is the machinery we have for that type, along with its serial numbers and service dates.

I also want a sheet for each truck we own and when I select a compressor as being on Truck 1, the whole row will copy over to the sheet for Truck 1, so we can easily see all the compressors on one page, but also all of the different machinery that is on truck 1.

Example,
Sheet 1 is a list of all of the compressors
Sheet 2 is a list of all of the gauges
Sheet 3 is a list of all of the drills
sheet 4 is the machinery on truck 1
Sheet 5 is the machinery on truck 2

I want it so that if on sheet 1, column C says Van 1, it will copy that row to sheet 4.
If sheet 1 column c says Van 2, it will copy that row to sheet 5.




Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!