Hello everyone, I am trying to create an excel which enables the user to retrieve the data from “NY” and “LA” worksheets per user’s criteria (Customer ID) in the “Update” worksheet and the user will be able to update the record (i.e. “Assigned” column) saved in "NY" and "LA" via the "Update" tab. I have tried to user the “Filter” function, however the function is not available in Excel 2016 and could not update the "Assigned" column via the “Update” worksheet. Can someone please help me? Thank you in advance for your assistance =)
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA / Excel Formula to extract and update the data from worksheets
- Thread starter monteee
- Start date
Similar threads
- Question
- Solved
