Hey,
Please I need help in this case; thank you in advance!
I insert data and have the data in Table1 in Sheet1:
<tbody>
</tbody>
Every time I insert new data, new data might add/cut rows to/from this table. I count the amount of rows with COUNTA -> this scenario I have 2 rows.
I have another Table2 in Sheet2, which is linked to Table1 above.
<tbody> </tbody><strike></strike>
I would like to be able to just insert the automatic SAP data to Table1, which adds rows to A and B column. I calculate the amount of rows with COUNTA.
I would like Excel to automatically insert as many rows as COUNTA cell gives to this Table2 and automatically copy the formulas to those rows -> this example those formula1 and formula2 rows would be automatically created. Currently I have to manually extend Table2 rows with formulas in order to cover all rows from Table1.
How could be this done with VBA?
Thanks!
Please I need help in this case; thank you in advance!
I insert data and have the data in Table1 in Sheet1:
A1 DATA | B1 Order | =COUNTA(A2;A1000) (result: 2) |
A2 Car 1 | B2 25 | |
A3 Car 2 | B3 45 |
<tbody>
</tbody>
Every time I insert new data, new data might add/cut rows to/from this table. I count the amount of rows with COUNTA -> this scenario I have 2 rows.
I have another Table2 in Sheet2, which is linked to Table1 above.
Car 1 | Car 2 |
=formula1 linked to table above | =formula2 linked to table above |
=formula1 linked to table above | =formula2 linked to table above |
<tbody> </tbody>
I would like to be able to just insert the automatic SAP data to Table1, which adds rows to A and B column. I calculate the amount of rows with COUNTA.
I would like Excel to automatically insert as many rows as COUNTA cell gives to this Table2 and automatically copy the formulas to those rows -> this example those formula1 and formula2 rows would be automatically created. Currently I have to manually extend Table2 rows with formulas in order to cover all rows from Table1.
How could be this done with VBA?
Thanks!