Solved

Part 5 - Copy only hardcoded values to the correct row and column of a another spreadsheet

Posted on 2014-01-23
8
199 Views
Last Modified: 2014-01-29
Please change the code to not automatically open up the Last Month’s and This Month’s file when your macro tool opens.  Only open up the files once the user attaches a new location for Last Month and This Month file.  The reason I’m asking for this is because for each new month both files are going to change locations and I don’t want the user to accidentally update the wrong file.
0
Comment
Question by:ScottBarnes
  • 4
  • 3
8 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 39805774
@aikimark
You are totally correct and presume asker inadvertently did not put a lik to previous question although I expressly asked for. I have been working on all these parts ever since the beginning and we are waiting for part4 to complete to tackle this one.

@ScottBarnes
Pls make sure to put a link to previous question or attach required file as questions need to be available to all Experts equally.

gowflow
0
 

Author Comment

by:ScottBarnes
ID: 39806902
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39807285
please check out if this is what you want.
gowflow
UpdatePrevMonthForcastV10.xlsm
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 39815002
Did you had a chance to try out the proposed solution ?
gowflow
0
 

Author Closing Comment

by:ScottBarnes
ID: 39815216
Yes I did and everything works perfectly, I want to personally thank you for all diligence and hard work.  A week ago I would have never have dreamed I would have such an awesome solution.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39815437
Your welcome I am glad I could help. Pls feel free to post a link to any question you may need help with.
gowflow
0
 

Author Comment

by:ScottBarnes
ID: 39817823
Would you be able to help with a new question?

http://www.experts-exchange.com/Microsoft/Applications/Q_28351099.html
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now