Forum

Hi Paul, You can use this Range("B2").Copy Range("B1").PasteSpecial xlPasteFormulas Application.CutCopyMode = False Regards Phil

Glad to help 🙂

Hi Mariya, Please see attached. Splitting up the code is pretty straightforward using VBA string functions You could also read my Excel Forms p...

Hi Bill, No file attached. regards Phil

Hi Herman, Please supply your workbook with the data laid out as you will use it, and as you expect it to look in the end result. Giving you an an...

Hi Mariya, Can you please supply your workbook and code otherwise anything we write will have to be rewritten to suit your environment. Thx P...

Jimmy's workbook is attached below.

Hi Jimmy, Do you have a workbook with sample data we can see? Regards Phil

Hi, I understand what you are asking but in your sample file, the Expected Output has no data in it and the sample data layout is incomplete? Ma...

Hi Bill, No VBA required for this, see attached workbook. =SUBSTITUTE(A1,","," and",LEN(A1)-LEN(SUBSTITUTE(A1,",",""))) By using SUBSTITUTE t...

Hi Trond, There's no attachment. Regards Phil

Hi Humayun, This is what you are looking for these posts will also help Regards Phil

Hi Hope, Please provide a workbook with data. Recreating your data takes time and is prone to error if we do it by hand. Best for you to supply i...

Hi Tiffany, You're calculating a percentage by dividing three numbers =IFERROR(1-((SUMIF($D$18:$D$67,E$1,$P$18:$P$67))/(SUMIF($D$18:$D$67,E$1,$O...

Hi Martin, Please supply the workbook so we can help. Phil