Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Thanks a lot Leith!
I'm printing an invoice to each customer basically, and on the "report" I generated on worksheet "CO" I have the name going to cell B9. I.e. Jim, Kandy, Steve. Then I have some other data being put elsewhere on the invoice, and the only other bit that's dynamic are the telephone #'s associated with that customer. I have the cells A27:I33 allocated for those phone numbers to be printed in that range. In the example data, I have only 3 phone numbers max listed with a customer, but actually it's more like 10 - 18 per customer, so the desired output in A27:I33 would be: 777-555-5555 000-555-5555 666-555-5555 000-333-3333 555-555-5555 etc 444-555-5555 333-555-5555 222-555-5555 111-555-5555 So I guess A27:I33 would allow a max of 63 numbers in that range. I suppose the cell could be formatted to indent say 3 chars so that the #'s don't seem to run altogether.. what are you thoughts? Thank you very much, --JT |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting rows slow on large report | Excel Discussion (Misc queries) | |||
Excel Pivot Table - Sort Report Filter Values | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
can excel report scientific values rather than absolute numbers? | Excel Discussion (Misc queries) | |||
Fill an individual report with values from a team report? | Excel Programming |