Excel Sorting Question

September 14, 2010 at 04:16:36
Specs: Windows XP, 512
How can i sort my data by date. That is, if i input data in the next new row, the data sorts itself such that it places the whole data in that row at its respective position in respect to the date?

See More: Excel Sorting Question

Report •

September 14, 2010 at 05:40:14
I think we need a little more info.

I assume that you have a column of dates and that each date has data associated with it in the same row.

What you are asking for is that once you have entered all of the data for that date, the entire "table" will be sorted so that the dates are in chronological order, correct?

If that's the case, we would need to know what column the dates are in and whether it's OK to sort the entire spreadsheet or just a specific number of columns.

Finally, do you want the sort to occur as soon as the last piece of data is entered or do you want to click a button to initiate the sort?

If you want it to be automatic, you'll need to tell us which cell will trigger the sort.

Report •

September 15, 2010 at 07:04:10
Thankyou Derby D, but i have a column of dates (B) and that each date has data associated with it in the same row (five cells, A,C,D,E,and F). I have skipped three columns and have the same form of data in Column J to O, skip some more three etc.

All i need to do is:
1. Once i input data in a row(the 5 cells), it sorts itself and arranges itself by order of dates
2. Then copy the data associated with similar dates to another sheet where i have arranged the data for each day. eg. data for 18th sep 2010 all be pasted below each other as i add them in the original sheet.
3. I need it to be outomatic
4. i dont know how to set the cell that will trigger the sort or/and the copying and pasting.

Please, am new to this, kindly help me through this.
Your help will be highly appreciated.
Thanks in advance

Report •

September 15, 2010 at 10:57:07
Keep in mind that we can't see your spreadsheets from where we're sitting. You say you have "arranged the data for each day" and you want it "pasted below each other" but we don't know how you have it arranged. Before we can offer any code, you need to be specific about the layout of the sheet that the data is going to.

I'm also a little confused about your "sorting then copying" request.

Forcing a sort after the data is entered, say, for example, as soon as the data in entered into Column F, is easy. But I'm not sure what you want copied.

If the table in A:F is made up of a number of different dates, do you need each individual date (and it's data) copied to a different location or is the whole table being copied after it is sorted?

Is it all new data each time or are you adding data to a existing table and then sorting it to be in order? If it's an existing table that you are adding data to, then is it only the lastest data that needs to be copied?

Report •

Related Solutions

September 16, 2010 at 01:12:13
hi, am greatful for what you are doing to help me sir. thankyou very much in deed.

I would like to attach the file am using here so that you may help me efficiently without much misunderstanding probably because of my poor english flamings. please guide me to attach the file.

Thanks in advance DerbyDad

Report •

September 16, 2010 at 09:58:10
You can not attach files to posts in this forum.

I have sent you an email address to which you can send the file and I will try to look at it as time allows.

Please do not share the email address with anyone.

Report •

September 16, 2010 at 23:22:43
Thank you very much, i will not share it.

I have attached the file to the email address you have given me, please look at it and help me where possible.

Thanks a lot in advance, your help will be highly appreciated.

Report •

September 18, 2010 at 02:50:45
Hello,DerbyDad03, Hope you have been fine.

I would kindly like to know if you got the email and the attached file. If you did please let me know.

Please if you received, try help me where possible. I greatly appreciate all your efforts so far. Thankyou very much DerbyD

Report •

September 18, 2010 at 05:08:52
Got it.

Report •

September 19, 2010 at 08:23:48
Ok Derby. I will be waiting for your reply in my inbox. Thanks alot. The reason why i request you to reply through my email is because i need to keep that file as confidential as possible.

All the best as you try to help me. Thanks again

Report •

September 20, 2010 at 07:19:56
OK the file am using has several sheets but for this purpose i need only two; "ENTRIES" and "DIARY".

Once a cheque number is used, an entry of when, to whom and amount in the cheque is entered in the entries worksheet as you can see.
The cheque numbers are in order.
In the entries sheet data is arranged as follows:
001 19/SEP DerbyDad 20000
002 20/JAN Bryt 12800
(new entry goes here)

In the second sheet is where i keep cheques for each day/date of the month together for easy handling.
It is arranged as follows;
For DATE 01

Each date(a setting as above) can hold up to 30 records( normally it does not exceed 30) so below that i setup another date.
I have such arrangement for each date of the month from january to december.

Now, all i need to do is to automate these sheets. Once an entry has been made in the entries sheet the rest is done automatically. That is, it checks the date and positions itself in the entries sheet(sorts the entries sheet) and then it copies the entries of that date to its respective date in the diary sheet.

How do i achieve this? Please your assistance will be highly appreciated.
Thank you in advance

Report •

Ask Question