Program Button to Find, Copy, Paste to New Sheet based on Value in column

samss919

New Member
Joined
Mar 3, 2024
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
Hi, I'm new to VBA & couldn't find an answer that matched closely enough for me to adapt for my purposes.

I have a sheet which will have further rows added to it so need the query to also be variable to the last row with data.

Sheet1 has a series of selection options which fills data in Sheet3; once all selections have been made I would like to add a button to Sheet1 (Produce Kit List) that searches for all values greater than 0 in Sheet3 ColG, selects those rows, copies those rows (ignoring unwanted columns), and pastes them to Sheet4 which has the headers in Row1

Sheet3 ColA remains Sheet4 ColA
Sheet3 ColD becomes Sheet4 ColB
Sheet3 ColE becomes Sheet4 ColC
Sheet3 ColG becomes Sheet4 ColG

Sheet3 ColB,C,F,H are un-needed

Help would be gratefully received
 

Attachments

  • Excel Snapshot1.png
    Excel Snapshot1.png
    3.8 KB · Views: 22

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

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