Hi all,

I hope what is asking is not complicated.

I have 25 files with approximately 1,150 rows.

The attachment here has approximately 195 rows, and it is only for testing purposes so you can see a portion of what is in these 25 files.


Basically, I would like to be able to copy the information from column A through Column O, from Sheet "025" to Sheet "Reforecast", starting in Row A3, but there are some conditions.

Let me explain what I need.

If you look at the following rows, you will see that there are information in there from column A thru column O.

Here are the rows with information:

row 12 thru 14
row 36 thru 38
row 49 thru 51
row 120 thru 121
row 144 thru 146
row 156 thru 157
row 168


Hopefully, with a macro, I would like to be able to copy the information from these various rows to the reforecast sheet.

What I see here is that all of these rows, have something in common, and that is that Column O is greater than 1.

Not sure if this will help when developing the macro.

Also, if we can exclude any information starting with the words NF-025-XXXXX, or if there are any rows with the following information (in Column B), this information can also be excluded from being copy.

For example:


Budget 2019
Actual 2018
Budget 2018
Actual 2017


Please let me know if you have any questions, or need additional information.

As always, thank you in advance for your assistance and cooperation.

Regards,
rsrasc

Attached Files

025 FY 2019 Expenses-SSE-1.xlsx (36.8 KB, 10 views)