Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combining data into one sheet (2002 SP3)

    There is no Totals sheet in the attached workbook... <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combining data into one sheet (2002 SP3)

    On the attached workbook, you will notice three tabs. one is labeled 'Permit' and the other 'Receipt" and the final one is called 'Totals'. We enter the information onto the Permit form and that automatically populates the appropriate cells on the Receipt form with the correct amounts.

    My question is this: How do I go about setting up the Totals sheet to automatically transfer and calculate additional data for each separate account every time something is entered into the adjacent cell.

    Example of this: Row 15. Account No. 01-4417. On October 20, I issue an electrical permit. I fill in the information on the Permit form and it fills in the Receipt form. We are showing a total of $23.50 for this account on the Total form. We're good at this point. Now on October 21, I generate another permit for $50.00. I want the Totals form to calculate the total to show the addition of $23.50 and $50.00 so that it'll show a total of $73.50. Then on October 22, I generate another one for $100.00, and the new total on the Total form should be $173.50. And so on, and so on....

    Basically what I'm trying to do is get a MONTHLY total of each ACCOUNT without having to do a lot of paper turning. So at the end of the month (October 31), for every account (Ex. 01-4471), I should have a total of everything that was generated that month with each individual permit for every account. We generally issue about 300 permits a month.

    Is something like this feasible?

    Thanks.
    Pooja

  3. #3
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining data into one sheet (2002 SP3)

    Weird. I've uploaded it again and I'm getting the Totals tab... Is it fixed on your end?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combining data into one sheet (2002 SP3)

    I replied before you had edited your post. I get the totals sheet now, but see my other reply.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combining data into one sheet (2002 SP3)

    I don't see how the Receipt sheet is filled automatically when the Permit sheet is filled in. As far as I can see, the formulas on the Receipt sheet have been entered manually.
    Is there some code you haven't included that fills in the Receipt sheet? If so, it could be probably extended to fill in the Totals sheet too.

  6. #6
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining data into one sheet (2002 SP3)

    I highlighted the affected cells in this attachment. Does this help?

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combining data into one sheet (2002 SP3)

    Not really. Let's take the amount for Electrical. Cell F13 on the Permit sheet contains the total amount. The formula =Permit!F13 in cell E15 on the Building Fee Receipt sheet refers to this total. How did the formula in E15 get there?

  8. #8
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining data into one sheet (2002 SP3)

    I understand the question now. Yes, you are correct. The formulas were indeed entered manually. If you have a suggestion for doing this another way, I'll all ears (you always have great ideas).

    Currently it's a very basic program since we have a very small city and don't issue a lot of permits. I created that form and the receipt form to automate something they were doing by hand but I only had a day to do it so it's a very 'rushed' job. Right now when our permit techs have to issue the permit, they go into the Permit form and simply input the Quantity of what they're doing. The formulas are built into the Amount column. It automatically calculates the amounts and COPIES the info to the Receipt form so the resident has a printout to take to the cashier.

    If you need me to re-work something in order to further automate this process, I'm more than willing...

    Thanks.
    Pooja

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combining data into one sheet (2002 SP3)

    I still don't understand how you use this workbook.
    If you generate another permit, do you insert a new worksheet (or copy an existing permit sheet)?
    And do you also insert a new receipt sheet (or copy an existing one) at the same time?

  10. #10
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining data into one sheet (2002 SP3)

    We use the form simply to print a new one EACH TIME. Then we go back and re-input information from the paper copies. So basically the permit techs each have a copy of this workbook saved locally. They open it up, print out the permit and receipt, give the receipt to the customer, wait while the customer pays the cashier, then give them a copy of the building permit and receipt and keep a copy for themselves. They then close the workbook WITHOUT saving the changes and when the next customer comes, they open up the same file and start the above process again. They accumulate the day's permits/receipts into a file folder and at the end of the day, give the entire file full of paperwork is given to someone to tabulate the various totals...

    Does that help?
    Pooja

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combining data into one sheet (2002 SP3)

    I'm sorry, I give up. How can you expect to populate a total automatically this way?

  12. #12
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining data into one sheet (2002 SP3)

    Is this what you are looking for?
    Legare Coleman

  13. #13
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining data into one sheet (2002 SP3)

    Exactly my point! [img]/forums/images/smilies/smile.gif[/img] I was hoping a genius in this forum could offer some guidance. What we would like to do is have the information inputted into the permit form, have the receipt generated and have the amounts copied over to a separate sheet or even a separate workbook all together and then clear out the permit/receipt form after printing so that it's ready for the next time.

    I was just wondering if that's feasible....

    Thanks for trying!
    Pooja

  14. #14
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining data into one sheet (2002 SP3)

    Sorry Legare, I can't see what you've done differently.... [img]/forums/images/smilies/smile.gif[/img]

    Thank you for trying!
    Pooja

  15. #15
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining data into one sheet (2002 SP3)

    Does this do what you want?

Page 1 of 2 12 LastLast

Posting Permissions

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