Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

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

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
ScottBarnes
Asked:
ScottBarnes
  • 4
  • 3
1 Solution
 
gowflowCommented:
@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
 
gowflowCommented:
please check out if this is what you want.
gowflow
UpdatePrevMonthForcastV10.xlsm
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
gowflowCommented:
Did you had a chance to try out the proposed solution ?
gowflow
0
 
ScottBarnesAuthor Commented:
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
 
gowflowCommented:
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
 
ScottBarnesAuthor Commented:
Would you be able to help with a new question?

http://www.experts-exchange.com/Microsoft/Applications/Q_28351099.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now