Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Transfer data from Excel col. A to multiple columns in the same sh
A Excel 2003 spreadsheet has only one column of player data: column A. The
first three data items in column A are the same for every player: Name, Address and Phone. Every player also has at least one comment but could have any number of comments. Each players data is separated from the next by a blank cell in column A. Sometimes, a players last comment is blank resulting in two blank cells in column A before the data for the next player. I need an Excel 2003 VBA macro to: 1. Copy just the players name, but not the Name: label, to column B as shown. 2. Copy just the address, but not the Address: label, to column C 3. Copy just the phone, but not the Phone: label, to D 4. Combine all of the players comments, but not the original Comment: label, into one paragraph and paste into E2. Repeat the above process, ignoring the blank row separating the players, for all the player data in column A. A B C D D Name:John John Main St 555-1212 Plays 1st base. Plays 2nd base. Plays 3rd base. Address:Main St Jane Center St 555-1213 Catches well. Has played center field. Phone:555-1212 Comment:Plays 1st base Plays 2nd base Plays 3rd base Name:Jane Address:Center St Phone:555-1213 Comment:Catches well Has played center field |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional data transfer from multiple sheets | Excel Discussion (Misc queries) | |||
Transfer data in columns to rows | Excel Discussion (Misc queries) | |||
How do I transfer data from multiple sheets to one without pasting | Excel Worksheet Functions | |||
Transfer data from multiple worksheets | Excel Discussion (Misc queries) | |||
How do I transfer data from multiple excel sheets to powerpoint | Excel Discussion (Misc queries) |