View Single Post
 
Old 10-19-2015, 07:58 AM
derohanes derohanes is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: Oct 2008
Posts: 67
derohanes is on a distinguished road
Default Using a value in a cell to display another cell

I have worksheets labeled from C1 to C13. The titles of the worksheets are in cells A1 of each worksheet. I want to create an index worksheet with the format of the worksheet in column A and the values of each of the respective contents of A1 in column B of the index worksheet. I have listed the worksheet names - from C1 to C13, and concatenated a string in column B to read C1!A1, C2!A1, etc. How do I get the actual value to show up on the index worksheet?
Reply With Quote