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
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