Macro to fill down for a range of cells

[tompepper]

HI,
Each day I enter data in the data columns and later I manually click fill down for the formulas. I then click Shift and Up Arrow so it leaves the filled cells (apart from the bottom row) selected, then I click Copy and Paste Special-Values.
I want to use a macro to fill down, So go to the last row of formulas, selecting the cells in the row with formulas and filling down to the last row with data, then with those cells selected, deselect the bottom row of formula cells and copy and paste values for the selected cells.. The row number changes each day and I've not been able to make it work by recording a macro.


Thanks

 

[CephasOz]

If you have access to another computer, one with a more up-to-date Microsoft/Office, you could try running it on there, but it really looks like your system is very unstable and won't ever do what you want. You could also try restarting your computer and then trying this before you do anything else, but I'm not confident of success. I'm sorry to leave you in this position, but - in the circumstances - I think we're stuck.

 

[Fluff]

@tompepper In future please do not mark a posts as the solution when it does not contain one. I have unmarked post#10