Excel - Copy row to different sheet if row contains "x"

Question

Hi everyone,

I am attempting to get an entire row to copy onto a new sheet if one of the cells in said row contains a specific value.

Specifically: I want to copy an entire row of log data, depending on the truck used in column C, to an existing sheet for each truck.

Any thoughts? I've hunted for IF/THEN scenarios and SUMIF, etc... no luck yet.

Thanks!

Answer 1

Interjecting a few additional thoughts;

Perhaps I'm underestimating your requirement based on limited information, but for no more than what you described a very simple approach would be to just filter the list in place, then copy the found record(s) & paste to the other sheet.

If you need something more dynamic, you might investigate the use of;

• Pivot Tables, &
• Advanced Filter

in addition to the suggestions being offered by others.

Another approach would be to store the data for each 'truck' on a separate sheet of its own. It could be aggregated at any time for all, or any combination of, trucks.

Answer 2

I agree with Bob jones. I think it will be alot easier to do what you want manually via filtering the list and/or creating a pivot table to give you what you want. Unless you can do the VBA yourself, it will be much faster and less expensive to use a pivot table than to have a VBA program developed for you. And, as you noted, doing it once is probably not the final solution, you will need another VBA routine to do it by driver. A pivot table (or 2) will get you exactly what you want.

Answer 3

Hi Aaron,

Do you have any updates?

Regards,

Yoga