conditional copying

drag-driver · Mar 5th, 2002, 06:33 AM

Want to copy a row to a new sheet only if the condition in another cell is true.Dont want it to copy the cell if the condtion is false.

Mudface · Mar 5th, 2002, 07:31 AM

If your True/ False condition is in cell A1 then it would just be something like

If Cells(1,1) Then ... ' Copy and paste code here.

drag-driver · Mar 5th, 2002, 08:04 AM

Idont know how you do this using the if functiona and if it can be done in vb i dont have know what code to use

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 06:33 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	Want to copy a row to a new sheet only if the condition in another cell is true.Dont want it to copy the cell if the condtion is false.

Mar 5th, 2002, 07:31 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	If your True/ False condition is in cell A1 then it would just be something like If Cells(1,1) Then ... ' Copy and paste code here.

Mar 5th, 2002, 08:04 AM	#3
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	Idont know how you do this using the if functiona and if it can be done in vb i dont have know what code to use