Hi all,
I'm trying to get some help in creating a file to summarize data monthly and weekly.
-The workbook contain one main sheet where data will be entered and the date will be changed ( month and year) . Once the data is entered, you click on the update button and a new sheet will be created according to the date ( month and year).
The second sheet on the workbook you will find attached is the sample of the monthly sheet output.
all the Cell on the workbook will be looked except the field where to enter the data on the main sheet and to change to month and year.
With some conditioning formatting I succeeded in highlighting the weekend when date are changed.
As I'm very beginner with programming in Excel I will need some help in figuring out to establish the relation between the sheets on the work book ( creating a new sheet for each month and update the sheet if any changes were made to that month )
Any help is appreciated thank you very much.
Bookmarks