Copying row of data to new sheet if specific value exists in column

**raz333** · 05-10-2013, 03:35 PM

HELP PLEASE!!!

On the attached workbook, I'd like to make other sheets read from the full list in the original sheet like so:
Sheet2 would look in Column C of Sheet1 for "Not Sent", any rows that are labeled that way would be copied to Sheet2.

I don't know if I'm asking it to do too much or if my brain just isn't working for me today!!!

Any suggestions would be greatly appreciated. Thanks!

Proposal Log.xlsx

**rcm** · 05-10-2013, 04:19 PM

run this macro..

Please Login or Register  to view this content.

**popipipo** · 05-10-2013, 04:26 PM

You can also use the filterfunction in sheet1
The result is the same

**raz333** · 05-10-2013, 04:31 PM

rcm...THANK YOU, that is perfect! :-)

popipipo...That is typically a much larger file with filtered information. I am aware that I could continuously filter to what I needed but that wasn't the result I was asking for, I needed it on separate sheets.

**rcm** · 05-10-2013, 05:46 PM

glad to be of help

**raz333** · 05-17-2013, 04:33 PM

Hello again,
After a busy week I was finally able to look at the project that I needed this for. I have found that the macro only fills the data in once. I need it to update the sheets based on changed information from sheet one. Basically, the Project Status is constantly changing and I want the subsequent sheets to reflect that. Is that possible??

Thank you!