Solved

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

Posted on 2014-01-23
8
233 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

761 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