Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a single cell value to repopulate multiple cells
Hi,
I am a relative newcomer to Excel, so forgive me if this is either impossible or a completely backwards way of working. My boss has given me a challenge to turn a huge spreadsheet he has of projects into neat individual report style layouts which he can print off and give to his bosses. Each row on the sheet has to have a seperate report. Now I can create a simple report style template in excel, with fields which reference each specific cell in the original sheet. What I want to know if it is possible for me to change all the cell references by altering the value in one cell. For instance if i created a cell with a number in it, lets say '5'. Is there a way I can get the cell references to recognise this as a row number (i.e. =Thefulllist!E5) so that if i changed the value to say 8, all the row references would change as well (i.e. =Thefulllist!E8), repopulating the data? I cannot alter the structure of the original table as it is in use company wide, nor do I have access to Access. Thanks, Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS | Excel Discussion (Misc queries) | |||
How do I return the vale of multiple cells into a single cell | Excel Worksheet Functions | |||
Auto fill multiple cells depending on single cell value | Excel Worksheet Functions | |||
city, state, zip from a single cell to multiple cells | Excel Discussion (Misc queries) | |||
Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions |