Thread: Copy from one named cell to another dependent on content of a third.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes Colin Hayes is offline
external usenet poster
  
Posts: 465
Default Copy from one named cell to another dependent on content of a third.

HI

I have a small puzzle.

In Column H I have a row of numbers. All ones and threes , with some
blanks.

If the number in H1 is a 1 , then the content of B1 should be copied
into K1.

This would apply to all cells in H which contain a 1. All other numbers
would be ignored.

Can this be done?

Grateful for any assistance.
Reply With QuoteReply With Quote