Niall,

It's difficult to visualise what you want, if you could post your data file
somewhere like

http://savefile.com/

and post the link, i'm sure a solution can be found.

"Richie" wrote:

Hello all, and thank you for reading this.

I import a file into Excel which lists all types of products with their
respective product code and quantities. The imported spreadsheet would look
something like this...

Code Product Day1 Day2 Day3 Day 4 ......
Day31 Total
001 Standard Blocks 32250 28578 33950 32475 37750
1750576
002 Cavity Blocks 16500 17243 12586 25874 11432
505462
015 Plastering Sand 72593 63406 52968 60175 59677
250355

Basically, what I need to do is when this data is imported a macro would
sort all data into its corresponding type e.g all blocks together, all sand,
all stone, all mortar, and concrete etc.
The data does not have a column that describes the product. Only what is in
the example above.
I have absolutely no experience in macros, but would be absolutely grateful
for any ideas or help.
I read most of the problems in discussion groups and think that this is the
greatest place in the world. I enjoy solving problems for people when I can
and I hope that someone can help me with this.
Many Thanks
--
Niall