I've reached my wits end. I've scoured the internet, and searched through countless message boards looking for the answer to this issue. What's frustrating is I know it can be done, I just can't seem to figure out how to get all the pieces to work properly. I use a spreadsheet to monitor employee performance. Work done, hours worked, Errors made, and Efficiency. Each month I reload the template for the worksheets and start a new. Problem is, when it comes to reviews I need to go back over the past 12 worksheets and reload all the information into a new worksheet. I do the new worksheet for two reasons First and Foremost to send to HR with the employees review to justify my findings. Put the data in a much easier format for me to look at only a single employees performance for the past 12 months. The problem. Passing the variables from one cell to be used/manipulated into a sheetname for the purpose of referencing prior worksheets. IE excel doesn't appriciate me telling it =(B2+' EPI '+C2!D122) instead of =( 'January EPI 2011' !D122") My brain has exploded several times attempting to figure this out and the cleaning staff are growing irritable with scrubbing greymatter off the walls.
Hi, you could use INDIRECT() function. For ex. =INDIRECT(C1&"!B3"), gets the B3 cell value from an worksheet having its name written in the C1 cell (active worksheet). Enjoy !
