Copy one worksheet to another using value and pastespecial
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.
|