hello. Don't know if this has been asked before but it is doing my head in.
Using Excel 2010, I am creating a workbook to set up a register of risks.
Each risk has its own tab along the bottom (Risk1, Risk2, etc you get the idea) and I am trying to create a summary spreadsheet where some of the details are displayed, for ease of control etc. Like Title, probability, when raised, who owns it etc....
The pain is, I have created the first row, picking detail from Risk1 tab. What I want to do is then drag and fill the rest of the rows to select the other tabs information. but what is winding me up is that I just get the following.
cell B4 =Risk1!B2
cell B5 =Risk1!B3
cell B6 =Risk1!B4 when what I want it to read is Risk2!B2, Risk3!B2 and so on and so forth.
Is this possible or am I just being thick about it.
thanks in advance
Bookmarks