I am looking to automate a few steps in our billing sheet - ideally with the click of 1 button, but I am ok if it needs a few clicks. Copy formula down based on number in cell (this number is calculated using a COUNTA) Update pivot table to get list of 'who worked' on the project that month (currently done by manually refreshing) - Page 3 of the Workbook in the image Copy those names into the rate sheet rate worksheet (this is done manually), which automatically applies their roles (I have already written this XLOOKUP and it works fine) Page 4 of the Workbook in the image

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

[VBA] Copy formulas down based on number in single cell

I am looking to automate a few steps in our billing sheet - ideally with the click of 1 button, but I am ok if it needs a few clicks.

Copy formula down based on number in cell (this number is calculated using a COUNTA)
Update pivot table to get list of 'who worked' on the project that month (currently done by manually refreshing) - Page 3 of the Workbook in the image
Copy those names into the rate sheet rate worksheet (this is done manually), which automatically applies their roles (I have already written this XLOOKUP and it works fine) Page 4 of the Workbook in the image