Hi All,
I'm trying to figure out if it's possible to create a macro button which would automatically copy a range of cells from one excel sheet to another one (first sheet). The problem is that each time the data is copied, it would have to be pasted in a new print area on the "master sheet" (under the last one) or check if there’s still place on the existing one and add it there. I don't want the macro to print the document, but just add some cells to the first page on a new print area or if there's still place on the existing one. However I'm not sure if this is possible as the tables length may differ. I would also like to check if you can create the same when the cells remain the same ( only users update new data and press the button again).
Example of data:
<tbody>
</tbody>
I'm trying to figure out if it's possible to create a macro button which would automatically copy a range of cells from one excel sheet to another one (first sheet). The problem is that each time the data is copied, it would have to be pasted in a new print area on the "master sheet" (under the last one) or check if there’s still place on the existing one and add it there. I don't want the macro to print the document, but just add some cells to the first page on a new print area or if there's still place on the existing one. However I'm not sure if this is possible as the tables length may differ. I would also like to check if you can create the same when the cells remain the same ( only users update new data and press the button again).
Example of data:
<tbody> </tbody> |
<tbody>
</tbody>