Tables...
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Tables...

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am on the stewardship committee at my church. I want to create a table containing 3 columns. The first one would contain a parish member's current offering. The second would contain a suggested increase and the third would contain a slightly higher suggested increase. Then I could key the current offering into the spreadsheet, it would get matched to the first column of the table and I could plug in the proper amounts into the spreadsheet based on the table entries.
    The ultimate goal then is that I can generate MailMerge letters!!!!
    Is this possible????
    Thank you

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi --

    If you can handle the data input and formula to carry over the data to B and C with % increase or however you will work this out i would say yes..

    trick wil lbe to use word and get word to data sorce the table xls sheet.

    trick will be to name the columns as in give heading as you have discribed, now set template in word and filed out as needed the bits to merge.. sounds ok to me..

    only select the cloumn you requre to merge not all the SpreadSheet.. try it...
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com