Johnnyv015
New Member
- Joined
- Sep 8, 2014
- Messages
- 11
Hello, I am looking to create a VBA code that will work as follows:
I paste new data set to bottom of old data set and click button, VBA then selects the rows with formulas and autofills them to the new bottom of the data set.
Currently my data set is located in 1-6700 and Columns A - Q; formulas range from columns S - BE.
I am looking to find the bottom of the data table once updated data has been applied then auto fill formulas from Columns S- BE to the bottom of the new data set.
Roadblocks: Formula starting and ending row changes with every data update.
I paste new data set to bottom of old data set and click button, VBA then selects the rows with formulas and autofills them to the new bottom of the data set.
Currently my data set is located in 1-6700 and Columns A - Q; formulas range from columns S - BE.
I am looking to find the bottom of the data table once updated data has been applied then auto fill formulas from Columns S- BE to the bottom of the new data set.
Roadblocks: Formula starting and ending row changes with every data update.