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...

(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?

Sorry mate but I'm really struggling to visualise what you mean.

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?

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.

Perhaps

Drop down list

+

Vlookup

Q

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.

Not sure that it will hep but have you looked at my Ref Libary?


http://lindburghs-reference-library.wikispaces.com/Introduction