I have daisy-chained three spreadsheets together: Data Entry / Data Sorting / Data Crunching
In Data Entry someone enters date, time, and event information
In Data Sorting the event is assigned a number and then sorted, Descending, by date and then time.
In Data Crunching, all sorts of fun and creative things happen to the sorted data.
I'm using three sheets because I want to keep the data entry sheet unlocked for entry, and when I tried pulling it directly into the data crunching sheet and sorting I ended up shuffling all the formulas around. (If I were to hard-reference the formulas using $'s, I wouldn't be able to auto-populate the thousands of cells with click-dragging.) Sorting on one sheet and then pulling into the next for crunching has worked fine.
I have a two questions, that I'll number below.
1. I'd like to sort by one of two means:
- Every time new data is entered into 'Data Entry', have columns B through M on 'Data Sorting' sort by column B, descending. If possible, it would be great if they could then sort by Column C, but - as the numbers currently crunch - it shouldn't matter.
or
- Give the user a button they can push and sort everything, as above.
I would be enormously grateful for code for either scenario.
2. My next problem is that my 'Data Sorting' sheet for column B has the following for each cell:
All of my "" 's are getting sorted above the actual dates as a result. Is there a way to shove all the ""''s to the bottom of a Descending sort?
Thanks very much for your patience and help.
In Data Entry someone enters date, time, and event information
In Data Sorting the event is assigned a number and then sorted, Descending, by date and then time.
In Data Crunching, all sorts of fun and creative things happen to the sorted data.
I'm using three sheets because I want to keep the data entry sheet unlocked for entry, and when I tried pulling it directly into the data crunching sheet and sorting I ended up shuffling all the formulas around. (If I were to hard-reference the formulas using $'s, I wouldn't be able to auto-populate the thousands of cells with click-dragging.) Sorting on one sheet and then pulling into the next for crunching has worked fine.
I have a two questions, that I'll number below.
1. I'd like to sort by one of two means:
- Every time new data is entered into 'Data Entry', have columns B through M on 'Data Sorting' sort by column B, descending. If possible, it would be great if they could then sort by Column C, but - as the numbers currently crunch - it shouldn't matter.
or
- Give the user a button they can push and sort everything, as above.
I would be enormously grateful for code for either scenario.
2. My next problem is that my 'Data Sorting' sheet for column B has the following for each cell:
=IF(ISBLANK('Data Entry'!B2),"",'Data Entry'!B2)
This was necessary because otherwise I ended up with a long list of January 1, 1900 because of the default 0 value in the cell.
All of my "" 's are getting sorted above the actual dates as a result. Is there a way to shove all the ""''s to the bottom of a Descending sort?
Thanks very much for your patience and help.
