Alexandra
06-09-2014, 07:45 AM
Hi,
I'm having a workbook in which I want to summarise values with calculations from other sheets for each reference. Please see attached example workbook; In cell A2 of sheet "Summary" you can change the number of the reference from 1 to 15, the cells next to it return the calculated values from a different sheet. In the rows below I would like to have copy - pasted as values the calculated values for each of the references, eg in cell B3:F3 for reference 1, in cell B4:F4 for reference 2 etc etc.
Hopefully you have a simple solution for this.
Thank you
11798
I'm having a workbook in which I want to summarise values with calculations from other sheets for each reference. Please see attached example workbook; In cell A2 of sheet "Summary" you can change the number of the reference from 1 to 15, the cells next to it return the calculated values from a different sheet. In the rows below I would like to have copy - pasted as values the calculated values for each of the references, eg in cell B3:F3 for reference 1, in cell B4:F4 for reference 2 etc etc.
Hopefully you have a simple solution for this.
Thank you
11798