i have Created 40 sheets when i cahnge the date in colum u3

November 30, 2012 at 23:57:39
Specs: excell
i have Created 40 sheets when i cahnge the date in colum u3 sheet1 one i need to change automatically in all other sheets if you can help in this matter it would be great

See More: i have Created 40 sheets when i cahnge the date in colum u3

Report •


#1
December 1, 2012 at 05:15:11
You said: "...when i cahnge the date in colum u3 sheet1 one"

"Colum u3 sheet1 one" doesn't make sense. I assume you mean Sheet1!U3.

Two options:

1 - You can click the tab for Sheet1, then shift-click the tab for the last sheet. This will group the sheets together and any change you make to any sheet will be made in every sheet. You can also Ctrl-click sheet tabs to group specific sheets. Just remember to ungroup them when you are done making the mass change.

2 - Group Sheets 2-40 and enter =SHEET1!U3 in U3 of Sheet2. U3 on every sheet will reflect whatever is in U3 of Sheet1.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question