hello all
I'm working with a reporting tool that creates a dynamic range when it writes data to excel. This tool does not allow to use formulas in the excel columns, and every time the query is refreshed the formulas are gone. Is there a way I can copy the reporting dynamic range and add 2 more columns in the new range?
Example:
Reporting range = REPTOOL from cells A1 to Z100 (this range changes every time when query is refreshed)
I need a new range = REPTOOL + columns AA, AB. This means my NEWRANGE will be from cell A1 to AB100
I appreciate your help
Mario
I'm working with a reporting tool that creates a dynamic range when it writes data to excel. This tool does not allow to use formulas in the excel columns, and every time the query is refreshed the formulas are gone. Is there a way I can copy the reporting dynamic range and add 2 more columns in the new range?
Example:
Reporting range = REPTOOL from cells A1 to Z100 (this range changes every time when query is refreshed)
I need a new range = REPTOOL + columns AA, AB. This means my NEWRANGE will be from cell A1 to AB100
I appreciate your help
Mario