Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2018, 01:56 PM
kevinbradley57 kevinbradley57 is offline Copy data from 2 external files into separate worksheets of a third file Windows 7 64bit Copy data from 2 external files into separate worksheets of a third file Office 2010 64bit
Advanced Beginner
Copy data from 2 external files into separate worksheets of a third file
 
Join Date: Jul 2017
Posts: 84
kevinbradley57 is on a distinguished road
Default Copy data from 2 external files into separate worksheets of a third file

I have three Excel files: SearchResultsInProgress m.d.yy, SearchResultsCompleted m.d.yy, and Weekly Plan Status m.d.yy. The Weekly Plan Status has 2 worksheets/tabs, "In Progress" and "Completed".

I need to do the following:
1) clear all data from the Weekly Plan Status file but not the formula used in column H
2) copy all data except the header row from SearchResultsInProgress m.d.yy to the corresponding cells of the In Progress worksheet
3) convert the data in columns K-N to Number format in order to remove the parentheses and insert a negative sign prefix (it defaults to "number stored as text")
4) copy the data from columns A-G (not header row) of SearchResultsCompleted m.d.yy to columns A-G of the Completed worksheet


5) copy the data from columns H-K (not header row) of SearchResultsCompleted m.d.yy to columns I-L of the Completed worksheet
6) convert the data in columns I-L to Number format in order to remove the parentheses and insert a negative sign prefix
7) copy the formula from H2 to all used cells in column H (the formula is =F2-F2)
8) open a new Outlook email and attach the Weekly Plan Status m.d.yy file

All of the above must maintain the cell formatting in the target file except for the conversion to Number format of steps 3 and 6.

Thank you!

Last edited by kevinbradley57; 05-15-2018 at 02:11 PM. Reason: typos
Reply With Quote
  #2  
Old 05-24-2018, 05:04 PM
BobBridges's Avatar
BobBridges BobBridges is offline Copy data from 2 external files into separate worksheets of a third file Windows 7 64bit Copy data from 2 external files into separate worksheets of a third file Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Hi, Kevin. So you need to do all that...but somehow you left out the actual question. How far have you gotten in writing that program? Which part of the logic isn't working for you? What error messages are you getting when you run the program? Is there a part of the algorithm that's puzzling you?


What, exactly, do you need?
Reply With Quote
  #3  
Old 05-25-2018, 01:12 PM
kevinbradley57 kevinbradley57 is offline Copy data from 2 external files into separate worksheets of a third file Windows 7 64bit Copy data from 2 external files into separate worksheets of a third file Office 2010 64bit
Advanced Beginner
Copy data from 2 external files into separate worksheets of a third file
 
Join Date: Jul 2017
Posts: 84
kevinbradley57 is on a distinguished road
Default

Bob -- Thanks for your note. I need help getting started and would rather not end up with inefficient code that often results from doing patch work. For example, I've seen threads that suggest code with "select" or "copy" only to then see a response to avoid both of those things. That's why I put it all out there up front. If you can point me to an example or two that does at least 2-3 of the things I need done, that would be helpful.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy data from 2 external files into separate worksheets of a third file Merge separate words files into one master file. ronka1997 Word 3 08-09-2016 01:26 AM
Copy data from 2 external files into separate worksheets of a third file Copy data btw worksheets using public arrays OldColdDreamer Excel Programming 4 02-10-2016 09:56 AM
Copy data from 2 external files into separate worksheets of a third file Mail merge result in separate world files instead of one file containing all the data xdhbsh Mail Merge 3 12-24-2015 12:23 AM
Copy data from 2 external files into separate worksheets of a third file Checking data in separate files ksigcajun Excel Programming 7 05-22-2014 08:54 AM
Copy data from 2 external files into separate worksheets of a third file Displaying multiple columns of shared data in separate mpp files ggg Project 1 01-08-2013 08:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:23 AM.


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