help with excel (maybe 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
|