Forum

Pls find attached sampls data file

I tried and confirm the Syntex work. Thanks again Sunny.. If Not IsDate(Cells(i,1)) Then

Tks will try

Sub DelRows() Dim LastRow As Long Dim i As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row Application.ScreenUpdating = False For i = Las...

Tks Sunny , it work perfectly!

How to modified teh VBA if this cell range contains multiple criteria , say " ABC co" , "Dept", "Allocation Code" , "Currency","Country" and to be...

for demonstration can you proive one Execel file that show the gIf file works?

BUT CAN NOT DISLCOSE ACTUAL DATA IN THE FORUM, MAY BE I TRIED MANUIPULATE THE ACTUAL DATA AGAIN, SEE WHAT CAUSE THE PROBLEM..SORRY THE CONFUSION ...

I tried with the test data OK But when replace with actual ie data to run failed with following error. so what should I pay attention whe...

Data not genuine ie modified for macro extract purpose ..

Yes I know but they are consistent somehow, what I want is to extract the follow row data in column form filed data using a macro, detaisl filed to ...

sorry file size too big . now trim the file for testing

So OK or not ?the add-in