Good day all,
Is there a way to add to (not replace) entries on the main workbook from other workbooks using VBA?
I have attached the main workbook for daily amount entries. These entries will be made on our phones (version #1,#2, and #3) and preferrably when we get within our home wifi range the main workbook will update the new information. It seems very complicated to do but if possible I would appreciate any advice or suggestions on how this can be done.
Thank you,
Joe
Last edited by LewisJ; 03-21-2017 at 11:25 AM.
Hi Lewis,
Try this. I have set it up so you select the file that you want to update from and it will update onto the main sheet and then clear the data, save and close.
Please Login or Register to view this content.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
Stephen,
That works very well thank you so much. This may be too much to ask but could the macro be altered so 3 files be selected, updated, and cleared?
We will have different versions:
Expense Entry #1.xlsm
Expense Entry #2.xlsm
Expense Entry #3.xlsm
Each will be on our phones to enter data each day. Is there a way that when we get in our home wifi the files from the phones be updated to the PC #1,#2, and #3?
Then from the main file click to activate the macro to update the information?
Thank you very much for your help,
Joe
Stephen,
I made some changes to my main workbook today with the great help from John Topley. I have a sheet 'Entries' with your macro on it.
I attached the file so perhaps you can see how it works. I still wonder if it's possible to update all 3 entry books from there.
Thanks again,
Joe
I'm not sure about accessing the files over wifi?!? Depends on your setup I guess.
You can setup the macro (below) so that you dump them in a folder and the macro will pick up all three files.
It may be easier, however, to leave it as is and connect each phone to your pc, select the macro and navigate to where each spreadsheet is stored on the phone. That way each person can do theirs whenever they want/need.
Please Login or Register to view this content.
Hello Stephen,
I realized you and I are on much different time zones. How is it 'down under'? I really appreciate the help and wonder how you know code so well? I will try the new code and change the path part to my desktop to test it.
Be back soon,
Joe
Stephen,
The code worked like a champ! Truly amazing! Hopefully others can benefit from this budget system.
Thank you very much for your help,
Joe
Hi Joe,
Glad I could help.
'Down under' is the place to be, especially in the last few months when I have been able to hit the beach every few days!
I am pretty much self taught in vba code, but it is easy when there is so much code out there to copy from and apply to what you need once you know the basic principles.
Feel free to ask questions on these forums to get people to explain how different bits of code work so you learn more.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks