|re: This is intended to be a regular process until we get proper reporting stood up;|
Then we are going to need some more detail.
We would need to know what ranges need to be copied and where they need to be copied to. For example...
Is all data from Data!A:L being copied as a block or is it dependent on each Row of Column M being 0 or 1?
If it's row by row, do you want the results in sequential rows or is it a Row X to Row X copy?
Will some of the data be copied to OnSite and some copied to Planning each time the button is pressed?
Are you overwriting existing data or appending to the bottom of existing data?
Is there any other data on the OnSite and Planning tabs that we need to be concerned with? i.e. can we clear the whole sheet before copying the new data or are there header rows, labels, etc. that need to remain?
This are the types of details that would help us provide the best soultion.