Forum Discussion
Solved
Copy cells which contain a reference to another worksheet - Excel 2010
I have a workbook with a number of worksheets which are all the same apart from the title of the worksheet. They are Invoice 1008, Invoice 1009, Invoice 1010 etc. I have a (totals) worksheet which ...
Thank you - I saw something about the % sign but wasn't sure where to put it. I've only done very simple references and formulae before. I'll try this solution.
Hello Canterslowly,
That could be like this:
="='Invoice "&1000+ROW(A8)&"'!$N$22"
Then copy the list and paste values.
Thank you - I saw something about the % sign but wasn't sure where to put it. I've only done very simple references and formulae before. I'll try this solution.