+ Reply to Thread
Results 1 to 4 of 4

Generating Reports

  1. #1
    Registered User
    Join Date
    08-04-2008
    Location
    Birmingham
    Posts
    2

    Generating Reports

    Ok here it goes, I am in charge of the collections for a 1000 Unit apartment complex. I have all of my residents information on my own spread sheet because the account software does not do what I need it to do. But here is what I need, I need to print out delinquency notices with the information I have on my spread sheet I.E. Unit, Name, and Amount.

    Does anyone know how I can do this easly because currently I am hand writing over 500 notices a month. Any help would be great!

    I have been trying to do this for a couple of days but I am just with this one.

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Peter, Welcome to Excel Forum!

    Of course it can be done, however you need to construct a sample workbook without personal or data protected sample data in it but keep the structure the same then upload it here by using Manage Attachments at the bottom of your new post window, that way we can provide some code specifically for the way your workbook is set up. Do you have MS Word? as you may have code provided that outputs to Word.
    Not all forums are the same - seek and you shall find

  3. #3
    Registered User
    Join Date
    08-04-2008
    Location
    Birmingham
    Posts
    2
    Thanks Llyod,

    I took your advice and this is a sample from my work sheet. if anyone feels like taking the time to help me with the great I would be so greatful.

    And yes I do have word I have been trying to convert it to my notice in word and I also Have the notice in excel. Trust I really tried not to have to ask for help but i folded.
    Attached Files Attached Files

  4. #4
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    There was no note in your example so i kinda knocked one up on sheet2, if you press Alt+F11 you will see the vba project where i have added a little bit of code to fill the note in, is this what you wanted?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1