So basically this is what I'm working on but not an excel expert and it's giving me a headache, when on the "New orders" (source page) sheet, once Column "O'' is marked as confirmed I want it to copy and paste cells from column C,D,E,F,M in the row and move to the next available row on the "Confirmed Orders"(destination page) sheet to the column & cells D,E,F,G,M On the "Confirmed Orders" sheet eventually it will start to fill up and get full, id like a way to archive the data without deleting all of the formulas. When the archive box is checked it should come up with a prompt window saying "Are you sure you want to archive this job?" This job is quite urgent and id like someone to start working on it today.
Bookmarks