Macro to move data from one worksheet to another based off of criteria;

Hello. I am working in a workbook. I have two main worksheets. I have been looking for a code that would remove row information from one worksheet and copy it into another based off of criteria. I am new to VBA, and need a little assistance.


Example below - If YES is selected in the Deletion column, remove all row information from (#Sheet1) and paste all row information into (#Sheet2). (That would allow formatting to table.)
Excel.JPG


Also, is there a way to move column K to column J after Dec 31 of every year with criteria of column a not being of same year? For example for everything that is 2014 or less, move column k to column j every year after December 31?

I hope this is clear as mud and appreciate any help that can be given to me, a newbie to VBA and coding. Thanks!

This answers your first question. You will need to paste the code in the Visual Basic Editor in the Sheet1 module.

Please Login or Register  to view this content.

Your second question

Also, is there a way to move column K to column J after Dec 31 of every year with criteria of column a not being of same year? For example for everything that is 2014 or less, move column k to column j every year after December 31?

Is very confusing to me so I am not able to answer it.

hi
ive usually found that error is it can not find the sheet its supposed to ,try changing back to sheet2
colin

There isn't a Worksheet named "Sheet2" nor "Sheet5" in your workbook. There is a Worksheet named "Deleted Assets".

Note: I edited the code to work better on your supplied workbook

Please Login or Register  to view this content.