Quote:
Originally Posted by NBVC
The one I highlighted in red. The In your sample A3 contains an "A". If you have a sheet named "A", the formula will indirectly reference that sheet so that it get the info required. As you drag the formula down, it changes to A4 and therefore it should get the info from sheet named "B", and so on...
|
My apologies for not responding sooner, NBVC, but I have been out of action for some time.
My first sheet is named Pen and the 2nd is named Pencil. I have tried changing the $A3 in to both of the names but cannot get it to work and cannot work out what I am doing wrong.
The columns I am trying to read the info from are A B C & D and the input columns on the result sheet are B C D & E. Does this make a difference?
Thanks,. Rob
11-20-2017, 05:16 AM
Similar Threads
Consolidation of multiple sheets in Pivot
Windows 7 64bit 
Office 2016
Hybrid Mode