split data from report into separate areas.

unfortunately i can't bring the sheet home from my workplace and I use a Mac at home which doesn't have excel so I can't mock one up

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

sorry I am not sure how I should have titled my post? as I do not know what I am asking for! I have removed the 'need advice' from the title which i now realise breaks your rules.
if this does not meet with your rules please feel free to delete my thread and I will look for help elsewhere
Thanks

As it said: Your post title should accurately and concisely describe your problem.Use terms appropriate to a Google search.

So aks yourself: IF you would try to find same problem on the Google what would you search for?
(new to excel wouldn't bring you solution, right?)

being new to excel and having no idea how to describe a problem I fail to understand how I can accurately and concisely describe the problem?
perhaps you should delete my thread.
thank you to the people who viewed and hoped to be able to help me.

I won't delete it. I would also like to suggest you title but I'm trying hard to understand your issue.
Also, without example workbook I doubt you would get desired answer. It's just to vague.

Try something like: Split data from the report into separate area's by different criteria

thank you, i will change the title to this.

ok, so i created a sort of mock up using openoffice so that you can see the sort of thing that i mean..the 1st sheet shows how the report looks. the 2nd shows the kind of layout that we need the data to filter into.

for example, all type a jumpers may be on fixture 1 so we can identify what needs to be where but i need a faster way of doing things as the report could be pages long.

hope that helps

nothing does. the fixtures are not on the sales report at all. only we know which fixtures the certain products are on so we know where they belong on sheet 2.
i guess this might be a bit of a long shot

yes, we would know the product type also.

thanks for your help anyway
I really wouldn't be able to give you an actual sample so i guess I will carry on as we are.

Thanks for trying