Keeping currentmonth year from sheet to sheet

Closed
w - 1 Dec 2009 à 14:49
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 1 Dec 2009 à 19:18
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 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
1 Dec 2009 à 19:18
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