Paste Mutiple Items if Value = "FAIL"

robbieb29

New Member
Joined
Feb 9, 2025
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
Hi All

I'm new to VBA and I'd like to run a VBA that copies Various Cells from one Sheet to another and Doesn't overwrite the data. I have a row with various cells on which i'd like to copy if the end Cell = "Fail" into another sheet called Faults. The user would have to enter the type of fault and that would also go into the Fault sheet. So you would have Asset No, Equipment, Location, Fault which user would enter, Fault Code.

This Data would come from a different sheet with all this information in.

Kind regards
 

Attachments

  • Screenshot 2025-02-10 192618.png
    Screenshot 2025-02-10 192618.png
    210.3 KB · Views: 15
  • Screenshot 2025-02-10 192802.png
    Screenshot 2025-02-10 192802.png
    5.8 KB · Views: 15

Forum statistics

Threads
1,226,796
Messages
6,193,048
Members
453,772
Latest member
aastupin

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