How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask ATLPROG Your Own Question
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

I have an excel question. I have 300 excel files all mapped

Customer Question

I have an excel question. I have 300 excel files all mapped to a master sheet. I need the 300 excel files to auto update without me having to open them, how do I do this?
JA: What programs and versions are you using?
Customer: Right now 2013 but upgrading to 2016 32bit next week. Windows 7
JA: What is your ideal outcome? How can we solve this for you?
Customer: I need a VBA code or a script to have all files update once the master file is updated.
JA: Anything else you want the programmer to know before I connect you?
Customer: No thanks
Submitted: 4 months ago.
Category: Programming
Expert:  The-PC-Guy replied 4 months ago.

Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question and will be back in a moment with my reply.

Expert:  The-PC-Guy replied 4 months ago.

how are these files currently being update?

Customer: replied 4 months ago.
I have to open and hit save, very timely
Expert:  The-PC-Guy replied 4 months ago.

i mean do you want to copy something from these files to the master sheet, or does something from the master sheet get copied to the file?