Macro Help – Transferring columns or cells to a new worksheet based on specific conditions

Hello, I hope someone can help.

I am trying to right a Macro/formula to enable me to transfer certain data from one worksheet to another. There are two ways I can think of doing this:

1) The cells that need to be moved will be a certain color, based on an existing conditional formatting rule. Perhaps a Macro could be created to move cells of certain colors from one sheet to another?

2) The cells that need to be moved will be “less than” the values of cells from a different column.

The column that I need to move the cells from is titled “To Order/Make”, is in column “G” and the cells in this column will only ever be numeric. The existing conditional formatting rule means that the cell changes color if the figure in column “F”, titled “Amount Remaining”, is less than the figure in column “E”, titled “Minimum Required”. Please see a screenshot below:

 

As you can see, some of these cells have changed color. Preferably, I want to be able to run a report/click a button that will transfer the entire row onto a new sheet/into a table on a new sheet.

I have really struggled to get this to work so any advice is appreciated.

Thanks

By: Craig

4 thoughts on “Macro Help – Transferring columns or cells to a new worksheet based on specific conditions

  1. ig

    I’m not that much of a online reader to be honest but your sites really nice, keep it up!
    I’ll go ahead and bookmark your website to come back later.
    All the best

  2. Henrietta

    This is very fascinating, You’re a very skilled blogger.
    I’ve joined your rss feed and look ahead to in quest of more of your magnificent post.
    Also, I’ve shared your web site in my social networks

Comments are closed.