Checkbox - True - Moves Whole Row To Another Sheet

[JJFabEngineering]

Hi Guys,

New the threads, so thought I'd give it a go.

I'm stuck, I'm creating a workbook that we use for our tender submissions.
What I now want to do is when a check box is ticked i want to move that row to another page (not the whole row - i.e. only move a5,b5,c5 across to another worksheet). Once moved it will appear on the new sheet and when i tick the next job won (which may be 5 rows down_ that will populate directly under the first lot of information (so there are no gaps).

I am happy to email this workbook to someone to have a look at.
I would prefer it not to be a macro book but open to ideas if required.

See attached images


Example.
Sheet - QUOTE SENT

Titles
A4 = Job Address
B4 = Builder / Client
C4 = Type (Drop Down List)

Data
A5 - A1000 = Job Addresses
B5 - B1000 = Builder or Client name
C5 - C1000 = Type (Fab, Fab & Install, Install Only)

I need the above to move over to the JOBS WON Sheet and fall into order (if possible) of which was ticked first etc......

Is this doable ?

Thanks

 

[JJFabEngineering]

Hi Mike,

Im sending the file through now. It would transfer the information from Quote sent to Jobs Won - and now when unchecked it throws the error as above.

Can you please help 20.05.2024_MrExB (Checkbox - True - Moves Whole Row To Another Sheet).xlsm

 

[JJFabEngineering]

Hi Mike,

My workbook seems to be broken. It wont check and show the data where required. Please see link below Tender Bible Latest.xlsm

 

[MikeVol]

Hi @JJFabEngineering. It doesn’t work because you hide the rows on the “Jobs Won” sheet, look at the first screenshot. Show these lines (unhide them) and you won’t have any errors, look at the second and third screenshots.