Help me copy data

Closed
vince - Nov 7, 2011 at 08:11 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 8, 2011 at 10:31 AM
Hello all ,

kindly help me copy data from A1 in sheet1 into A1 in sheet 2 only if value of M1 in sheet 1 is say "ok".



1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Nov 8, 2011 at 10:31 AM
Hi Vince,

Here you go:
Sheet 2 A1: =IF(sheet1!M1="ok",sheet1!A1,"")

Best regards,
Trowa
0