#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Formatting a datbase

can anybody help me? i started a database in excel but need to reformat it.
all the database info spreads across three pages and i need to m ove it so
thay stack in three columns on one 8.5 by 11 page. so the company is one
line, phone the next, address the next, and so on. how do i do this.
thanks email me at
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Formatting a datbase

Stacking may just be a matter of tranposing but hard to tell from your
description.

How is your data laid out currently?

Across 3 pages could be 18 or 20 columns and down many rows.

How many columns and rows and what would be combined to get it to fit into 3
columns on one page?


Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 16:52:02 -0800, king met <king
wrote:

can anybody help me? i started a database in excel but need to reformat it.
all the database info spreads across three pages and i need to m ove it so
thay stack in three columns on one 8.5 by 11 page. so the company is one
line, phone the next, address the next, and so on. how do i do this.
thanks email me at


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Formatting a datbase

You may wish to look at MS Word's mail merge facility for producing labels,
which can use an Excel sheet as the data input. Details in Word help.

[And if you ask a question in a newsgroup, you get the answer in the
newsgroup, not by e-mail. That way, other people can see the answer in the
group archive if it is useful to them, and also the answer can be corrected
or improved by other members of the group.]
--
David Biddulph

"king met" <king wrote in message
...
can anybody help me? i started a database in excel but need to reformat
it.
all the database info spreads across three pages and i need to m ove it so
thay stack in three columns on one 8.5 by 11 page. so the company is one
line, phone the next, address the next, and so on. how do i do this.
thanks email me at



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple datbase queries in a single worksheet sfleck Excel Discussion (Misc queries) 1 October 19th 07 07:44 AM
Criteria for datbase function in one row? Thomas R. Glass Excel Worksheet Functions 3 October 25th 06 02:14 PM
What driver to use to filter a datbase (.txt) on Notepad? spenceless Excel Discussion (Misc queries) 1 August 4th 05 05:06 PM
Fantasy Football Datbase or Formula Dave Excel Discussion (Misc queries) 0 July 8th 05 09:18 PM
Datbase check gunga Excel Worksheet Functions 2 April 1st 05 08:57 AM


All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"