Hi All...
Background:
I have a workbook with multiple sheets that require users input.
Every Sheet is full of formulas that total groups of cells or reference cells in other sheets.
The Cells where users input data are highlighted in yellow (Fill Color).
The remaining Cells in the sheets are white.
I need a Macro that can identify the cell color of the sheet, and if it is yellow, then copy and paste special values over the yellow cells.
Any Ideas?
What I've tried:
I created various "Recorded" Macros that go to the individual sheets, select the specific (Color Coded) ranges then copy and paste special values on the yellow blocks.
This works well, however it does not suit my needs because users will sometimes delete or add rows according to their requirements and because my "Range" is specific, I miss colored rows that should be copy and pasted, and I copy and paste formulas in No Color Fill Cells that shouldn't be changed
Any and all help will be greatly appreciated.
Kind regards,
Brenden
Background:
I have a workbook with multiple sheets that require users input.
Every Sheet is full of formulas that total groups of cells or reference cells in other sheets.
The Cells where users input data are highlighted in yellow (Fill Color).
The remaining Cells in the sheets are white.
I need a Macro that can identify the cell color of the sheet, and if it is yellow, then copy and paste special values over the yellow cells.
Any Ideas?
What I've tried:
I created various "Recorded" Macros that go to the individual sheets, select the specific (Color Coded) ranges then copy and paste special values on the yellow blocks.
This works well, however it does not suit my needs because users will sometimes delete or add rows according to their requirements and because my "Range" is specific, I miss colored rows that should be copy and pasted, and I copy and paste formulas in No Color Fill Cells that shouldn't be changed
Any and all help will be greatly appreciated.
Kind regards,
Brenden
