Transferring data to a new table when a certain condition is met

Hey guys, bare with me if i dont make a whole lot of sense, im rather new to excel and havnt even touched base on codes...

Basically i have a fully functioning spreadsheet for orders and inventory... i have a table i can manually input orders in which then works with the inventory table... the problem i have is i want to make another table for orders that havnt yet arrived.. with a true/false button that i can click when the order has arrived. Which can then automatically transfer that line of data to the "completed orders" table.

Example: row 1 in "pending orders" = not complete, when completed, click the arrived button to send that line of data to row 1 of "completed orders"

Im assuming this is done through the VBA, If anyone could assist me with getting such a task complete or knows a good tutorial i can follow and/or watch to learn this that would be great, thanks in advance!

First off thanks for the fast reply! Truely appreciate it... I have created a before/after example worksheet for you.. Maybe then you will understand better what im trying to accomplish

The before sheet has the example tracking order with 50 items of each type as an example, i have created a true/false toggle button because thats all i know how to do as of now... Basically when that order has arrived i would like to be able to click a button or checkbox (not fussed) that will then automatically transfer all the values of that specific row only to go to the completed orders... which will then work with the formulas i have set for the rest of the spreadsheet
Let me know if the file attached or not (im pretty sure it worked) thanks again!

I just attached a before and after workbook in my most recent comment? Did it not work? it is showing up for me in my comment.

But i dont want the inventory to update unless it has arrived, how do i do that? Id assume with an IF statement?

I would kind of prefer to have a separate table for pending orders to easily view both at the same time though..

thanks for the reply and the code, although im not sure how to use it :/
i right clicked my sheet and clicked view code, pasted that and saved it.. whats next?

thanks!

Also marvin, if i use your method, how can i stop the unarrived orders from being totaled untill they are arrived, as that is the whole point of having 2 seperate order types.

How do i link it to the cells i wish to use it for? i have made the button and put the code in it .

im so confused sorry i have no idea what im doing :/

i just want a button that can shift the line of data to another line of data of my choice

like a seperate button for each line of data, as i will have multiple pending orders at once..

for example.. move row 3 data to row 10 when button is clicked.

I just need a button that can shift a row of data to another row of data that i specify when a button is clicked.

for example: Move row 3 data to row 10 data when button is clicked.

that works exaclty how i wanted, however, what if i already have something else in row 1, is there a way for it to remove it to the next available row or?

i dont want it to replace a current order

this is perfect, how can i recreate this on my workbook? thanks so much

If you would rather link me to a tutorial so i can learn myself that would be good too

And im happy to learn, are you able give me the type of code this is so i can google it?

If i were to re-use that code, what part of it do i change to tailor to my tables... i see it says.. table 5 and table 25, where do i get these values from? I have been googling the .... out of this aswell as asking these forums and most people just give the answer instead of explaining how to get that answer, that code to me is just a bunch of letters and i have no idea how to tailor that to my tables lol. Is this a cut/paste code? I just dont know what to even google or what this is called at all.