Copying formatting to cells from sheet to sheet

is it not already doing that ??? wat version of excel is it ? wen you copy and paste into a new file .. it should rememebr all the formatting... if its not.. you can always do Edit> Paste special and choose "formatting" or "all" ..

When you change the formatting of one sheet, it will not automatically change the formatting of all the dependents of that sheet on other sheets. It would require some coding (VBA/programming) to do that. Alternately, you'd need to paste the new formatting to the other cells using Paste Special.

If we are talking about identical tables on identical sheets, you can group the sheets by holding down the CONTRL and clicking on all the tabs you wish to change at once. Then whatever you change on the active sheet will be changed on all the grouped sheets (Remember to unGroup them when done!!!)

ChemistB

thanks Chemist...
essentially what i want to figure out is what kind of code or formula to use to copy the contents, formatting, font, shading and border of cell A1 from Sheet1 to cell A1 in Sheet2...make sense?

Yep, makes sense. As discussed above, if you are going back and changing the formatting after the fact, there's no formula or function that will take that formatting from Sheet1!A1 and apply it to Sheet2!A1. You could group them and change the formatting at the same time or you could repaste (special) the formatting to the other sheet or you could have one of the VBA gurus (I'm a novice) write some code that does it for you.
No easy answer here.

ChemistB