Copy and paste values of a table into another table

[Underkarolinawood]

I have another question regarding VBA code for Coping and Pasting Table Values into a different Table, as per attached example. I have Internal reservation Table called "InternalOrders" that is populated by Users using UserForm. I want to create a macro for my CommandButton to Copy and Paste values from "OrdersBySupplier" table into next available row of "OrderedStock" table in "OrderedStock" tab.

Any help would be much appreciated

[torachan]

where is the data for 'code #" and 'Requester' coming from ?

[Underkarolinawood]

Table "InternalOrder" is a s source data that comes from Userform that I have not included in this sample spreadsheet. Cell L1 in Reservation sheet is a selection of the supplier that then feeds into the "OrdersBySupplier". And I want to copy values from "OrdersBySupplier" table into new tab into "OrderedStock" table by using CommandButton in "Reservation" tab

[torachan]

Sorry, only had one cup of coffee this morning, my one aged brain cell is now engaged, the sheet was only partly on view from column C

[Underkarolinawood]

Sorry, only had one cup of coffee this morning, my one aged brain cell is now engaged, the sheet was only partly on view from column C

:-) I know the feeling.... My Project wakes me up in a middle of the nights as I come up with new ideas all the time lol

[sintek]

and I want to copy values from "OrdersBySupplier" table into new tab into "OrderedStock" table

Please Login or Register  to view this content.

[Underkarolinawood]

Please Login or Register  to view this content.

wow! simple as that! You're amazing.... Thank you so much... again

[torachan]

Good morning, have i read your requirement wrongly.
From your illustration on your sample sheets I was under the impression that table "OrderedStock" was to be filtered from table "InternalOrders".
The result @sintek does not appear to match the illustration on sheet "OrderedStock"
torachan

[Underkarolinawood]

Good morning, have i read your requirement wrongly.
From your illustration on your sample sheets I was under the impression that table "OrderedStock" was to be filtered from table "InternalOrders".
The result @sintek does not appear to match the illustration on sheet "OrderedStock"
torachan

no, no no, all works perfect! I am just applying your code to my project with small additions of deleting empty rows. But it works Perfectly Good for my project! You're a star!

[sintek]

My understanding...
Copy databodyrange of "OrdersBySuppliers" Table to "OrderStock" Table on OrderSheet

[torachan]

now suitably doubly confused
what is the purpose of the 'status' column in table 'InternalOrders' that clearly comes over in your illustrated table 'OrderedStock'
torachan

[Underkarolinawood]

now suitably doubly confused
what is the purpose of the 'status' column in table 'InternalOrders' that clearly comes over in your illustrated table 'OrderedStock'
torachan

So the process is that Users will order a stock by using a User Form and it will be marked as an "ordered internally" first in the "InternalOrders" table. Twice a week, Stock Management team will be placing an order with suppliers taking everyone's orders from "InternalOrders" table and these items will be listed in "OrderedStock" table. That's where i needed a code for transferring items that have been ordered with a supplier via "OrdersForSupplier" table to "OrderedStock" table. At this point each item that has been ordered with a supplier will have a status of "Ordered with a supplier" instead of "Ordered internally". Finally, once ordered items will be delivered to the warehouse, the status will be changed to "Received at Warehouse" (Warehouse will notify Stock Management Team about received items using agreed form). So it is 3-stage process: Order internally, Order with a supplier and Received at Warehouse

Does it make sense now?