mhenley
05-03-2007, 10:29 AM
Hi, I'm quite new to vba and could use some help. I have to create a working spreadsheet in which our program managers can enter data into a master sheet for capturing sales order information. I have it set up so that after the information is entered into the master sheet it then inserts rows into a summary sheet, copies the data from the master, deletes blank rows, copies the master as a new sheet and renames it based on data from a cell. The master then gets cleared for the next user. Althought his works I'm sure there are easier ways to do it. My real problem is that if the newly created and renamed sheet is updated I then need it to update the summary sheet. Any help would be appreciated.
Thanks
Thanks