Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting Data and Formula help...
In cell E59 I have the date Monday, April 11. Underneath that in cells
E60:E64 there are teams listed. Also in cells F60:F64 there are other teams listed. Then in cell H64 the date is Monday, April 11. Then there are teams in cells H65:H70 and I65:I70. Is there a way to have the teams in cells E60:E64 and H65:H70 put into cells B89:B99 and the teams in cells F60:F64 and I65:I70 into cells C89:C99? Also if the date could be put in cells A 89:A99 also? I could just email a copy of my file if that would be easier. Thanks for the help. |
#2
|
|||
|
|||
If you do actually mean "put" as in "move" the data, just select a group of
cells (E60:E64) & use the edge of the cell selector to drag the content to where you want it to be (B89:B93). You could also copy & paste. If this is not what you are looking for, please be more specific as to what you are trying to accomplish. |:) "Jambruins" wrote: In cell E59 I have the date Monday, April 11. Underneath that in cells E60:E64 there are teams listed. Also in cells F60:F64 there are other teams listed. Then in cell H64 the date is Monday, April 11. Then there are teams in cells H65:H70 and I65:I70. Is there a way to have the teams in cells E60:E64 and H65:H70 put into cells B89:B99 and the teams in cells F60:F64 and I65:I70 into cells C89:C99? Also if the date could be put in cells A 89:A99 also? I could just email a copy of my file if that would be easier. Thanks for the help. |
#3
|
|||
|
|||
I would like a formula to do this for me. There are about 6 months worth of
more dates with teams so I was hoping for a quicker solution. I know I can cut and paste but that will take a long time. I think that is what I am going to have to do though. Thanks for the help. "CyberTaz" wrote: If you do actually mean "put" as in "move" the data, just select a group of cells (E60:E64) & use the edge of the cell selector to drag the content to where you want it to be (B89:B93). You could also copy & paste. If this is not what you are looking for, please be more specific as to what you are trying to accomplish. |:) "Jambruins" wrote: In cell E59 I have the date Monday, April 11. Underneath that in cells E60:E64 there are teams listed. Also in cells F60:F64 there are other teams listed. Then in cell H64 the date is Monday, April 11. Then there are teams in cells H65:H70 and I65:I70. Is there a way to have the teams in cells E60:E64 and H65:H70 put into cells B89:B99 and the teams in cells F60:F64 and I65:I70 into cells C89:C99? Also if the date could be put in cells A 89:A99 also? I could just email a copy of my file if that would be easier. Thanks for the help. |
#4
|
|||
|
|||
anyone else have an idea? Thanks
"Jambruins" wrote: I would like a formula to do this for me. There are about 6 months worth of more dates with teams so I was hoping for a quicker solution. I know I can cut and paste but that will take a long time. I think that is what I am going to have to do though. Thanks for the help. "CyberTaz" wrote: If you do actually mean "put" as in "move" the data, just select a group of cells (E60:E64) & use the edge of the cell selector to drag the content to where you want it to be (B89:B93). You could also copy & paste. If this is not what you are looking for, please be more specific as to what you are trying to accomplish. |:) "Jambruins" wrote: In cell E59 I have the date Monday, April 11. Underneath that in cells E60:E64 there are teams listed. Also in cells F60:F64 there are other teams listed. Then in cell H64 the date is Monday, April 11. Then there are teams in cells H65:H70 and I65:I70. Is there a way to have the teams in cells E60:E64 and H65:H70 put into cells B89:B99 and the teams in cells F60:F64 and I65:I70 into cells C89:C99? Also if the date could be put in cells A 89:A99 also? I could just email a copy of my file if that would be easier. Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |