Hello,
we have the situation described below:
Sheet 1 (input table):
Sheet 2 (output table):
Is it possible by creating a macro?
Regards,
Antonio
we have the situation described below:
Sheet 1 (input table):
- Two tables, the first starts from A1, the second starts from E1
- In both of those tables the number of rows is variable
Sheet 2 (output table):
- One table that start from A1
- We would like to copy in this output table the cells highlighted in yellow of the two tables in the Sheet 1
- The copy in the output table have to start from the first empty cell
- When the Item is empty, the script must skip that row
Is it possible by creating a macro?
Regards,
Antonio