View Single Post
  #1   Report Post  
laskuh
 
Posts: n/a
Default 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