Quote:
Originally Posted by Cemetery
Never mind, just realised you can copy the column and paste as a link which does the job albeit not completely tidily  |
If your worksheet can handle as many formulas as you need you could place this formula in every cell that would need it.
=if(Sheet1!a1="","",Sheet1!a1)
Keep in mind that VBA can make this extremely easy. I use to always want to do just formulas as well until I actually learned VBA now I almost always use VBA for large sets of data.