I was introduced to this community as I was told it's the place to go for help on VBA.
I've got a project where after someone inputs data in columns A-H in sheet "Quotes" (Picture 1), the user would then select whether to open or close a job in Column I using a drop down I've already made. Upon selection, I'm trying to have the column move to either the "Closed Quotes" or "Open Jobs" based on the selection. When it pastes into "Closed Quotes", I'd like it to also mark Column J with the date that the selection was made (in the "Closed Quotes" sheet). For "Open Jobs", I'd the data to do the same with the date but also but delete the data from rows A-D and only paste rows E-I starting in Row C (so Row C to G [Picture 2]) rather than start in Row A, where I've struggled.
I know this is a lot but any help would be greatly appreciated.
Thank you so much