Hi

Sorry if my response seemed a little obtuse. What I meant was that I didn't think a solution could be suggested without seeing how complex the formulae that your wanting to show steps for will be, which you have now provided.

As your performing the same calculation each time, and the configuration of each formula is the same, I went for parsing out each element into a separate cell (Cols P to AX). It didn't take long to build one row, and from there you can copy down as many rows as you want. The only problem is that it gives a text result, which will be fine if you dont need a calculation result to prove that the steps are defined correctly. Hopefully this can be established just by checking the entries on an example.

If you need a calculation result

1. Contatenate Cells in Cols P to AX ( as Ive done in Col AZ)

2. Copy and Paste Special Values from AX to (eg) BB

3. Finally Edit the data in BB, delete and reinsert the = sign at the start of the text, which changes it to a formula.

Anyone interested in checking a sample could simply perform step 3 and then undo when they are happy its OK

Sorry - 2 above should read "........... from AZ to (eg) BB"

HTH

Herc