Hello
I have a invoice workbook that draws the invoice number from a specific row on my data sheet with in the same workbook.through data validation it ony allows a specific named range.I have a macro button on my invoice that copies the invoice and increases the invoice number by one each time .II want to program it so when it copies the sheet it deletes the invoice number from the data sheet so the invoice can not be used more than once.Is this even possible.Any help would be appreciated.Thanks in advance