Dear All
I have a macro that populate the spreadsheet for all workingdays of a month, and name them accordingly. I have 2 additional steps which I want Macro to help me with.
1. After populating the spreadsheets, what I need is in the master file, which is the first file of the work, the code should populate the same date, as that of tab in Row # 2, starting Cell#C2 and horizontally further in the same row.
2. Further I want the formulae to get updated automatically for each of these dates coloum. The formulae will be picking up the value from a fixed cell from the respective date tab.
Please help me out. I have strain my brain enough on this, but I am not reaching anywhere near to the objective.
Thanks in advance.
Regards
Gaurav
I have a macro that populate the spreadsheet for all workingdays of a month, and name them accordingly. I have 2 additional steps which I want Macro to help me with.
1. After populating the spreadsheets, what I need is in the master file, which is the first file of the work, the code should populate the same date, as that of tab in Row # 2, starting Cell#C2 and horizontally further in the same row.
2. Further I want the formulae to get updated automatically for each of these dates coloum. The formulae will be picking up the value from a fixed cell from the respective date tab.
Please help me out. I have strain my brain enough on this, but I am not reaching anywhere near to the objective.
Thanks in advance.
Regards
Gaurav
