Insert rows with formulas based on a cell value

Heguli

New Member
Joined
Nov 8, 2019
Messages
1
Hey,

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 1B2 25
A3 Car 2B3 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 1Car 2
=formula1
linked to table above
=formula2 linked to table above
=formula1
linked to table above
=formula2
linked to table 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!
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Forum statistics

Threads
1,089,642
Messages
5,409,492
Members
403,266
Latest member
HMR120

This Week's Hot Topics

Top