Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Transfering Data from One sheet to another

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

    Default

    I am wanting to setup a worksheet which will allow me to separate corp credit card charges by cost center and dept and then transfer over to a summary sheet which shows the totals only for each cost center and dept.
    Info would be like:
    6015-004 $268.85 03/15/01
    First 4 digits represent the cost center with the last 3 being the dept number. Any suggestions? I want it in one workbook where others can just enter the information and maybe use a macro button to do all the sorting and subtotaling???? Please help. I'm in over my head!

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Why would you transfer to show totals only? Why not just use Data-Subtotals. And if that's too many steps, record a macro while you do it and place buttons on the toolbar to do the subtotals and also to clear the subtotals.
    ~Anne Troy

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Terri Mickelboro
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to show subtotals only so we can give to our accounts payable dept for entry for payment. Each total has to be entered seperately so it's charged to the correct cost center and department. Currently A/P is paging through about 7-10 pages to get the totals. Trying to make things easier. This bill can be $50k+ a month with 10-15 cards with so many receipts it would make your head spin.

  4. #4
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Probably a long shot, but check this out by Chris Davison

    http://www.mrexcel.com/board/viewtop...c=6659&forum=2

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Brian,

    that Chris Davison is useless...!

    in this post, I'd suggest Dreamboat's suggestion of data / subtotalling, adding that the info then be collapsed to just show the respective totals (click on the [1] or [2] to the left of the data

    or

    try pivot tables which can group by the rerspective cost centres, and be placed on a new sheet for presentational purposes


    :: Pharma Z - Family drugstore ::

  6. #6
    New Member
    Join Date
    Apr 2002
    Location
    Terri Mickelboro
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks for the help. i got it all figured out and it works wonderfully. used array formulas.

Some videos you may like

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
  •