Auto Populate Formula Without Dragging

jswhip

Board Regular
Joined
Jan 19, 2005
Messages
69
Looking for a method to have formulas populate when entering data without dragging, etc.

For example, if I copy a column of data from one workbook (e.g. - a data download) into Column "A" of another workbook, I would like to have the columns next to the copied data automatically populate with the same formula (and have the same formatting). Since the number of rows will vary, it needs to be dynamic in nature.

I'm assuming this could be done with VBA, but am curious if there are other methods. I've seen this happen by accident, but I think it happened when there was a table????

I know I can set up a workbook with prepopulated formulas to check if the first column is not empty and then execute the formula (IF A1<> "", **some formula**, ""), but then I have to worry about formatting.
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Do you mean when there is data in e.g. A1 to A10 and you have a formula in B1 you want it to propagate to B10 without dragging?
Like when you hold ctl key and double click the little + at the bottom of cell B1 when it is selected?
 
Upvote 0

Forum statistics

Threads
1,223,937
Messages
6,175,510
Members
452,650
Latest member
Tinfish

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
Back
Top