[Excel 2010] Extend rows based on the number of rows in another sheet

Good day to everyone,

I'm a beginner in VBA and even after looking into it, I don't find any solution allowing me to calculate the number of full rows in one data base located on one sheet X to determine how many rows the macro needs to extend on sheet B (sheet B is made only of formulas for data interpretation in sheet A.

I know this should be fairly simple for you guys but I don't know how to compile this.

Any help would be greatly appreciated, please let me know if any further details are needed.

Thank you.

calculate the number of full rows

By that, you mean who many rows in a column are used? equal to counting non-blank cells in a column. Or what is the number of rows between first row and last row used in a column. Or a row in which all the columns are filled?

Good day haripopuri,

Thank you for helping me to clarify my request.

Sheet A is made of a database, which will be updated 2 to 3 times a week, sheet B is made of formulas who will rework the datas provided in sheet A.

So I would like the macro when I click it to count the number of rows that are filled in column A in sheet A and extend the formulas included in all columns in row 1 on sheet B.

Is that clear enough or should I rephrase it ?

Thank you for your kind attention.

Good day Richard,

As the database located on Sheet A is updated 2 to 3 times a week, I will integrate a delete all formulas except row 1 and 2 before proceeding to extension (Row 1 being the titles of the column, Row 2 being the formulas that needs to be extended to the number of rows included in Sheet A).

Any chance you know how to set up the macro to count the fulfilled rows based on column A on Sheet A and extend the rows on sheet B to the variable number found in Sheet A ?

Thank you for your greatly appreciated help.

Sure. Possible to upload a sample? Can I take column A as the base to count fulfilled rows?

Good day haripopuri,

Please see below:

Please Login or Register  to view this content.

Thank you for your great help !

Pls, can you upload in Excelforum. You may delete unwanted data to reduce the size.

Noted.

I did not see there was an option.

Please see attachment.

Thank you again !

vbomars, thanks for honouring all the questions.
Below code get the number of rows filled in column A from A2 (since A1 is heading) and repeat that many times to put your formula in to the cells.

Please Login or Register  to view this content.

I have hard coded sheet names. Didn't write to delete existing formulas pertains to previous run. Means, if you have formulas from last run over 30 rows, current data has only 20 rows, this macro wouldn't delete those extra 10 rows.

haripopuri,

Thank you for your great reply.

The document provided was an example and in the real View on DB, I have too many formulas to input to put it in the macro I believe, it's way too complex and would be really long.

Is there a command that would allow me to just take all formulas from row 2 and copy it down to the last row depending on the number found in DATABASE ?

Thank you very much for your replies !

Awesome !

Thank you very much haripopuri !

Glad I could help! update the thread as SOLVED. You may wish to add to my reputation.