I'm just getting started on a small project. I have a workbook that I need to write some code to do the following: When ran, it will go through several worksheets and if cell is red in column D, it will then insert that value in a list on a seperate worksheet.
Has anyone done something close to this? I'm having some trouble understanding how to loop it for each worksheet, and how to transfer the value over to another worksheet if there is a match. I'm still gathering code, so i do not have much useful to post just yet. Thanks for any help in getting me started.