collect data out listing xls to own workbook

Hello
we log all customer communication on a daily spreadsheets a report. Multiple projects are listed on that one sheet every day.
Is there a way to extract project related communication to a individual project log adding the date from the daily report to the log.

The goal is to generate for each project a log will have the daily (or any) communication for one project from the daily report. either adding a work sheet via project name or a separate file.

Also is there is a new project a new project log should be created.

Please see attached sample... hopefully the upload was successful.

Thank you for any ideas you can give me relating data extraction/collecting from xks listing into a own project workbook or new xls.

Hi

Using the example file, see how this goes.

Please Login or Register  to view this content.

rylo

Thank you so much for taking the time to help me. I must be missing something

I added this as a macro and it does not like the 3rd line Set Data SH ?!?

I also opened the spreadsheet main xls coding and added it once to top/end/middle section. I am using stone age version Excel 2000.
As you might notice, my BVA experience is very close to zero. Other than basic task recoding.

Thanks, B

Thank you!
I have been out on vacation. Sorry for the late reply. I do appreciate your patience and assistance.

Can you please close the thread for me. The edit function is disabled for me.

I will create a new post. Bea