Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
laskuh,
This macro will take the data in the range A1:C9 and load it into column E while ignoring any blank cells in the original range: Sub RangeToColumn() Dim Rng1 As Range Dim Rng2 As Range Set Rng2 = Range("E1") For Each Rng1 In Range("A1:C9") If IsEmpty(Rng1.Value) = True Then GoTo Branch: Rng2.Value = Rng1.Value Set Rng2 = Rng2.Offset(1, 0) Branch: Next End Sub ---- Regards, John Mansfield http://www.pdbook.com "laskuh" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
quattro pro converter Excel 2003 | New Users to Excel | |||
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 |