I’m trying to get one sheet of an excel workbook to completely mirror another sheet in a different workbook. I’ve tried referencing every cell, but it does not copy the formatting. Any help?
Popularity: 9% [?]
Incoming search terms:
- how to mirror an excel worksheet (2)
- excel 2010 mirror cells (1)
- mirror excel worksheet (1)
- mirror cells in excel (1)
- mirror cell spreadsheet (1)
- mirror cell from one worksheet to another (1)
- mirror an excel worksheet (1)
- how to mirror excel data (1)
- how do i see the merror workbook of excel (1)
- excel worksheet mirrored without formats (1)
August 12th, 2010 at 7:14 am
There was a command in word and excel that was called Paste Special from the edit menu. After copying the cells from the first workbook you go to the second workbook right click and select paste special then paste link. Select the correct options for you before you hit paste link.
August 12th, 2010 at 8:10 am
There is no built in function that will enable you to dynamically update the formatting of the mirror sheet. You could use VBA to do this, but it’s probably much more complicated than you’d want to go.
You can paste the formatting onto the other sheet, using paste special. Copy the range, go to the new location, right-click choose “paste special” and “formats”.
Also, you can quickly and easily create a copy of an entire sheet (formatting and all) by right clicking on the sheet tab.