Ok so heres my problem. I have a Workbook with a couple of sheets which are
generated by a query I run. The query takes all the data I have and lists
each department and the cost of an item they have taken from storage.

I then use a macro to sort everything by department and then sum the total
cost of items used by each department. I am making a summary sheet so that a
glace i can see the total cost of items used by each department.

All the information is on the previous sheet and is summed I just want to
take the info and put it on the summary sheet. The problem I am having is
each time I run the query( every week) the Total cost cells (for each
department) are in a different place because they use a different amounts of
items each week.

Is there a way excell can find these cells automatically and place them in
the correct place on my summary sheet ?

Please Advise
Thanks in advance
Terry