I ahve posted previously and as I'am gaining a clearer picture of what I need
to do I thought I should repost here with better explanation.

Given that my excel skills are limited at present, I have a task for work
that I hope you can help with.


I want to be able to search for a store name that "may" appear in a cloumn
in a seperate excel file and with tha store name grab the data that is
associated with it for another column and then place this data in a new
worksheet and repeat the process so that each grab / extract and dump, places
the new data next to the first extract. BUt with every sucessive dunp I only
want the data that is in the 2nd comun that relates to the 1st column store.
I will explain the layout in more detail below:- But is there a macro or some
tool that I can run that will do this?


A series of saved excel files that are based on weeks - Monday to Sunday.
The sheets are arranged with 1st column being a store with various stores
running down in rows (not each week shows the same stores however there are
many times where the same store is shown in seperate workbooks). The days of
the week are also aranged in columns- Mon, Tue Wed, Thur, etc.

The cells below each day for the store shows total sales .

So the workbook for the week will show the total sales per store per day.

E.g Store A(columnA) and Monday Week 1 (Clomumn B),Monday Week 2 (Clomumn
C),Monday Week 3 (Clomumn D)etc

Then Store A Tuesday Week1, (Clomumn B),Tuesday Week 2 (Clomumn C),Tuesday
Week 3 (Clomumn D)etc

Etc Etc...


Now I have multiple weeks and want to see what TRENDS store (A) does on
Mondays ONLY and then Tuesday ONLY etc over the many weeks in order to see if
one day is better than another for that store and then repeat for each store
(A) to (L)

Then do for each store and then clusters of stores which make up regions.

Is this possible easily?

Thanks

Michael
Was this post