Keeping currentmonth year from sheet to sheet

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
i have created a workbook that contains 5 sheets that need to have a month and year,that i use every month. i would like to enter the month year on first sheet, and have the remaining sheets with the same month year.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
suppose you have an entry in A1 ins sheet1 you want the same entry to be made in all the sheets in A1.

keep control key down and select all the sheets. enter you entry inA1 in sheet 1