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