chrisbibby
Technical User
OK, I have a sheet with links to text items - I want to change these references to the actual data it references - ie replace the cell references to the actual text strings referenced - how do I do it??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Quickie for Y'all 1
- Thread starter chrisbibby
- Start date
- Status
- Thread starter
- #3
chrisbibby
Technical User
But I get errors relating to merged cells having to be the same size?
-
1
- #4
I hope this isn't a large worksheet. MS Excel will not allow you to select a merged cell and an unmerged cell to copy and paste. The only way that I've been able to do this is to select the merged cell by itself then copy and paste special\values.
- Thread starter
- #5
chrisbibby
Technical User
Cheers Luceze,
That does it if I select the unmerged cells - not a stunningly elegant solution but it works, an easier way would be nice - never mind eh?
That does it if I select the unmerged cells - not a stunningly elegant solution but it works, an easier way would be nice - never mind eh?
- Status
Similar threads
- Locked
- Question
- Locked
- Question