Which yellow are you using?? The yellow with color index 6 (the brighter yellow). Do you use color anywhere else in the sheet?
It may be easier, depending of your format, to copy any data that has a colored cell. That said, if you color your column headings or any other cells within the sheet that do not contain data you wish to copy this method won't work.
Yes It's the Bright Yellow, (6), but any one color would work for my purposes. Only cells with a value would need to be copied over to my 6th Wrksheet. There are no other colors in my Wksheets.
Any ideas if this is doable?