Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Referencing Formatting Across Worksheets
Hi,
I'm trying to make a summary of a source worksheet and am able to copy the data across using: 'Sheet1'!A:A , but I also need to formats (Cell width/Shading/Font/Border) to be referenced across as well, so that any updates (e.g. inserting a row) in the source sheet are updated in the resulting summary. Any ideas? Many thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Referencing Formatting Across Worksheets
Link does not link formats. You could create a macro to perforn the
Copy/PasteSpecial rather than do it by hand. -- Gary''s Student gsnu200707 "Tiny300" wrote: Hi, I'm trying to make a summary of a source worksheet and am able to copy the data across using: 'Sheet1'!A:A , but I also need to formats (Cell width/Shading/Font/Border) to be referenced across as well, so that any updates (e.g. inserting a row) in the source sheet are updated in the resulting summary. Any ideas? Many thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Referencing Formatting Across Worksheets
Thank you for your reponse. But if data can be copied this way, surely
formatting could be replicated in the same way. Also if I write a macro would this update the summary sheet everytime sometime changes on the Source sheet. Many thanks "Gary''s Student" wrote: Link does not link formats. You could create a macro to perforn the Copy/PasteSpecial rather than do it by hand. -- Gary''s Student gsnu200707 "Tiny300" wrote: Hi, I'm trying to make a summary of a source worksheet and am able to copy the data across using: 'Sheet1'!A:A , but I also need to formats (Cell width/Shading/Font/Border) to be referenced across as well, so that any updates (e.g. inserting a row) in the source sheet are updated in the resulting summary. Any ideas? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing worksheets | Excel Discussion (Misc queries) | |||
Referencing Worksheets | Excel Discussion (Misc queries) | |||
Absoulte referencing between worksheets | Excel Worksheet Functions | |||
Referencing worksheets | Excel Worksheet Functions | |||
Referencing Variable Name Worksheets | New Users to Excel |