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:
[TABLE="width: 134"]
<tbody>[TR]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD]Product
[/TD]
[TD]Quantity
[/TD]
[/TR]
[TR]
[TD]Wood
[/TD]
[TD]713,00
[/TD]
[/TR]
[TR]
[TD]metal
[/TD]
[TD]445,00
[/TD]
[/TR]
[TR]
[TD]Paper
[/TD]
[TD]111,00
[/TD]
[/TR]
[TR]
[TD]Coal
[/TD]
[TD]230,00
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 134"]
<tbody>[TR]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD]Product
[/TD]
[TD]Quantity
[/TD]
[/TR]
[TR]
[TD]Wood
[/TD]
[TD]713,00
[/TD]
[/TR]
[TR]
[TD]metal
[/TD]
[TD]445,00
[/TD]
[/TR]
[TR]
[TD]Paper
[/TD]
[TD]111,00
[/TD]
[/TR]
[TR]
[TD]Coal
[/TD]
[TD]230,00
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]