End of data
I have a monthly spreadsheet to which I add 100-120 data entries per day to
columns A to G. I have helper columns H to N which follow the format
=if(a1="","",formula). I have added these helper columns out to row 4000 to
ensure that there are sufficient to cater for a full month of data.
I add the data for the current day and then run a macro which sorts the data
based on helper columns that does the sort and then places the cursor in cell
G1. This works beautifully.
I then do some things using the data.
The last thing I do is run a second macro, which sorts the data back into date
order (column A), and then save the spreadsheet. I have a small problem with
this macro in that I haven't figured out how to place the cursor at the end of
data in column A. <CTRL End places it out at row 4000 which is the end of the
helper columns. The problem is that the data in column A advances by 100-120
entries each day so I can't use a fixed row position - i.e. A1000.
At the moment I am resorting to using the Page Down key but that gets tiresome
as it gets towards the end of month.
Any ideas?
--
Cheers . . . JC
|