i have attached sample file plz see the file and run the macro, everything is perfect with this code but it paste the data incorrectly to 2.csv ...
Problem Solved Thnx Alot Sir for ur great help
Sub Not_tested() Dim wkb1 As Workbook, wkb2 As Workbook Dim sBk1 As String, sBk2 As String Dim ws1 As Worksheet, ws2 As Worksheet Dim rg1 As Range...
plz see the below attachment
i tried the code but i met with the error with this line c = ws2.Columns(2).Find(.Cells(i, 9))
Sub test() Dim wb1 As Workbook, wb2 As Workbook Dim ws1 As Worksheet, ws2 As Worksheet Dim rg1 As Range, i As Long, c As Range Set wb1 = Workbooks.Ope...
Philip Sir i dont know much about vba but i know how to open the file by vba actually i am unable to write the condition in vba language so can u...