Auto add formulas to new rows

G1032

New Member
Joined
Feb 1, 2019
Messages
15
Hi
I have a sheet that imports data from a website.
New data each day added to top row of sheet 1
Sheet 2 is used for calculations from the data on sheet 1.
I have sheet 2 formulas copied down to row 5000.
When I refresh the workbook and import new data each day sheet 2 gets auto populated with new data also. However the cells containing formulas at the bottom rows of sheet 2 don't auto update.

The question - How to I get the formulas to auto fill correctly down all rows of sheet do after new data is added to it? I have a macro set to do this but I'm looking for an automatic solution.

I thought putting the data in a table format would work but it didn't
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
66,513
Office Version
  1. 365
Platform
  1. Windows
BOOM! Thanks. That works now. You're a gent.
One last question on this if you have time? Is it possible to call that macro after background query has run as opposed to after a certain a time delay? I only ask because in the event of a slow internet connection or slow processing power the macro will run before the query has run?
I don't know. I have never tried anything like that.
That would be a topic for a new question.
 
Upvote 0

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,186,378
Messages
5,957,515
Members
438,309
Latest member
tmacbees

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top