Copy Data from Worksheet1 to Worksheet2 IF Worksheet1 Column D
Hi Gord:
I left out some important information! Would you please take a look at my
response to Max's solution and see if you can help me further?
Thank you for your expertise.
--
jeannie v
"Gord Dibben" wrote:
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.
|