Sorry mate but I'm really struggling to visualise what you mean.
| x404.co.uk http://www.x404.co.uk/forum/ |
|
| Excel Help http://www.x404.co.uk/forum/viewtopic.php?f=4&t=16427 |
Page 1 of 1 |
| Author: | snowyweston [ Mon May 14, 2012 9:46 am ] |
| Post subject: | Excel Help |
I used to quiz an old colleague of mine with these kind of questions, but I don't work with her anymore, so I've got no option to throw it out here... I want a drop down list/lookup of some kind (I can't remember the function - which has made googling & navigating the help difficult) - where effectively I have a worksheet that acts as a "front page" - and in the first cell I can choose from a list, that then populates the cells (of that first worksheet ) with the contents from other worksheets. Vague, I know. I'd post a picture but I can't remember by photobucket login... |
|
| Author: | snowyweston [ Mon May 14, 2012 10:27 am ] |
| Post subject: | Re: Excel Help |
(I fear this is going to be a ranting lonely mumble more than a thread full of specific "help with this" questions) Okay so I've remembered that I use Data>Validation to get a drop down of cells, that's done, but how do I now make the columns (and rows) beside this selection list to automatically fill with the content on each worksheet? |
|
| Author: | AlunD [ Mon May 14, 2012 4:52 pm ] |
| Post subject: | Re: Excel Help |
Sorry mate but I'm really struggling to visualise what you mean.
|
|
| Author: | snowyweston [ Mon May 14, 2012 6:57 pm ] | |||||||||
| Post subject: | Re: Excel Help | |||||||||
Now that I'm home, (where I've all my logins all saved!) hopefully a picture (with some extra ranting) will explain everything....  Essentially, the green field on the worksheet "REPORT" would be the only field the user would "operate" (picking between "A", "B" and other subsequent worksheets, ideally with a wildcard that would allow further worksheets to be added, and be automatically included in the list) In doing so (switching between) the data of the worksheets would be pulled into the "REPORT" worksheet. The idea being - the worksheets "A", "B", etc would contain data sets that could grow, ever downwards, in a raw, unformatted manner - and the "REPORT" worksheet would act as the frontend to it all. I would also like/love the blue column fields to be one of those fixed constants - where "A", "B" (and any other subsequent worksheet) would automatically have them - all to minimise editing. Make sense?  
|
||||||||||
| Author: | AlunD [ Tue May 15, 2012 6:08 am ] |
| Post subject: | Re: Excel Help |
sounds like a pivot table may well be the solution I'll try and have a look at it today. emailed you an example I hope its the sort of thing you meant. |
|
| Author: | Sharks [ Mon May 21, 2012 3:26 pm ] |
| Post subject: | Re: Excel Help |
Perhaps Drop down list + Vlookup Q |
|
| Author: | snowyweston [ Fri May 25, 2012 7:36 am ] |
| Post subject: | Re: Excel Help |
Cheers Sharks, and thank you again Alun, I've yet to return to this (it's a project, more than a necessity) but will definately look into these soon. |
|
| Author: | Lindburgh [ Fri May 25, 2012 12:35 pm ] |
| Post subject: | Re: Excel Help |
Not sure that it will hep but have you looked at my Ref Libary? http://lindburghs-reference-library.wikispaces.com/Introduction |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|
