View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Linking between 2 worksheets

=if(master!a1="","",master!a1)



Carla wrote:

I have a master price list that is linked to another worksheet in the same
file. I have a column for the date that I update the pricing, although some
cells don't have anything filled in. When I copy from a cell that has
nothing in it and paste the link in another worksheet, it shows as a "0". Is
there any way to fix this?


--

Dave Peterson