Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
hello,
I am having a problem with sorting the following: cells in column A have military time in them and to the right of A, col B thru G are merged so that somes lengthy notes can be typed into the cell. Now, the times in the A cells will corrrespond to the notes on the right. ex: A1 B1thruG1 1500 employee smith reported to work late, his assignment is xyz.... 1600 employee jones reported to work late, his assignment is xyz.... 1400 employee green reported to work late, his assignment is xyz.... notice that sometimes notes will be entered out of chronological order and so therefore at the end of a work night the data entry person will sort the time column. When the time is ajusted in ascending order the notes should follow. PROBLEM: When I select the A column to sort is asks me if I want to expand the sorting to the data immediatley to the right (B thru G) of course I select that I do want to expand the sorting. BUT THEN a message pops up stating that the in order to do this the merged cells must be identically sized. I have to have the A cells designated for the times and the notes cells separated from the times and merged from B thru G. This is so that the data is entered nice and unifrom time on the left and the notes starting at the same point right on down the column. I tried merging A thru G and just entering the time and then some spaces to start the notes section, but this looked messy and plus too hard for the people i work with to remember to put a uniform amount of spaces between all the times and notes. HOW can I keep it the way that I have it now and sort despite A cells not being merged with the notes data in B thru G? Thank You Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
basic pie chart question | Charts and Charting in Excel | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
Data Table Question | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel | |||
Importing Question! | Excel Discussion (Misc queries) |