Hi all,
First time posting on this site so apologies if this is in the wrong section.
I've been asked to create a construction project report for our client showing progress, this will be updated periodically. Data will be exported from another application to a data dump sheet, and this will be presented on a linked cover sheet. I'd like to automate as many of the features as possible and am hoping the community can solve a problem.
The cover sheet shows tasks in a row down the left hand side, and individual dates along the top - so far so simple. The dates are presented as year in the top row, then month, then date and then weekday. The year and month rows are presented as the cells between the start and finish dates are "merged & centred" and the relevant info typed in. The date row is linked directly to the data dump sheet, and so when the report is updated the dates will appear'/disappear accordingly. I have formatted the sheet so that the weekday in the row below each date is automatically updated.
The problem arises with updating the month and year. At present this must be done manually at each update: as they are not linked to any other data they remain static when the dates below them change. Merge and centre is used on the individual cells in the Month row above the date to match the correct start and finish date for each month, and then the month typed in. Same goes for the year.
Is there any way this can be automated on the cover sheet?
Many thanks in advance,
n_g
Bookmarks