New problem (AutoCopying)
Hi everyone. Got promoted so have to find away to set up a Duplicate checking system for the new person taking my place. I am looking to auto copy new data into an ongoing list that will be stored in the same workbook. The data is entered onto the worksheet "List" and i need it to be copied into the worksheet "paid".
The two worksheet have the same columns and info. All i want is for the info to be updated with the new entries from the "list" sheet. The workbook will be saved as Default and then saved again using a VBA supplied by you all earlier that saveas with the day's date. Not too worried about the saveas with the date. can do that manually.
so here we go.
Starting on B8 and working towards L8 information is entered. The next invoice's info is then entered on B9 - L9 and rhinse and repeat till all invoices are entered. Upon finishing the entries I need the following things taken care of for me.
1. in column M is a vlookup command that compares the statement # that is located in column D against all statement #s in Column D on the paid sheet. I would like to change the values (they are sum commands to start with) in columns K & L to zero if the value in M is anything other than the default N/A# that is returned when vlookup doesn't find a match.
2. I need to have all the new enteries copied and pasted into the Paid sheet starting with the next available row. This info needs to be copied so that the formulas that are in columns E, F, J, K & L are pasted with the Values. ***** ROW M IS NOT TO BE COPIED TO THE PAID SHEET ******
3. Lastly I need to have the wookbook save itself.
On that note ( the saving) I need a string that will clear the cells B,C,D,E,H & I of all info at the opening of the workbook. This is so that i do not have to erase the info from the save at the end of the copying VBA code asked for above. INFO CANNOT BE ERASED AFTER COPYING AS IT NEEDS TO BE COPIED WITH A SAVEAS WITH DATE COMMAND.
sound confusing? i hope not got yelled at last time I asked for something cause of lack o' info.
here is a practice sheet. Ignore sheets 2 & 3 they are left there because the actual forms have two sheets between the "list" & "paid" sheets.