Help please to move row to a second archive sheet when a Marlett tick is selected in cell

**Danz1985** · 02-15-2016, 01:09 PM

Hello all,

Been looking for a solution for a week now and I have no knowledge on VBA at all. Hoping I can have some help here please?

I have a worksheet that has been created to try and make a job paperless. It stores information in cells D7 along to Q7 (likely to be extended to R) and down to row 99.

I'm trying to move the row when a Marlett tick is selected in Column O to the archive sheet. So that when the job is ticked as done it will auto move it. Cutting and copying the contents of the cells only so we don't lose borders and colours etc.
When moving to the archive sheet it would be great if it would go down to the next available or blank row. Also the deleted row in the front sheet to then have all the data below moved up to keep the sheet tidy and organised.

I'll include a copy of the blank sheet with some random data entered to assist in any testing. Edit: I am having trouble uploading, although the file size is 39mb.
To note there are some current VBA codes in there to enable Marlett ticks on selection, also another so that columns L and M can not have a Marlett tick in both columns on a corresponding row. Data Validation Lists are also present columns G and H.

Thanks for your help, would be greatly appreciated.

Any further questions and i'll try to get back and answered as soon as.

Thanks,

Dan

**DarkF1ame** · 02-15-2016, 01:22 PM

Danz1985,

It appears that you did not attach your sample file. Please do so and I will try to look at it for you.

Thanks,

DarkF1ame

**Danz1985** · 02-15-2016, 01:55 PM

Thanks DarkF1ame,

I'm having issues uploading on this connection. The file size is 39mb so I think I may be exceeding limit.

**Danz1985** · 02-16-2016, 01:18 PM

Originally Posted by DarkF1ame

Danz1985,

It appears that you did not attach your sample file. Please do so and I will try to look at it for you.

Thanks,

DarkF1ame

Managed to reduce the file size and attached now. Cheers

**CAntosh** · 02-16-2016, 05:00 PM

I believe that replacing your first Selection Change event sub with the one below will have the desired result. I noticed on the sample you attached that you'll also need to switch column 'O' of the archive sheet to Marlett font as well if you want the Marlett tick to transfer (it currently shows up as "a")

Please Login or Register  to view this content.

**Danz1985** · 02-16-2016, 07:21 PM

Originally Posted by cantosh

I believe that replacing your first Selection Change event sub with the one below will have the desired result. I noticed on the sample you attached that you'll also need to switch column 'O' of the archive sheet to Marlett font as well if you want the Marlett tick to transfer (it currently shows up as "a")

Please Login or Register  to view this content.

That is truly amazing. I can't thank you enough.

I'll put the sheet into place over the next week or so and give it a good run out.

Thanks again.

Help please to move row to a second archive sheet when a Marlett tick is selected in cell

LinkBack

Thread Tools

Rate This Thread

Display

Help please to move row to a second archive sheet when a Marlett tick is selected in cell

Re: Help please to move row to a second archive sheet when a Marlett tick is selected in c

Re: Help please to move row to a second archive sheet when a Marlett tick is selected in c

Re: Help please to move row to a second archive sheet when a Marlett tick is selected in c

Re: Help please to move row to a second archive sheet when a Marlett tick is selected in c

Re: Help please to move row to a second archive sheet when a Marlett tick is selected in c

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Move row from sheet to archive in a macro

Move a Row to archive sheet - Values Only

Trying to Move an entire Row from one sheet to another Archive sheet.. Also..

Trying to Move an entire Row from one sheet to another Archive sheet.. Also..

[SOLVED] tick all check box in just one click and then count up the selected tick box...

[SOLVED] Marlett Checkbox in one cell and tick in different cell

Place a tick in a cell when selected, untick it if selected again and....

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions