I have tried this and the read only version still permits changes. Also the instructions seem to geared towards Word and not Excel. Particularly the section "Restrict formatting and editing".
Thank you ADCWebb. Unfortunately your suggestion returns #VALUE!.
Also (and I realise I did not explain this very well), I need the result to return the file name and there are 65 different file names in the column, which would mean writing a formula for each file name find ie Site01, Site02 etc,. So would not be possible to copy the FIND formula all the way down the 65 rows.
I hope this makes sense?
Thanks, but this doesn't fix it.
Thanks Stevie, but this doesn't fix it.
I need the cumulative row to be dynamic & integral to the pivot table.
Not a separate row external to the table that links into pivot cells.
That the one - thanks!
Thank you Paul.
I think is your solution 'C' I am looking for.
I recall the N part, but thought there was a way of associating it with each value. i.e. text, then value; text then value. I was shown it on an Excel course I attended, but it was some time ago now so my memory may be letting me down.
But this will definitely get me on my way.
Thanks for your solution - it works a treat.
Richard - thank you
I had been fiddling around trying to nest "OFFSET" in a lookup.
Your solution is just what I was looking for.
Many thanks for all your helpful comments. I shall give them a go.
Thanks for your suggestion which works great!
I had a little difficulty in sizing down by dragging handles on one of the large embedded spreadsheets but got around it by using....
right click mouse over embedded object
Height (adjust in size and rotate)
Thanks you and feedback
Alan: Thanks - T1 & T2 can be in same workbook. I am seeking to achieve something along the lines of say a bank rec. Say Col A is the cheque number and Col B is the £, T1 is the cashbook and T2 the bank statement, the results required are:
(1) list all matching (cleared at bank) items
(2) list all unmatched items (uncleared at bank)
David: Thanks, will certainly look at your link.
Mike 1 & 2 - Thanks, I'll give it a go.
Alastair - Thanks, I had actually begun to take the concatenation and vlookup route but felt there was an easier way, hence my appeal for help. Agreed Access would be the way forward on this, once I am up to speed on this.