How to make auto-update data for same cell multiple sheets of another workbook ?
And also need to show how to start in VBA ?
How to make auto-update data for same cell multiple sheets of another workbook ?
And also need to show how to start in VBA ?
Google is your friend: https://www.google.com/search?client=…n+vba+for+excel
Please explain your requirements with more detail
I would like to auto update data on same cells in multiple sheets to another book .First book have the data in A2, A4, A6, A8 in every sheets and I would like to auto update to another book like B3, C3 , E3 , F3 like this. Even new sheet have't created , the data auto update to second book in the future.
Could you help me ,please ?
Unfortunately ... your explanation is not very clear ...
As a first step, could you describe the simplest process you need ...
Data in Same cells of multiple sheets are copy to another books automatically without opening 2nd book.
At last ... you are clarifying your need : Working with Closed files
https://exceloffthegrid.com/getting-values…excel-workbook/
Hope this will help
Any feedback ... ???
The requirements are still not clear. Are you wanting to overwrite the cells or save into a database type sheet?
If you want to overwrite the existing target cells, then it's simple to link the cells
Create an external reference (link) to a cell range in another workbook
Don’t have an account yet? Register yourself now and be a part of our community!