Hi,
I will be manually updating the status of each job and I am looking for a formula that will move the entire row for each accepted job onto a new sheet automatically. There is a sample workbook attached.
Let me know if you need any more clarity. Hopefully someone can help out!
Thanks!
Your profile says 2015... I am assuming that that means you are using Excel 365 (please amend if so...).
You can use:
=FILTER(Sample!A2:H15,Sample!E2:E15="Accepted")&""
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you Glenn, I have updated my profile. The formula you provided does not update Sheet1 any time I change the status of a job from Pending or Rejected to "Accepted" in the Sample Sheet. Do you know of any formulas that will keep the flow automated?
Yes it does!! Have you got calculation options set to manual, perhaps??
Got it figured out thank you so much!!
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks