CUT & PASTE a Row & Worksheet toghether.

[coxycoxycoxy]

Good Morning.

Can anyone help, i would like to cut a row(s) from a worksheet & also another worksheet within the same workbook Together.

I'm am using excel as a small inventory and have one worksheet for each of the items we stock and for each worksheet their is a row which has pasted links in a control sheet. (or index Sheet) the following piece of code renames the worksheet based on the product code entered in cell E3 of that worksheet

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) <> "E3" Or Target.Count > 1 Then Exit Sub
ActiveSheet.Name = Left(Target, 31)
End Sub

Their is then another macro that paste the links form the worksheet to the control sheet, so the sheet name is always the same on the control sheet & worksheet.

the Control Sheet is Called "CONTROL.SHEET" and the links that display the product codes/sheet names are in column B on the control.sheet.

so my question is: Is their a way using vba to cut the row from the CONTROL.SHEET and the corresponding worksheet using the sheet name as a reference. and pasting both to a different workbook Called ZERO STOCK. keeping all conditional formating and pasted links.

I am aware this is probablly a tall order, but if anyone help or shed some light it would be most appreciated.


Best Regards

Mark