Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need help with ms excel (possib macros)
you guys are the most technical people i know, so i thought i would bring this to you. his is my problem: i have data in an excel sheet. its in a matrix and reads from left to right and top to bottom, as if you were reading a book (A1, B1... A2, B2... etc). A B C D E 1 . . . . . 2 . . . . . 3 . . . . . i need to somehow transfer this to another part of the sheet in excel and have all my data in one column: A1 B1 C1 D1 E1 A2 i know i can do this by just making a certain cell equal to another cell, etc, but i have 4 new data files a day and thousands of data points per file. so, i need some sort of formula or a macro that can do this, but im not quite sure how to get this done. can anyone help? or refer me to someone that might be able to? i hope this makes sense. -- laskuh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
help with excel (maybe macros) | Excel Worksheet Functions | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
how can i edit excel 4 macros in Excel 2003 | Excel Worksheet Functions | |||
Is there a way to sort by color in excel? using macros? | Excel Worksheet Functions |