Hello,
I have two codes that works well on shee1 but I would like the same to occur on Sheet2 and Sheet3
Example:
On sheet1 (named - Present MA) I have a module (the timer) Code enter a value of 1 in cell A1 , and a code in the sheet1 that clears the row from B1 to U1.
and same applies for each rows that receives value of 1 in column A.
On shee2 (named - Past MA) I have a formula in A1 (=Sheet1!A1) and I would like for sheet2 row B1 to U1 to be cleared as well when the formula result is 1
And Same should apply on sheet3 (named - Future MA)
Any help would be appreciated
Thank you
cheers
Nino
Code in Module:
Code in Sheet1:Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks