The CRM application that we use provides output in an excel sheet "Table View 1". I want to be able to copy the data that is dumped to a sheet to another sheet. The requirements:
- The data output range is different. Sometimes it is 4 rows and sometimes it is 25 rows. I want a mechanism where based on the output, the formula/macro automatically copies the information to the new sheet.
- The first 2 rows need to be excluded when the copy is being made.
I am not sure if this can be accomplished using a macro or a formula, but any help will be appreciated.
I am attaching a sample of the application output with this thread.
Bookmarks