list in old version 2003

As this will be a large project I thought i would ask you experts how best to do it so i do not have to do it twice!
measure twice - cut once sorta thing.

We wish to know what pictures we took on each date. like a diary

i.e. dec 20 2003 visited the santa barbara mission. or indeed any mission.or had an operation or whatever.

so i can say when did we have an operation or when did we visit a mission, car museum or any museum etc. and get the date to see the images.

i wont need more rows than a spreadsheet so i assume LIST will do it but how do i set it up, how many fields per day etc. we might do several things in a day

thanks for your help

I couldn't understand the issue. It seems that you want dynamic range, for this you can use offset function

Please attach worksheet.

thanks but there is nothing to attach.
i need suggestions BEFORE i create it on HOW to create it!

basically it will be like a diary. dates with activities.
i need to be able to ask excel what we were doing that day.

and when did we take pictures of ANY say museum

and when did we take pictures of say the san diego museum of man.

so we would ask it the question and excel would provide the date.

we might see several things in a day.

hopefully this helps.

I am sure it is simple.

thanks

i only need to use excel to locate the DATE the picture was taken. thanks

Originally Posted by davesexcel

I have a working sample here that you select a dropdown item, and the picture changes accordingly.
Just to get some ideas

i did not begin to understand which was the right one but it looks more than i need.
thanks

we have pictures digitally stored since digital cameras were first popular.

windows can find them by date.
so we need to be able to ask what were the dates we say went to a museum. best leave room for 100 dates as a result
thanks
creating the spreadsheet for all this data has to be done right first time- we do not want to do it twice!

Originally Posted by davesexcel

Would you like a code that will make a list of the files, and file dates?

i do not understand what you mean by code!
thanks

try from Microsoft - less troubles, more features

sandy666 is this an advert?

this is for free so it cannot be advert

HERE is a rough sample - further columns and ideas welcome!
hopefully a file is attached - note it is xls

wow very impressive!
thanks

HOW do i adjust it to ignore upper or lower text e.g. museum found nothing.
looks great!
is it okay with dates with no other field filled? idle days!
thanks

Originally Posted by davesexcel

So then it did ignore it? or do you mean you don't want it to ignore UPPER or lower cases?

Is what okay with dates?

it ignored the lower case museum found MUSEUM

if there are dates with nothing yet in the activities etc - will that cause a problem.

thanks

thank you very much
but it is year since i worked with macros...
how do i update the previous file?
i tried macros but did not find any!

thanks.
now to fill it up!

I was thinking
to make another one just for WHERE would that be simple?
i realise that combining them would just lead to problems, but a get where would be very useful
thanks

thanks you very much for including the B file. much appreciated.
Please include a just where one so we would get a list of all we did at that location. missions museums galleries etc.
thank you very much for your patience!

Thank you very much for your excellent program.
it asks twice for me to enable macros. is that okay?