Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I make the reference link match the new formatting of its
My issue is that if the source data formatting is changed, the change in the
formatting isn't reflected in the referebce link on the destination worksheet. For example: I have a link in cell A1 in Tab1 pointing to A1 in Tab2 which starts by being a dollar amount ($1,000). If I change A1 in Tab 2 to a percent and change it's formatting to (.50%), the link in Tab 1 stays formatted as a dollar amount ($0.50). How can I make the reference link match the new formatting of its source? I would appreciate any help you can provide. Thank you, -- Suzanne Marie |
#2
|
|||
|
|||
Formulas can't change formatting--they can only return values.
Maybe you could have a macro that copies formatting from one cell to another--maybe even an event macro??? Suzanne Marie wrote: My issue is that if the source data formatting is changed, the change in the formatting isn't reflected in the referebce link on the destination worksheet. For example: I have a link in cell A1 in Tab1 pointing to A1 in Tab2 which starts by being a dollar amount ($1,000). If I change A1 in Tab 2 to a percent and change it's formatting to (.50%), the link in Tab 1 stays formatted as a dollar amount ($0.50). How can I make the reference link match the new formatting of its source? I would appreciate any help you can provide. Thank you, -- Suzanne Marie -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make cell address reference increment? | Excel Worksheet Functions | |||
How do i make a formula reference the last entry of a column | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
match data to reference then vlookup | Excel Discussion (Misc queries) | |||
Make cells match | Excel Discussion (Misc queries) |