VBA Macro - Exporting Data to New Worksheets

[dbell001]

I have a list that I would like to automatically go through and export a row of data that does not equal zero.

For instance, Row 35 and Row 36 is zero, Row 37 begins to change value, Rows 38 -40 values keeps changing, Row 40 and 41 value equals to zero.

Rows 36 to 40 would then be exported to a new worksheet.

The macro would then continue to search through the remaining list to find similar instances and export, until end of list.

Any help would be appreciated.

[BanginMyHeadOnMyDesk]

Hi and welcome.

Would they all copy to the same sheet or would each yellow section get copied to its own sheet?

Beth.

[dbell001]

Hey Beth,

Each yellow section would gets its own sheet. Thank you.


David

[BanginMyHeadOnMyDesk]

Maybe something like this?

Please Login or Register  to view this content.

Beth.

[dbell001]

Good Morning Beth,
Thank you for the code..

I think I might have mislead you.

Only looking at column "B":

if I look at R81 and R82, this equals 0.

If I look at R82 and R83, the value is no longer 0, which means an event is occurring.

R83 and R84, event still occurring.

R84 and R85, equals 0, meaning event has basically stopped.

At this point, I want to export R82 to R84, where the event started and stopped.

81- 11-Sep-19 10:18:00 0.034659
82 - 11-Sep-19 10:19:00 0.034659
83 - 11-Sep-19 10:20:00 0.046188
84 - 11-Sep-19 10:21:00 0.059857
85 - 11-Sep-19 10:22:00 0.059857

I really appreciate your help.

David

[BanginMyHeadOnMyDesk]

Could you manually put together your expected outcome and attach that?

I'm confused because as far as I can tell my code is doing what you asked for except copying all columns and basing the 'event start/end' on column D.

Beth.

[dbell001]

I've attached the spreadsheet that I hope can help explain.

The green cells are the cells that will be used to determine if an event took place or not, column "B". In column "F" and highlighted in blue are formulas that I included for your use to see if an event occurred or not. you can use the same formula in your code for column "B".

From the time that an event took place to where there is no event, these rows and headers will be moved to another worksheet. The tab for that worksheet has the start time and date of that particular event start time and date. I've made three worksheets as examples.

You should start from the top and work your way to the bottom of the list.

Let me know if this helps any... thank you a whole bunch!!