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.
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.