Hi, I am very, very new to programming and Im trying to sort through some sales data in excel in the following format,
Column A ____ Column B
Apples _______ 250
Apples _______ 360
Apples _______ 678
Apples _______ 565
Oranges _____ 3444
Oranges _____ 4544
Oranges _____ 2000
Pears _______ 343
Pears _______ 556
Pears _______ 888
Pears _______ 670
Pears _______ 450
Pears _______ 505
Mango ______ 34
Mango ______ 23
etc.
Basically I need the code to take the data from this form, filter through it based on the type of fruit and then copy and paste it to another worksheet where the data is split into columns depending on the type of fruit, Eg
Col A. __ Col B.____ Col C. _____ Col D.____ Col E. ____Col F.___ Col G. __
Apples ___ 250 ____ Oranges ___ 3444 ____ Pears ____343 ____Mango__34
Apples ___ 360 ____ Oranges ___ 4544 ____ Pears ____556 ____Mango__23
Apples ___ 678 ____ Oranges ___ 2000 ____ Pears ____888
Apples ___ 565 _________________________ Pears ____670
______________________________________Pears ____505
etc.
In doing this I have no idea how many entries I will have for each type of fruit, or how many different types of fruit there will be in total. This is where the problem really lies as in the past the ranges I have used have always had a fixed number of data entries.
Can any one offer any advice as I'm struggling to get anywhere.
Many Thanks
Bookmarks