I am really new to writing macros and VBA coding. I really could use the help to finish my project.

I am working on an Excel file to copy rows from one worksheet to another worksheet in the same workbook. Basically, we want any rows from the source worksheet that do not have "Completed" in the status column to copy to a "SummaryOrderTracking" worksheet.
I have created the following macro to make this happen, with the exception of the pastespecial for the columns with formulas and dropdown list. I cannot get the pastespecial to work. Also, i understand I probably shouldn't use "select" in the code, which I have done.
I would like the copying to happen automatically, but still allow users to add rows and update data on the source worksheet. Is there a way to have the "SummaryOrderTracking" worksheet to be updated upon opening the workbook, along with updating when any new rows are added or data is updated in the source worksheet?


I have attached two copies of what I currently have. One file is with VBA coding to automatically update the "SummaryOrderTracking" sheet when data is changed to the source sheet. But it is glitchy and we cannot add any more rows of data. The other is with using a Macro to update the "SummaryOrderTracking" sheet. I did not create a button because there isn't any really good place to put the button on the worksheet, so I am not sure where to put it.
Any help with this project would be greatly appreciated.

Attached Files

	vending list test excel_Upload_VBA.xlsm (20.6 KB, 4 views)
	vending list test excel_Upload_Macro.xlsm (25.6 KB, 2 views)

Having same data, or data what can be calculated based on existing data, is a bad practice.

For your case, the best solution would be a report sheet (probably with some fields to enter or select report conditions), where wanted report table is calculated based on data entry table you have currently (and on conditions set at top of report sheet).

I am not sure I understand this. Is there an example of this I can review.

From your example file, it remains unclear, what you really want to do. Attached is a file with an example, how I'd set up the data entry, and how a report sheet may be designed.
But I have there no info, how the data really must be read into report. P.e. there are several rows for same article, with some of them completed, and some pending or back ordered. How to handle such records? E.g. must all records not completed, and having ListDate earlier than the row with completed status, left out? Or some other rule must applied?

Attached Files

WendingList.xlsx (40.0 KB, 5 views)

I apologize for the very delayed response. And I truly appreciate all the time and effort you put into creating an example based on our data.
We were hoping to make the view for the end user very very basic excel worksheet looking and no formulas that could be deleted. We know we can go through and lock down cells for the formulas but we thought it would be better for all involved to use VBA to build our project.
We did get further with VBA between my first post and your response with the example you created. I am attaching a copy. But there are issue with the button and as we reviewed the project with the people needing it there were more requests.
We are looking closely at what you provided and seeing how we might go in that direction instead of what we currently have.
The data in the attached is true data. There are no duplicates per dates and PO numbers.
What we are looking for is a way the end user can see all the "DailyList" worksheet, but use the "SummaryOrderTracking" worksheet to update to the "DailyList" with List date, PO number and Status.

Attached Files

vending list test excel_Upload_Macro_7_RealData3ol.xlsm (77.9 KB, 2 views)