Auto Update a workbook with multiple sheets on one sheet of the same workbook.

Closed
Report
Posts
1
Registration date
Tuesday April 24, 2018
Status
Member
Last seen
April 24, 2018
-
 Blocked Profile -
Good pm.
I need your help in order to enable me carry out update in ms excel.

I have a workbook with multiple sheets (namely, creche , nursery1, nursery2 and so on to grade5). I to wish to generate a daily report of changes made on the various sheets to the summary report sheet on the same workbook. Please somebody help me. And is it possible to auto input date upon entering the data?

Thank you in advance

1 reply

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!


0