how to link format of cells

R

ramesh

I need to update the format/appearance (text and fill color, border etc) in
other worksheets, as and when I manually change them on the first sheet.
More clearly, I have to generate four different types of consolidated
reports from the daily reports. I have a master worksheet for
updating/entering the daily reports ( i change the cell content and
appearance). As a when I updated this worksheet for daily reports, the
relevant cells in the other sheets should display the same content and more
importantly should apprear same as in the daily report worksheet.
Can anybody help?????
 
S

Shane Devenshire

Hi,

Formulas do not pass formatting, they return values. You will need to
program Excel to handle this type of situation.

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top