Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-30-2018, 09:08 AM
rsrasc rsrasc is offline Need Help Creating a Macro To Copy and Paste Info Windows 10 Need Help Creating a Macro To Copy and Paste Info Office 2013
Competent Performer
Need Help Creating a Macro To Copy and Paste Info
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default 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
Attached Files
File Type: xlsx 025 FY 2019 Expenses-SSE-1.xlsx (36.8 KB, 10 views)
Reply With Quote
Reply

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
Need Help Creating a Macro To Copy and Paste Info Copy/Paste/LastRow Help with Macro rsrasc Excel Programming 1 09-24-2016 01:25 AM
Need Help Creating a Macro To Copy and Paste Info 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft