View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default Reorganizing rows into groups

The easiers way would be to load the data into MS Access and create a report.
As a report you can just drag the fields wherever you want them adn gropu
them as necessary
--
HTH...

Jim Thomlinson


"loopkid1" wrote:


I've got a basic contact list in the following format:

| A | B | C | D | E | F
| G |
| LNAME | FNAME | ADDRESS | CITY | STATE | ZIP | PHONE |


and so on. Is there any way to pull the data from the rows and insert
it into a pre-formatted layout for each row? For example:

| A | B | C | D |
| *LName, FName* | | | *LName, FName* |
| *Address* | | | *Address* |
| *City, State Zip* | | | *City, State Zip* |
| *Phone* | | | *Phone* |

Basically, I want to convert it into a pdf file and have it easily
readable. If there's a better way to reach that end, I'm definately up
for learning it! Thanks!

Dave Cameron


--
loopkid1
------------------------------------------------------------------------
loopkid1's Profile: http://www.excelforum.com/member.php...o&userid=21729
View this thread: http://www.excelforum.com/showthread...hreadid=395462