Search : in
By :

Excel Macro Code Required

sanjiv_y2k, on Apr 23, 2009 11:03:35 pm BST 
 Report this message to moderators

Hello,

i am looking for a excel macro code to cut the numeric values given below a person name from a column and paste in parallel columns. example as given below.

Raw Table
A1
Tom
1234
1235
Jack
100
200
300
Jim
234
21

Desired Output Required in below mentioned format:

A B C D
Tom 1234 1235
Jack 100 200 300

Please help me to solve this query.

Thanks
San

Configuration: Windows XP
MS-Office 2003

Best answers for « Excel Macro Code Required » in :
Excel – Macro to detect and hide blank rows ShowExcel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Ask your question Reply
Ask your question Reply
They need your help