Any help would be greatly appreciated!
I have an Excel report that I wish to automate. There are two worksheets, a report worksheets and data worksheets. The data worksheet pull data via a web query. The report worksheet presents that data in a nice format, along with other details.
I was simply referencing a table of data from the data worksheet. The data is always in the same format (same number of columns wide and number of rows deep). This would work except for the fact that sometimes the table of data starts one or two rows lower or higher. This data is updated every 10 minutes.
How can I automate copying and pasting this data from the report worksheet even though the data may vary in row numbers where it begins. The headers are always the same. Plus, I would like it to refresh every 10 minutes or so.
Thank you!
~ Chris ~
I have an Excel report that I wish to automate. There are two worksheets, a report worksheets and data worksheets. The data worksheet pull data via a web query. The report worksheet presents that data in a nice format, along with other details.
I was simply referencing a table of data from the data worksheet. The data is always in the same format (same number of columns wide and number of rows deep). This would work except for the fact that sometimes the table of data starts one or two rows lower or higher. This data is updated every 10 minutes.
How can I automate copying and pasting this data from the report worksheet even though the data may vary in row numbers where it begins. The headers are always the same. Plus, I would like it to refresh every 10 minutes or so.
Thank you!
~ Chris ~