#1
|
|||
|
|||
Need Help Creating a Macro To Copy and Paste Info
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA Newbie (Trying to write a code to copy and paste info from one sheet to another) | Forum2000s | Excel Programming | 2 | 05-07-2017 04:51 AM |
Copy/Paste/LastRow Help with Macro | rsrasc | Excel Programming | 1 | 09-24-2016 01:25 AM |
Open csv files & copy and paste info into master file | gbaker | Outlook | 9 | 04-22-2016 11:02 PM |
Macro to copy cell info to multiple documents | Patrick Innes | Word VBA | 2 | 02-18-2015 08:38 PM |
VBA macro to copy range and paste in next blank row | tune2grow | Excel Programming | 0 | 09-03-2014 08:25 PM |