Previous Topic Next Topic

Keeping currentmonth year from sheet to sheet

Closed
w - Dec 1, 2009 at 02:49 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 1, 2009 at 07:18 PM
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

Answer 1 / 1
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Dec 1, 2009 at 07:18 PM
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
0