Consolidating data - getting the worsheet names to display

sagekey

New Member
Joined
Sep 16, 2008
Messages
1
I've done an Excel Data Conolidation, and it works fine, however when expanding the Consolidation, it doesn't show the name of the worksheet its picking up the data from, it merely repeats the name of the workbooks... which is not so useful - any suggestions?

P.S I have a worked example I can email
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Watch MrExcel Video

Forum statistics

Threads
1,099,462
Messages
5,468,786
Members
406,608
Latest member
G3TEN

This Week's Hot Topics

Top