Doc Sir i have a similar problem like this
Code:Sub STEP4() Dim w1 As Workbook, w2 As Workbook Set w1 = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\1.xls") ' change the file path Set w2 = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\FundsCheck.xlsb") ' change the file path w1.Worksheets.Item(1).Columns("A:H").Copy w2.Worksheets.Item(1).Columns("A:H").PasteSpecial Paste:=xlPasteValuesAndNumberFormats w2.Save w2.Close w1.Close End Sub
this code paste the data to sheet1 what i need is to paste the data in sheet2 so what i should do for the same sir plz help me sir in solving this problem sir




Reply With Quote

Bookmarks