Ok...no answer to my last post so I will try again.....

I have a data page (10 of them in fact identical except the tab names),
each of these has Column A as a description, Column B as subtotals of
each division and columns C through to Z as the date.

I then have the unenviable task of trying to collate the data from
dropdown boxes that the user selects the item number from, tabs to
column C and types in the number purchased. Column B subtotals along
the way.

How oh HOW can I do this three dimensional task as all 10 sheets need
to be collated into ONE report???????

Please anybody got any ideas?? I've tryed VLOOKUP, HLOOKUP, MATCH but
they will only look at one single line...and the item may have been
used between two dates......and they both need to be individual as at
the month end, the report uses dates to and from to calculate the
usage.....

Gosh I'm even confusing myself now!!!

Thanks
Sandi


--
rhani111
------------------------------------------------------------------------
rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940
View this thread: http://www.excelforum.com/showthread...hreadid=564594