It is a very super simple macro (button) I need.
I have an Excel file with let's say 60 columns.
Column 20 to 39 are regularly updated through an EXCEL add-on.
Let's say day 1 I have 60 columns and 500 lines.
After update, column 1 to 19 and 40 to 60 are STILL 500 lines but column 20 to 39 is now 750 lines.
So I manually select columns 1 to 19 and then 40 to 60 and I pull them down so that the formulas inside columns 1 to 19 and 40 to 60 can reach line 750.
I need a macro to do that automatically.
It is not that difficult I know.
11 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi, Nice and easy one, I can do this for you ASAP :) I'm Chris from Sheffield in the UK and have over 10 years experience doing things like this. If you want to discuss further let me know Cheers Chris