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.