View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Julie Julie is offline
external usenet poster
 
Posts: 150
Default Copy Info from 1 sheet to another within same workbook

I have a spreadsheet that has two sheets. I would like some of the
information on sheet1 to also be in sheet 2 (protected). When I update sheet
1, I would like it to automatically update sheet 2. I know how to do this,
what I cannot figure out is:

If I insert a new row in sheet 1, sheet 2 does not update. Is there a way
to have this information mirror sheet 1 exactly? (fonts, sizes, colors, etc.)

Thank you!!