i awnt to be able to populate cells from 'Raw' tab to 'Main' Tab. please seea ttached file.
i awnt to be able to populate cells from 'Raw' tab to 'Main' Tab. please seea ttached file.
Maybe this can do
Kind regards
Leo
AdvancedFilter should do.
Sub test() Dim rng As Range With Sheets("main") Set rng = .[t1].CurrentRegion .Cells(1).CurrentRegion.Offset(1).Clear End With With Sheets("raw").Cells(1).CurrentRegion .AdvancedFilter 2, rng, Sheets("main").Cells(1).CurrentRegion End With End Sub
Maybe:
Sub danallamas() Sheets("Raw").UsedRange.Offset(1).Copy Sheets("Main").Range("A2").PasteSpecial xlPasteValues End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks