Autofill Macro

[pauldaddyadams]

Hi,

I have one row which contains a different formula in each column. Is there any way I can have a macro autofill the data from another table?

I would need it to:
Apply a number of formulas to a row,
Find the last row of a table
Apply the autofil based on the row with the formulas.

I have supplied a spreadsheet for reference

I hope that makes sense, let me know if any additional info is required

[romperstomper]

Is the table size just determined by the formatting?

[pauldaddyadams]

The table size on the LES tab is determind by the table on stock Tab.

On the Stock Sheet the headings will always start on row 7 and the data on row 9.

On the LES sheet the heading will allways start on row 7 and the data on row 9 also. The headings on this sheet are not the same as on the stock sheet

Let me know if you require additional info

[romperstomper]

You can use this, though it will overwrite your formatting:

Please Login or Register  to view this content.

[pauldaddyadams]

Thanks romerstomper!