Hi,
I want to extract data from B column i.e just right of Ledger: only to H column corresponding to date which is in A column.
There are data is all over which is to be left intact. Momentarily, unnecessary data I a have removed from all around.
Hi,
I want to extract data from B column i.e just right of Ledger: only to H column corresponding to date which is in A column.
There are data is all over which is to be left intact. Momentarily, unnecessary data I a have removed from all around.
How is the date corresponding?
I mean based on what date / date interval do you need the data in column H?
To show your appreciation
Click ★ Add reputation!
Hi all. You could try with:
PHP Code:
Sub Macro8()
Dim Rng As Range, C As Range, D As Range
Application.ScreenUpdating = False
Set Rng = Range("A5", Cells(Rows.Count, 1).End(xlUp)): Set D = Rng(0, 1)
Set C = Rng.Find(What:="Ledger:", LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext)
While C.Row > D.Row
With C.CurrentRegion.SpecialCells(xlCellTypeConstants, 1).Columns(1)
C(, 2).Copy .Columns("H")
End With
Set D = C: Set C = Rng.FindNext(D)
Wend
End Sub
You are always very welcome if you add reputation by clicking the * (bottom left) of each message that has helped you.
Thanx .It worked.
Thanks for the +Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks