Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formulas
NEED HELP...I have a formula set up to where it pulls data from a linked
sheet, I want to be able to click on the right bottom corner of where I have the formula and drag it to populate accordingly to other rows...this works but instead of pulling the information vertically which is what I need it is pulling the info horizontaly from my linked sheet...how can I change the orientation of where it pulls the info...i am dragging horizontal but want the info from the other sheet to propogate using the vertical info order....hope I made sense...anyone that can help me?...I would really appreciatte it....I am working on deadline with this and can't figure it out. THX ALLOT! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formulas
Use the transpose function. highlight verticle range where you want the
results top to bottom with the same number of rows as the source data has columns, so that the top cell is the selected cell. type formula =transpose($a$1:$z$1) in that first selected cell (meanwhile your range is still selected), since this is an array, you need to use ctrl shift enter instead of just enter hth, Dave "Les" wrote: NEED HELP...I have a formula set up to where it pulls data from a linked sheet, I want to be able to click on the right bottom corner of where I have the formula and drag it to populate accordingly to other rows...this works but instead of pulling the information vertically which is what I need it is pulling the info horizontaly from my linked sheet...how can I change the orientation of where it pulls the info...i am dragging horizontal but want the info from the other sheet to propogate using the vertical info order....hope I made sense...anyone that can help me?...I would really appreciatte it....I am working on deadline with this and can't figure it out. THX ALLOT! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions |