Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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