update month in all workbooks RRS feed

  • Question

  • Hi,

    I need help to do the following.

    I have about 50 reports saved in a folder. They are basically exactly the same in terms of lay out etc.

    In cell a7 in all of these workbooks is the date, displayed as the first 3 characters of the month, i.e jan, feb, mar etc.

    I have another spreadsheet with a list of these, from jan-dec from a drop down.

    What I want to do is tell excel

    Based on the month I select, enter that month in cell a7 in all workbooks in that file.

    Any help would be great.

    Wednesday, August 21, 2013 9:04 AM

All replies

  • Are the dates in A7 full dates (including year and day) or only months?


    Wednesday, August 21, 2013 12:15 PM