Identical value and formatting from one tab to another within one sheet
Identical value and formatting from one tab to another within one sheet
I have a field on TAB1 D3 that is a Hyperlinked field to an external web site. I want TAB2 field R5 to have the same value, and be updated only if Tab1 D3 is modified
I have utilized in Tab2 Field R5 "=Tab1!D3" but it does not bring over the formatting of the Hyperlink.
The 'formatting on each field is "General"
Any help?
To copy FORMATTING from one cell to another requires VBA, or a manual process. The cell must be physically copied. Is VBA allowed in your project?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Do you have an example of VBA for this activity?
In the sheet module, let's say TAB1, this code would copy the cell D3 to TAB2:R5 anytime D3 was physically edited.
Please Login or Register to view this content.
Not sure if this helps your case, but here is a workaround I found to allow copying hyperlinks from CellA to CellB (even on other tabs):
- Instead of constructing a HYPERLINK(url, link_text) where the url and link_text are specified directly in CellA's formula, put the url and link_text into separate cells (say, URL1, LT1). Then, have both CellA and CellB share this formula: =HYPERLINK(URL1, LT1).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks