Pasting links between workbooks but ignoring blank cells

[USAOzi]

Is there a way to copy/paste links from one workbook/worksheet to another but ignoring blank cells in the source so that the destination does not display ####### content for the linked blank cells? This requires cumbersome, tedious and a great deal of time to "clean-up" the linked blank cells so the destination file blank cells appears as blank instead of ####### ?

 

[Joe4]

Cross-posted: https://www.excelforum.com/excel-ge...tween-workbooks-but-ignoring-blank-cells.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[USAOzi]

I don't know what cross posting is nor how to do it so I don't know what this is about. so basically are you saying my question is not posted anywhere for anybody to possibly assist with an answerr? If so, how do I? get my question to the correcrt area and not violate your policy?

 

[Joe4]

The link I provided explains it all in detail.

This describes what it is, and the concern with it: https://www.excelguru.ca/content.php?184
That link is found within rule 13 (our policy on Cross-Posting), that was referenced in the last post: https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

Please take the time to read those links I provided, and it should all make sense.