Help moving data from one Excel sheet to another is a certain criteria is met

[campingpro]

Hi

I am a basic excel VBA user, and I am needing a bit of help.


I can do basic VBA but this has had me puzzled for about a week.

I am needing a bit of code to help me move data form "Data" to "Report" if a in column o = "True". I need the whole row of data moving.

My report is around 1000 lines long each day so doing it manually is not an option, as I need to automate the whole report so its emailed out.

I can do the emailing of the VBA, its just copying the row if the criteria is met in column o.

Any help would be appreciated.

Ive search the internet and while there is similar topics I cant find one that has the answer / help that I need.

Thanks in advance

Andy

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.