Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create an Identical Worksheet
Hello,
I would like to know if it is possible in Excel to create an identical worksheet / named area. For example I have a named area in a worksheet and I would like to have the identical named area in another worksheet. If a change is made in one worksheet I would like the change to update automatically in the other. The formatting (borders etc) also needs to be identical in both spreadsheets. I thought I had found a solution using external data. If I delete an entry/entries in one worksheet, click refresh data the other worksheet is updated, but this causes problems with the formatting in the 2nd worksheet. I need to have both area's identical whatever change is made in one i.e. Font size the same change is made in the other. Please can someone offer some advice. Regards, Brett |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create an Identical Worksheet
May be best to do by the Change event. In the sheet you want copied,
right-click the sheet tab, select View Code, paste thisin: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next Application.DisplayAlerts = False Sheets("CopyofSheet1").Delete Me.Copy Befo=Sheets(2) ActiveSheet.Name = "CopyofSheet1" Me.Activate End Sub Note -- this won't "fire" if you simply change a color or name a range, but any change on the sheet will do it. HTH "Brett24" wrote: Hello, I would like to know if it is possible in Excel to create an identical worksheet / named area. For example I have a named area in a worksheet and I would like to have the identical named area in another worksheet. If a change is made in one worksheet I would like the change to update automatically in the other. The formatting (borders etc) also needs to be identical in both spreadsheets. I thought I had found a solution using external data. If I delete an entry/entries in one worksheet, click refresh data the other worksheet is updated, but this causes problems with the formatting in the 2nd worksheet. I need to have both area's identical whatever change is made in one i.e. Font size the same change is made in the other. Please can someone offer some advice. Regards, Brett |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create an Identical Worksheet
Another option would be to select both sheets by holding the Ctrl key and
clicking on the tab. The information entered in the first sheet will also be entered in the second sheet. Gary "Brett24" wrote: Hello, I would like to know if it is possible in Excel to create an identical worksheet / named area. For example I have a named area in a worksheet and I would like to have the identical named area in another worksheet. If a change is made in one worksheet I would like the change to update automatically in the other. The formatting (borders etc) also needs to be identical in both spreadsheets. I thought I had found a solution using external data. If I delete an entry/entries in one worksheet, click refresh data the other worksheet is updated, but this causes problems with the formatting in the 2nd worksheet. I need to have both area's identical whatever change is made in one i.e. Font size the same change is made in the other. Please can someone offer some advice. Regards, Brett |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create an Identical Worksheet
That won't copy over range names, however.
"Gary Rowe" wrote: Another option would be to select both sheets by holding the Ctrl key and clicking on the tab. The information entered in the first sheet will also be entered in the second sheet. Gary "Brett24" wrote: Hello, I would like to know if it is possible in Excel to create an identical worksheet / named area. For example I have a named area in a worksheet and I would like to have the identical named area in another worksheet. If a change is made in one worksheet I would like the change to update automatically in the other. The formatting (borders etc) also needs to be identical in both spreadsheets. I thought I had found a solution using external data. If I delete an entry/entries in one worksheet, click refresh data the other worksheet is updated, but this causes problems with the formatting in the 2nd worksheet. I need to have both area's identical whatever change is made in one i.e. Font size the same change is made in the other. Please can someone offer some advice. Regards, Brett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
quickly create extra copies of a worksheet template in a workbook | Excel Worksheet Functions | |||
how can create a formula to add data from 1 worksheet to another? | Excel Discussion (Misc queries) | |||
create menus in excel worksheet | Excel Worksheet Functions | |||
Create a "recap" worksheet that includes all info from all worksh. | Excel Worksheet Functions |