• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA to automatically update a table in one workbook based on different workbook

Dokat

Member
Good Afternoon Everyone,

I have two workbooks where i want Excel to automatically update the table in one sheet based on the other one.
i want the table in workbook MergetestSheet!2015 to automatically update based on the table in workbook 2015Sheet!1 Range A1:p144,031. Can someone help with the VBA code?

Thanks


POST MOVED BY MODERATOR.


.
 
Last edited by a moderator:
1) This is Excel-forum ...
2) After A1 ... hmm ... is it ":" ?
Screen Shot 2016-11-08 at 21.15.39.png
3) You could use formula (link) form file to file.
 
I coulkd but there are two many rows and columns calculations will take long and slow down excel. Thanks
 
Hi @Dokat

Can you please provide a file?
What kind of update are we talking... msquery update, pivot table update, etc?

Regards
 
Back
Top