Forum

Pls refer attach if can help.

Or using countif formula, simple way out =COUNTIF(Sheet2!$A$2:$A$19,A2) =COUNTIF(Sheet2!$A$2:$A$19,A3) =COUNTIF(Sheet2...

Philip, thanks again your effort Then, how to write the Macro to auto save the file in xlsx OR xlsm format, and at the same time the Work book...

Thanks so much Philip! Yes , agreed it works with a separate file but not work in a Macro workbook. I capture the screen for reference but sorry...

The macro work on a seprate Excel file but not in a macro workbook, which contains some other Macros

Thanks got it !

Any hints?

=RIGHT($A1,FIND("(",$A1,1)+1)

Thanks Philip, I manage to resolve it. so pls close this case.

Sub RepeatRowsExceptLastPage() Dim xPages As Long, I As Integer, xRg As Range On Error Resume Next xPages = ActiveSheet.PageSetup.Pages.Count Set xRg ...

OK , noted tks the clarifications.