Hi folks. Hope someone can help, I'm no Excel master by far so this is really escaping me at the moment.
I have some (that's an understatement) linked cells. The linking is fine, and what shows up is what should show up between the workbooks. However, let's say A is the main book and B is where data is coming from. A blank cell in B is pulled to A and shows up as "0".
This is very problematic, as these sheets I'm pulling from have numeric and text data. That is, sometimes the blank is intentional and a 0 in its place could potentially signal something in error.
Any way to remedy this at all? Some kind of small VBA script I could write? I had a VBA class a few years ago.
I have some (that's an understatement) linked cells. The linking is fine, and what shows up is what should show up between the workbooks. However, let's say A is the main book and B is where data is coming from. A blank cell in B is pulled to A and shows up as "0".
This is very problematic, as these sheets I'm pulling from have numeric and text data. That is, sometimes the blank is intentional and a 0 in its place could potentially signal something in error.
Any way to remedy this at all? Some kind of small VBA script I could write? I had a VBA class a few years ago.
Facebook
Twitter