hello!
Scenario: I currently have 3 workbooks that contain data, and i need to transfer said data to another workbook. The 3 workbooks will be updated in the future, so i need to have the single workbook that will contain the data from the 3 others be able to refresh to see any changes that might have been made.
the data transfer doesnt scare me much but the refreshing option does
what do?
You could simply create linked cells and NO vba. Just refresh whenever you want with DATA- REFRESH.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Not really even sure why you would need refresh at all either?
If you just use regular formulas they will update as new data is added?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks