Hi
I've two sheets: "present" and "removed"
I would like to have a whole row copied and deleted and existing rows moved up in "present" when I type the word "yes" in column E.
The deleted rows are to be pasted into "removed", with two extra pieces of data - date removed and name of person removing it - to be asked in pop up boxes and inserted into col F and G respectively in "removed".
Spreadsheet attached
Thanks in advance
Bookmarks