Need help sorting data
 

I've developed a spreadsheet that tracks when reports have been sent and when
they are coming in. For example...I send a letter asking a company for a
document. In one cell I enter that date. The next cell I would enter when
they sent the document back to us. The first row contains an I.D. number, so
I'd like to enter this number and since the reports come in randomly, I just
want to enter them as they come in and then have them sort themselves. They
need to sort the entire row with the I.D. number though.

Another question...is it possible to create a macro where if you clicked on
a cell it would automatically enter today's date? I'm looking for
timesavers. I would have to have the option to enter dates manually as well,
for backdating purposes.

Thanks in advance,

jeff

Need help sorting data
 

You can use ctrl-; (control semicolon to enter the date).

I like this technique from Debra Dalgleish's site:
http://contextures.com/xlSort02.html

It puts rectangles over the headers and then you can click on that rectangle to
sort your data by that column.

jbf frylock wrote:

I've developed a spreadsheet that tracks when reports have been sent and when
they are coming in. For example...I send a letter asking a company for a
document. In one cell I enter that date. The next cell I would enter when
they sent the document back to us. The first row contains an I.D. number, so
I'd like to enter this number and since the reports come in randomly, I just
want to enter them as they come in and then have them sort themselves. They
need to sort the entire row with the I.D. number though.

Another question...is it possible to create a macro where if you clicked on
a cell it would automatically enter today's date? I'm looking for
timesavers. I would have to have the option to enter dates manually as well,
for backdating purposes.

Thanks in advance,

jeff

--

Dave Peterson

Need help sorting data
 

Thanks Dave, this will be a big help.

I can't seem to get it to run correctly in a workbook I've already created.
(Worked great on a blank spreadsheet) It gives me a runtime error '1004'
then tells me "this operation requires the merged cells to be identically
sized".

"Dave Peterson" wrote:

You can use ctrl-; (control semicolon to enter the date).

I like this technique from Debra Dalgleish's site:
http://contextures.com/xlSort02.html

It puts rectangles over the headers and then you can click on that rectangle to
sort your data by that column.

jbf frylock wrote:

I've developed a spreadsheet that tracks when reports have been sent and when
they are coming in. For example...I send a letter asking a company for a
document. In one cell I enter that date. The next cell I would enter when
they sent the document back to us. The first row contains an I.D. number, so
I'd like to enter this number and since the reports come in randomly, I just
want to enter them as they come in and then have them sort themselves. They
need to sort the entire row with the I.D. number though.

Another question...is it possible to create a macro where if you clicked on
a cell it would automatically enter today's date? I'm looking for
timesavers. I would have to have the option to enter dates manually as well,
for backdating purposes.

Thanks in advance,

jeff

--

Dave Peterson

Need help sorting data
 

Sorting merged cells is a pain.

If you can unmerge the cells, you're life will become much easier.

jbf frylock wrote:

Thanks Dave, this will be a big help.

I can't seem to get it to run correctly in a workbook I've already created.
(Worked great on a blank spreadsheet) It gives me a runtime error '1004'
then tells me "this operation requires the merged cells to be identically
sized".

"Dave Peterson" wrote:

You can use ctrl-; (control semicolon to enter the date).

I like this technique from Debra Dalgleish's site:
http://contextures.com/xlSort02.html

It puts rectangles over the headers and then you can click on that rectangle to
sort your data by that column.

jbf frylock wrote:

I've developed a spreadsheet that tracks when reports have been sent and when
they are coming in. For example...I send a letter asking a company for a
document. In one cell I enter that date. The next cell I would enter when
they sent the document back to us. The first row contains an I.D. number, so
I'd like to enter this number and since the reports come in randomly, I just
want to enter them as they come in and then have them sort themselves. They
need to sort the entire row with the I.D. number though.

Another question...is it possible to create a macro where if you clicked on
a cell it would automatically enter today's date? I'm looking for
timesavers. I would have to have the option to enter dates manually as well,
for backdating purposes.

Thanks in advance,

jeff

--

Dave Peterson


--

Dave Peterson

Need help sorting data
 

I'm starting to notice that. I think I'll just start over and put that in it
to begin with. Thanks for all of your help Dave.

"Dave Peterson" wrote:

Sorting merged cells is a pain.

If you can unmerge the cells, you're life will become much easier.

jbf frylock wrote:

Thanks Dave, this will be a big help.

I can't seem to get it to run correctly in a workbook I've already created.
(Worked great on a blank spreadsheet) It gives me a runtime error '1004'
then tells me "this operation requires the merged cells to be identically
sized".

"Dave Peterson" wrote:

You can use ctrl-; (control semicolon to enter the date).

I like this technique from Debra Dalgleish's site:
http://contextures.com/xlSort02.html

It puts rectangles over the headers and then you can click on that rectangle to
sort your data by that column.

jbf frylock wrote:

I've developed a spreadsheet that tracks when reports have been sent and when
they are coming in. For example...I send a letter asking a company for a
document. In one cell I enter that date. The next cell I would enter when
they sent the document back to us. The first row contains an I.D. number, so
I'd like to enter this number and since the reports come in randomly, I just
want to enter them as they come in and then have them sort themselves. They
need to sort the entire row with the I.D. number though.

Another question...is it possible to create a macro where if you clicked on
a cell it would automatically enter today's date? I'm looking for
timesavers. I would have to have the option to enter dates manually as well,
for backdating purposes.

Thanks in advance,

jeff

--

Dave Peterson


--

Dave Peterson

Need help sorting data
 

Under Format|cells|alignment tab, there's an option to "center across selection"
in the horizontal dropdown.

(It might be useful.)



jbf frylock wrote:

I'm starting to notice that. I think I'll just start over and put that in it
to begin with. Thanks for all of your help Dave.

"Dave Peterson" wrote:

Sorting merged cells is a pain.

If you can unmerge the cells, you're life will become much easier.

jbf frylock wrote:

Thanks Dave, this will be a big help.

I can't seem to get it to run correctly in a workbook I've already created.
(Worked great on a blank spreadsheet) It gives me a runtime error '1004'
then tells me "this operation requires the merged cells to be identically
sized".

"Dave Peterson" wrote:

You can use ctrl-; (control semicolon to enter the date).

I like this technique from Debra Dalgleish's site:
http://contextures.com/xlSort02.html

It puts rectangles over the headers and then you can click on that rectangle to
sort your data by that column.

jbf frylock wrote:

I've developed a spreadsheet that tracks when reports have been sent and when
they are coming in. For example...I send a letter asking a company for a
document. In one cell I enter that date. The next cell I would enter when
they sent the document back to us. The first row contains an I.D. number, so
I'd like to enter this number and since the reports come in randomly, I just
want to enter them as they come in and then have them sort themselves. They
need to sort the entire row with the I.D. number though.

Another question...is it possible to create a macro where if you clicked on
a cell it would automatically enter today's date? I'm looking for
timesavers. I would have to have the option to enter dates manually as well,
for backdating purposes.

Thanks in advance,

jeff

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson