Macro

[Rahul S]

I need an excel macro which can re-form my data in rows.
For example, I have 1000 rows of data, Every 3 or 4 or 5 lines is a record. Every record starts with "ABC". So ideally i want each record to be in a single row. As each record starts with "ABC", using "ABC" as a medium, can we get the desired result?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Encryption On Mobile Devices in C# / .NET
http://www.eggheadcafe.com/tutorial...0-da5581fdf86b/encryption-on-mobile-devi.aspx

 

[Simon Lloyd]

When you say every 3, 4, 5 lines.......ABC...etc do you mean that th
record starts with ABCxxxx and then next 3, 4, 5 lines are the rest o
the data associated with that record name

I need an excel macro which can re-form my data in rows
For example, I have 1000 rows of data, Every 3 or 4 or 5 lines is
record. Every record starts with "ABC". So ideally i want each record t
be in a single row. As each record starts with "ABC", using "ABC" as
medium, can we get the desired result


Submitted via EggHeadCafe - Software Developer Portal of Choic
Encryption On Mobile Devices in C# / .NE
'.NET Compact Framework Encryption And File Transmittal With Mobil
Devices By Robbe Morris' (http://tinyurl.com/yd5rosw

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Herbert Seidenberg]

Excel 2007 Tables
Consolidate and transpose.
Just formulas.
http://www.mediafire.com/file/wygjmtwmxmj/07_28_09.xlsx