TEACH VORCHA SPREADSHEET!

REVENGE IS A DISH BEST SERVED GOLD, HIGH LEVEL NERD!

ELCOR WOULD HAVE HELPED. YOU ARE BAD.

Well Mr Vorcha your first problem is that you have not explained your problem.

What are you trying to accomplish? You have your master list of things you order often. Do you want these new items added to your master list? Do you want these 'non master list' by themselves?

This is not Captain Gavorn and no i am not playing trickssssss

GRRAAAAGH! BLOODLUST ENGAGED! YOUNG VORCHA APPRENTICE, YOU DO IT ALL WRONG! GET SUIT RAT TO DO SPREAD SHEET FOR YOU!! GRAAAGH! YOU FORCE THEM BY THREATENING TO SNEEZE ON SUIT RAT BABIES SO PARENT SUIT RATS COMPLY!

OR DON’T DO SPREAD SHEET AT ALL IN FIRST PLACE! SOLVES EVERYTHING!!! YOU STILL HAVE MUCH TO LEARN AND BURN!

Yeah yeah that's cool and all...

But, Will it blend? That's the question!

Badassfully: Use Python and program your own shit.

My suggestion for you is this (if I have figured out what you want correctly). It may be a bit of work though.
1 - Make master list with everything you want and fill out all the things you have. I would use seperate cells for the same item but different version in the notes.
2 - use the "=" (dont include the "'s) and click on the cell you want to use the data for. This can be done on a different part of the first tab, or you can make a new tab and rename the tab to suit its purpose.
3 - this can be copied across adjacent cells by click & dragging the black square to wherever necessary.
4 - when updating, you just need to fill in the master list and adjust the other sections by the method in #3.

If you want to work out how much you have left or need to order from the qty section you can use a calculation formula to work it out automatically.

I'm not entirely sure what the process is here, but I'm going make these two assumptions.

Master List contains : ITEM NAME, ITEM DESCRIPTION, ITEM NOTES
Order List(s) contain : ITEM REFERENCED FROM Master list, QUANTITY

I'd fill in my base data on the MASTER sheet, then on each subsequent ORDER sheet I'd use a Data Validation list.

I would insert a table object for the items and quantities and put the data validation in the first cell ($A$1). The data validation would pull from all of the cells on the Master sheet (=Master!$A$2:$A$49).

Initial setup would be a pain, because if there are 48 things on the master sheet, I'd have to step through 48 lines on the new Order sheet, and pick them out of the dropdown... but once I had a baseline Order sheet, I could just copy that one over and over again, only changing lines that I needed to change.

If I need to add something NEW to any list, I'd put it at the very bottom of the master table. From there, I'd swap back to my Order sheet and in the first cell edit the data validation field, adding 1 to the list : =Master!$A$2:$A$50 making sure to check the little box on the data validation window that says "[x] Apply these changes to all other cells with the same settings." Excel will then update all of the cells in the table on my new order list and it will include the item that had just been added to the bottom of the master table.

If you're summing quantities across sheets into the Master list... I'm not sure how I'd do that... I'm working under the assumption that each order sheet has quantities, but you're not tracking quantities on the master. That would require... some extra work that I'd have to put more thought into, but right now I need to go run off and fight with a BIG MACHINE!

Master List unknown in Asari Library. Pls inquire again.

Did you mean Mistress List

Two bosh'tets in sight!

GAAAAH! MY FRIEND SAL WILL ANSWER THIS.