Trying to have excel scan worksheets to find green cells and move into last sheet

[wanted_file]

Hello,

I am trying to get excel to scan my first 5 worksheets in search for green "good" cells in the A column and move them into a row in the last (6th) sheet. I also want it to creat an empty cell if a worksheet doesn't have a green cell in it. I'm definitely struggling with this. Can anyone help?

Chris

[NickyC]

Hi

This macro searches the first five worksheets in the active workbook and copies the values of those with a green interior into column A of the sixth sheet. It adds a line if a sheet contains no green cells.

In order for this macro to work it needs to know what shade of green to look for (there are thousands!). I created a cell in sheet6 named "green" and set the interior colour to the shade of green the macro is looking for on the other sheets. let me know if this is a problem and we'll find another way to do it.

Please Login or Register  to view this content.