Search and list multiple names

Hi

i have a sheet "data entry" where multiple "item" names are entered, the range of "item" names can be millions, but in the attached sheet i have used only a few as an example.

I need a macro to take all the "item" names from the "data entry" sheet and paste them into the "purchased by month" sheet under the relevant catagories with no duplicate "item" names.

Then in the "avg per item purchased" sheet, i need the average of each of the items over only the months that have data.

The data is currently only running up to column "z", but can go as far as column "xfd"

hope i am explaining this clear enough.

The data entered in red in the sheet is the desired results.

Any help will be greatly appreciated.

Thanks

............

Bump - no reply

Hi

lekker weer by die see

hope you're well, and the kids...

As ever any help is muuuuch appreciated, my dumbass still cannot get round all the code, even with all i've learned from the experts here (my heroes )

thx dibbs.

The data i have in there is mock data, but in the actual sheet it will be receipts captured by multiple persons.

I have a lot of different buyers and currently they are cross - buying (one would buy 10 of an item, the other does not know and then buys the same), so what i'm trying to do is take the data that is already being captured and work out averages over a year for each item, then the buyers have an idea of how many of each item is needed per month and cn work together seeking out prices from their "contacts"

In the actual workbook the are many more sheets that are linked to the data enrty, so i'd prefer to not change the format, but if that is the easiest way to get this done, then i suppose it will have to be. I will then just go and udjust the links of the other sheets....

................

No problem at all, i am at your mercy .

Shortened in the sense that there are less columns and rows, also it's not nuts and bolts, i just used this for an example file so as to not give away too much info of the business, in the attached example i entered "mock data" from grocery receipts, but the items can be anything from electronics to toilet paper in the actual workbook.

The categories for each month would go to row 50 and the columns, depending on how much data is entered could go as far as column xfc

see attached.

Yup, no problem. I'll just edit the links on the other sheets to adapt to the trnsposed data.

Item is for instance "television 32" model1234" then it would be entered under the electronics category or if the item is "toothbrush" it'll fall under toiletries etc.

By the way... Thanks for all the effort so far....and for calling in the cavalry

i really do appreciate it.

Correct, there can be a million different items under a catagory

no problems, i'm just happy that someone is willing to help

GREAT!

ONLY IN "USAGE" COLUMN "B" THE TIMES THAT THE ITEM IS ENTERED FOR THAT MONTH MUST BE CALCULATED. I USED THIS

Please Login or Register  to view this content.

THIS IS AWESOME! THANK YOU VERY MUCH FOR ALL THE TIME AND EFFORT YOU PUT INTO THIS SO FAR. YOU ROCK!

ALL I NEED NOW IS ANOTHER SHEET WHERE THE AVERAGE TIMES EACH ITEM COMES UP OVER THE MONTH THERE ARE DATA ENTERED FOR I.E. IF THE ITEM "ERTJIES 250G" SHOWS A 6 IN THE USAGE SHEET IN COLUMN B WITH THE ABOVE FORMULA APPLIED UNDER FEBRUARY AND A 2 UNDER MARCH THE AVERAGE IS 4 AND SO ON FOR EACH ITEM, BUT ONLY FOR THE MONTHS THAT ACTUALLY HAVE DATA ENTERED.