Add custom column to Pivot Table or update Source data FROM pivot table

Hello, I appoligize if this has been posted. I search but nothing

I have a pivot table on one tab that refers to data on another tab.
The pivot table is working well

The main tab is a list of inventory

Part name Quantity Re-Order

The pivot table filters out Quantity of 0 or 1 and Re-order if it has an "x"
This works great

What I want is one of two things:

A. Update the quantity on the pivot table and have it change the source data automatically

or

B. Add a column to the pivot table where I can put an "x" saying the item was re-ordered.

I added a column but when the item that X was related to is no longer on the pivot table, the "X" stays as that column isn't part of the pivot table.


Thoughts??

TIA

Jon

Originally Posted by oeldere

That is not how pivot table works.

Change the original data and refresh the pivot table.

Im ok with not using a pivot table, what other options are available?

All i want to do is have a filterd list on another tab of parts that need to be ordered. I want to update that list when a part comes in. If that part no longer meets the requirements of reorder, it will then get removed from that list.

Thanks!

Since obviously a pivot table isnt what is the best solution for me, I need a suggestion.

All Im looking for is to have a condensed list to refer to, to order parts.
I take in the inventory. I want to look at this list and edit the part when the part is arrived and have it update the source OR allow the person that does the order, able to mark the column next to the part as ordered. This will all me to use VBA to highlight the part in the source parts list.
Can this be done with a vlookup instead a pivottable?

Thanks

Attached is the shortened version of my Spreadsheet. The Re-Order tab explains as well as shows a YouTube video explaining what I tried to do to my pivot table that would have given me what I was expecting.

Thanks again for any help you can provide

I just downloaded the file I uploaded and the pivot table was there
I just have the filters hidden from the user

It sounds like a pivot table is NOT what I want to use.

Basically any other ideas that are NOT a pivot table?

There is a simple reason why I would like this option.

My original parts list is LOOOOONG
I just want a condensed list for when parts come in. I can quickly change the quantity we now have on hand instead of having to weed through the first list.

It seems like a minor inconvenience but is helpful for other people who will be using the list in the future.

I dont want MORE data to be available, I have that handled through an Autorefresh VBA script. If you ad new parts to the main list and it fits the criteria, it will auto populate the pivot table.

I want to EDIT the pivot table to affect the main table. Now with a Pivot table, I know this isnt possible. What options are available that work like a pivot table but is also editable to affect the source data?