Hello,
I have a worksheet (Input) where users will add action items and assign dates and names and add info. I want a specific Range of info to be copied and pasted into another worksheet (Output) based on if a activeX checkbox is checked. I want the Vba to find the next empty row and if the button is un-selected, I want that range of data to be removed and the remaining copied data to shifted up to fill the empty range.
On my sheets (see screenshots), On sheet (Action Item Tracker) If a checkbox is checked (cell F4) I want the Range (E4:J4) to be copied over to my second sheet (Summary Report) into range (A19:L19).
I am using office 360
Thank you all in advanced.
I have a worksheet (Input) where users will add action items and assign dates and names and add info. I want a specific Range of info to be copied and pasted into another worksheet (Output) based on if a activeX checkbox is checked. I want the Vba to find the next empty row and if the button is un-selected, I want that range of data to be removed and the remaining copied data to shifted up to fill the empty range.
On my sheets (see screenshots), On sheet (Action Item Tracker) If a checkbox is checked (cell F4) I want the Range (E4:J4) to be copied over to my second sheet (Summary Report) into range (A19:L19).
I am using office 360
Thank you all in advanced.
