Thread: Copy Data from Worksheet1 to Worksheet2 IF Worksheet1 Column D = Y
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Copy Data from Worksheet1 to Worksheet2 IF Worksheet1 Column D = Y
Formula entered in A1 of HOA Forms sheet.

=IF(JanObs!D1="Y",JanObs!D1,"")

Drag/copy down as far as you wish.


Gord Dibben MS Excel MVP

On Thu, 24 Jan 2008 15:14:29 -0800, jeannie v
wrote:

Hi Experts:

What I would like to do is copy the data from Worksheet1 titled "JanObs" and
paste it to Worksheet2 titled "HOA Forms" IF Column D on "JanObs" = Y

How can I do this either with formula or Macro?

Any help would be appreciated.

Reply With QuoteReply With Quote