Auto Update a workbook with multiple sheets on one sheet of the same workbook.
Closed
topkentalk
Posts
1
Registration date
Tuesday 24 April 2018
Status
Member
Last seen
24 April 2018
-
24 Apr 2018 à 09:26
Blocked Profile - 24 Apr 2018 à 16:44
Blocked Profile - 24 Apr 2018 à 16:44
Related:
- How to make one excel sheet update another
- How to copy data from one excel sheet to another - Guide
- How to copy data to multiple worksheets in Excel - Guide
- Excel link to another sheet - Guide
- How to transfer data from one Excel sheet to another? - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
Why are you using a spreadsheet to track data? Use a Database. It seems as though you are in Education, why not use the proper tools for your job?
So, there will be questions about your solution. Like: Do you want a button to trigger these checks, or does it just happen?
Have you read this yet?
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
It is everything you need for your solution......
Post some of your code here and we can help. If you have no idea of what code to start with, RECORD a macro of what you are wanting to do, and apply that code to the model found on the above linked page (use variables!)
Post back if you get stuck!
So, there will be questions about your solution. Like: Do you want a button to trigger these checks, or does it just happen?
Have you read this yet?
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
It is everything you need for your solution......
Post some of your code here and we can help. If you have no idea of what code to start with, RECORD a macro of what you are wanting to do, and apply that code to the model found on the above linked page (use variables!)
Post back if you get stuck!
