Hi, I would like to extract data from a excel table by vba: if ws1.cell (i,1) = "AAA" then copy ws.1.cell(i+1,1) to ws.1.cell(i+9,1) to column A of ws.2. Please help, thanks.
Hi, I would like to extract data from a excel table by vba: if ws1.cell (i,1) = "AAA" then copy ws.1.cell(i+1,1) to ws.1.cell(i+9,1) to column A of ws.2. Please help, thanks.
![]()
Sub sintekJ3v16() Dim X With Sheet1 X = Application.Match("AAA", .Columns(1), 0) .Range("A" & X + 1).Resize(10).Copy Sheet2.Range("A1") End With End Sub
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks