Autocopy data from one cell to the next unfilled cell

Copper Contributor



I have a cell in an Excel file that is the return of a portfolio and changes over time. I would like to record that change of this value over time but for now, am forced to log on every day and copy the value at certain times of day and paste it into other workbook underneath the value for the previous day. I was wondering if there way any way to automate this process as I have found it hard up to now as the paste location changes downwards by one every day. 

1 Reply
For old hacks like me, this calls for a VBA macro. Nowadays there is something called "Automate" (on the main ribbon), which seems to be something very similar to VBA for people who don't like VBA. Have not tried it, but your job sounds right up its street.