Hello Everyone,
Please help me find out the solution for this problem.
I have two same excel files having same columns headers.
The master file is also having same columns headers.
File 1 & 2 are updated by two different persons by person 1 & person 2 respectively.
I want the compiler file to be auto updated by the entries of the person 1 & person 2.
I have attached the example files.
Thanks in advance.
Compiler.xlsx
Person 1.xlsx
Person 2.xlsx
Regards,
NeoNirav
Hi NeoNirav
Try this and changed the red color line as per your location and paste the person files in that folder and next open the master file and run it(press alt+f8 and click on run).
Note: Make sure in that line last "\" should be there
Please Login or Register to view this content.
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
A great many thanks... Naveed!!!
Glad here this...... you can post as many question definetly some one will help u out
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks