Need help writing macro to extract text from one column of entire workbook if another column meets certain criteria

[Jackiet2007]

Need help writing a Macro to search entire workbook for the date in column C and if it meets a certain criteria, I need to extract the text in column A for that row into a new worksheet. Also I need to know if I can modify the criteria date (as that will change from week to week). If I can do this without a macro please let me know. I have wrecked my brain trying to come up with a formula to automatically extract the


[TABLE="width: 752"]
<colgroup><col style="width: 219pt; mso-width-source: userset; mso-width-alt: 10678;" width="292"> <col style="width: 215pt; mso-width-source: userset; mso-width-alt: 10459;" width="286"> <col style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;" width="72"> <col style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;" width="91"> <col style="width: 196pt; mso-width-source: userset; mso-width-alt: 9545;" width="261"> <tbody>[TR]
[TD="class: xl67, width: 292, bgcolor: #8E0017"]Action Item/Description[/TD]
[TD="class: xl65, width: 286, bgcolor: #8E0017"]Notes[/TD]
[TD="class: xl66, width: 72, bgcolor: #8E0017"]Target Date[/TD]
[TD="class: xl66, width: 91, bgcolor: #8E0017"]Actual Date[/TD]
[TD="class: xl68, width: 261, bgcolor: #8E0017"]Current Status / Next Steps[/TD]
[/TR]
[TR]
[TD="class: xl79, width: 292, bgcolor: transparent"]Color Legend[/TD]
[TD="class: xl80, width: 286, bgcolor: yellow"]Yellow Highlight = Shift in Dates / Delay[/TD]
[TD="class: xl81, width: 72, bgcolor: red"]Critical Delay[/TD]
[TD="class: xl82, width: 91, bgcolor: #00B050"]On Track[/TD]
[TD="class: xl79, width: 261, bgcolor: transparent"]Purple Text -Status Update[/TD]
[/TR]
[TR]
[TD="class: xl91, width: 741, bgcolor: #E9D5AB, colspan: 4"]Site Tasks and Action Items[/TD]
[TD="class: xl69, width: 261, bgcolor: #E9D5AB"] [/TD]
[/TR]
[TR]
[TD="class: xl84, width: 292, bgcolor: transparent"]Site docs approved and printed[/TD]
[TD="class: xl84, width: 286, bgcolor: transparent"] [/TD]
[TD="class: xl76, width: 72, bgcolor: #00B050"]TBD[/TD]
[TD="class: xl75, width: 91, bgcolor: transparent"] [/TD]
[TD="class: xl84, width: 261, bgcolor: transparent"]waiting on Justina[/TD]
[/TR]
[TR]
[TD="class: xl86, width: 292, bgcolor: transparent"]Site Growth[/TD]
[TD="class: xl89, width: 286, bgcolor: transparent"]Becky looking into details of print shop and getting information so Britt and Sue can pursue[/TD]
[TD="class: xl73, width: 72, bgcolor: #00B050"]11/1[/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl89, width: 261, bgcolor: transparent"]10/4 - Becky is gathering info - one of the workers quit recently and print shop operations are a mess[/TD]
[/TR]
[TR]
[TD="class: xl91, width: 741, bgcolor: #E9D5AB, colspan: 4"]Client Projects[/TD]
[TD="class: xl69, width: 261, bgcolor: #E9D5AB"] [/TD]
[/TR]
[TR]
[TD="class: xl86, width: 292, bgcolor: transparent"] [/TD]
[TD="class: xl89, width: 286, bgcolor: transparent"] [/TD]
[TD="class: xl87, width: 72, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl89, width: 261, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl91, width: 741, bgcolor: #E9D5AB, colspan: 4"]OMG Training / Certifications[/TD]
[TD="class: xl69, width: 261, bgcolor: #E9D5AB"] [/TD]
[/TR]
[TR]
[TD="class: xl86, width: 292, bgcolor: transparent"]Take Excel training[/TD]
[TD="class: xl89, width: 286, bgcolor: transparent"]get excel tutorial and training material and get more familiar with using excel[/TD]
[TD="class: xl73, width: 72, bgcolor: #00B050"]12/31[/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl89, width: 261, bgcolor: transparent"]waiting for training materials from Britt[/TD]
[/TR]
[TR]
[TD="class: xl70, width: 292, bgcolor: transparent"]Read "Who Moved My Cheese"[/TD]
[TD="class: xl70, width: 286, bgcolor: transparent"]read book and submit report to Britt[/TD]
[TD="class: xl90, width: 72, bgcolor: #00B050"]11/1[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl89, width: 261, bgcolor: transparent"]10/4 - Becky already read Who Moved my cheese - Britt provided Becky with another book[/TD]
[/TR]
[TR]
[TD="class: xl86, width: 292, bgcolor: transparent"]BP: Utilize Prove It Tutorials[/TD]
[TD="class: xl89, width: 286, bgcolor: transparent"] [/TD]
[TD="class: xl73, width: 72, bgcolor: #00B050"]on going[/TD]
[TD="class: xl74, bgcolor: white"] [/TD]
[TD="class: xl89, width: 261, bgcolor: transparent"]in progress[/TD]
[/TR]
[TR]
[TD="class: xl86, width: 292, bgcolor: transparent"]Read "A Sense of Urgency"[/TD]
[TD="class: xl89, width: 286, bgcolor: transparent"]read book and submit report to Britt[/TD]
[TD="class: xl73, width: 72, bgcolor: #00B050"]12/1[/TD]
[TD="class: xl74, bgcolor: white"] [/TD]
[TD="class: xl89, width: 261, bgcolor: transparent"]10/11 - Britt provided book to Becky last week.[/TD]
[/TR]
[TR]
[TD="class: xl86, width: 292, bgcolor: transparent"] [/TD]
[TD="class: xl89, width: 286, bgcolor: transparent"] [/TD]
[TD="class: xl87, width: 72, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl89, width: 261, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl86, width: 292, bgcolor: transparent"] [/TD]
[TD="class: xl89, width: 286, bgcolor: transparent"] [/TD]
[TD="class: xl87, width: 72, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl89, width: 261, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[JLGWhiz]

If the data base is in sheets(1) and you want to extract to sheets(2) then the formula would need to go into sheets(2). So, in Column A of sheets 2 you would have:

Formulasheet2!A2)
=IF(Sheet1!C2=A1, Sheet1!A2, "")
Formula:

Then drag it down.