View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andresg1975 andresg1975 is offline
external usenet poster
 
Posts: 60
Default copy cell from above with opposite sign

i have a column containing numbers, every other row there is an empty row, i
would like to copy the cell from above with the opposite sign to that empty
row, how can i do that with a formula or macro. So that i don't have to do
that one by one. Thanks a lot.