Hello!
I am not good with excel and its depths so I know very little.
What I want to do is to
1. Copy info
If it is written "created" in column B (Sheet OOF), I want to copy information from column C and D (Sheet OOF) to column A and B (Sheet X)
2. Delete info from column A and B (Sheet X) if in column B (Sheet OOF) is written "deleted".
I just want to automatically copy/delete information to/from sheet X based on changes in sheet OOF.
Last edited by OOFF; 11-02-2018 at 04:05 AM.
It would be easier to test a possible solution if you could attach a copy of your file instead of a screenshot.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks