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 cri...
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.
I am using SharePoint to update excel sheet 1 with info, and based on that info updated, i want to copy the line based on the code to the corresponding sheet. So anything with "code 1" from sheet 1 will populate a row in sheet "01-Site Survey-Layout-Test-Demo".; attached
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.