LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel VBA - Inserting associated values in a report Please Help :)

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
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
Inserting rows slow on large report Robbro Excel Discussion (Misc queries) 6 March 9th 10 10:03 PM
Excel Pivot Table - Sort Report Filter Values Jeff Reese Excel Discussion (Misc queries) 3 September 13th 09 12:30 AM
Automate Excel report to place certain data into existing report? Craig Harrison Excel Worksheet Functions 3 July 25th 06 01:54 PM
can excel report scientific values rather than absolute numbers? JamesB Excel Discussion (Misc queries) 2 October 13th 05 03:00 PM
Fill an individual report with values from a team report? alymcmorland[_4_] Excel Programming 2 October 13th 05 09:39 AM


All times are GMT +1. The time now is 12:28 AM.

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"