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 |
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 |