Forum Discussion
Solved
automatically updating other sheets when data entered based on certain data entered
I am able to update other sheets based on certain data, but i am looking for it to do it automatically when data is entered; right now i have to manual push the data over to other sheets based on criteria.
You could also assign a key combination like Ctrl-U to the macro. Then you don't need a button. But something need to trigger the execution of the macro.
10 Replies
- I'm sure you are clear on what you are trying to do. It's hard, though, for others to read that description and be sure we're understanding. Could you post an example, with a bit more description of the situation, what happens with those "other sheets" and what isn't happening now, requiring manual info entry.
- Thanks for the sample. I'm going to defer to some of the folks here who have experience with Power Query, which, if not a VBA routine, is what I suspect you'll need. I don't work with either of those.
