fill formulae till last row

[anilpatni1234]

Hey Guys I need a help.

I need to fill formulaes till last possible row.

I am able to drag down and put the forumae but the file size becomes too large.

Is it possible to copy formulaes to all cell through VBA?

I have many formulaes to filll till the last row. So, the file size becomes too large


what do I do?

[BadlySpelledBuoy]

By "last possible row" do you mean row 1048576?
Why would you need formulas all the way down there?

Perhaps turn your data into a table so the formulas are copied down as you add new rows.

BSB

[FDibbins]

If your file slows when you drag the formulas down, doing the same thing through VBA will not change that

1. What do you mean by "last possible row" - row 1048576?
2. if so, why would you need to many rows?
3. can you show the formula/s that you are using?

haha is there an echo in here, BSB?

[BadlySpelledBuoy]

haha is there an echo in here, BSB?

I was thinking the same! Great minds and all that

BSB

[FDibbins]

I was thinking the same! Great minds and all that

BSB

or, whats that other 1 about fool seldom..."

[anilpatni1234]

I have uploaded the file.

Yes I mean row 1048476.

I use general vlookup formulaes, etc.

I am going to maintain 15 years data in it. So i want to apply formulaes in all cell .

But it makes the file too large.

Sheet "Withdraw" has formulaes in alomost every cell.

I have not filled in the formulaes till last row because it makes the file too large.

Please help me

[FDibbins]

even if you are recording data by HOUR over 15 years, you still only need 131 400 rows, not 1 million

[BadlySpelledBuoy]

In the attached I've turned your data range into a table.
Now when you add new rows the table will expand automatically and the formulas will copy down. So you won't need to have formulas copied all the way down in advance.

BSB

[BadlySpelledBuoy]

or, whats that other 1 about fool seldom..."

That's the same quote isn't it? "Great minds think alike, though fools seldom differ."

BSB

[anilpatni1234]

Hey This is a good idea.

Thank you.

Now i dont have to fill in the formulaes in advance .

Thank you so much

[FDibbins]

Nicely done BSB

[anilpatni1234]

Thank you all

[BadlySpelledBuoy]

Make sure all your formulas are copied down to the same row, select the cells down to that row, press Ctrl+T.

That's all I did and it worked for me.

BSB

[anilpatni1234]

Hey BSB a problem.

the table method works well when i need to enter data.

However sheet "In Hand" creates problem for me.

Thats because i dont input any data in it.'

It has formulaes which extracts data from sheet "entry" and "withdraw"

So ultimately i need to fill in formuae till last.

Can you help me please

[anilpatni1234]

hey BSB ,

Did you get a chance to glance through?