LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Formating excel multiple paragraphs and colums using one source of data

Scenario:
Sheet#1:
column #1 product names separated by category names.
column#2 prices corresponding to products.

Final sheet is basically all product pricing.

To print this out i need to create lay out on sheet # 2
This sheet would have three vertical frames.
this frames would have two columns(one for product names one for
pricis)
Sheet #1 would project the content to sheet #2 in such way that if
sheet #1 content changes all the content would get formated in number
#2 sheet accordingly .(This content will have multiple pages within a
sheet.

How can I achieve that?.

 
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
source data from multiple sheets JNW Charts and Charting in Excel 3 June 24th 07 02:41 PM
Office 2007-Source formating lost when emailing from excel csi.sec Excel Discussion (Misc queries) 4 February 6th 07 07:24 AM
Office 2007-Source formating lost when emailing from excel csi.sec Excel Discussion (Misc queries) 0 February 5th 07 04:47 AM
Same Data source for Multiple Pivots anandmr65 Excel Discussion (Misc queries) 3 July 7th 06 12:47 PM
How can I enter multiple paragraphs in a single Excel cell? dclink9 Excel Discussion (Misc queries) 2 June 9th 06 10:34 PM


All times are GMT +1. The time now is 02:18 PM.

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

About Us

"It's about Microsoft Excel"