Hi Dear Excelforum users this is my first post, please be kind to me
This is my first time using VBA so i am a complete noob, i am making a simple complaint tracking system and there is a column where there are two choices Resolved and Unresolved
if you choose resolved it copies the row to the resolved sheet and if it's unresolved it copies the row to the unresolved sheet. i attached a template Thank you
EDIT: sorry i forgot to mention that i don't want the status column which contains the choices to be copied to the other sheets, also the unresolved sheet doesn't have a 'date closed' column because the complaint is not yet resolved so i dont want it to be copied there, i want it only in the resolved sheet. Sorry if i suck at explaining the issue i think seeing the file will help explain better
Bookmarks