Closed Thread
Results 1 to 2 of 2

Transfering data to a different workbook automacticly

  1. #1
    Registered User
    Join Date
    04-27-2008
    Posts
    15

    Transfering data to a different workbook automacticly

    To start out with, I have a sheet in excel that I would input data in daily. (example of sheet attach)((LOG IN SHEET)

    Example LOG IN SHEET

    Name Item Name Amount
    Lisa Apples 10.
    Mike Pears 5.
    Jo pears/apples 2
    Lisa bike 5


    I have a Worksheet that is catogarized by NAME and all information is in the bottom. This Worksheet automacticly calculates the persons amount. (example of worksheet is attach.)


    What I want.
    1 To have the data from LOG IN SHEET to WORKSHEET
    2. I want ex Lisa to go to WORKSHEET D2
    Apples to go to Worksheet A4
    Amount to go to Worksheet B4
    Another example

    JO to go to WORKSHEET S20
    Pears/Apples Q33



    Names are not in special order or names are not always the same. Also the names doesn't have to be in the same area.

    Please help me transfer all the data to my Worksheet automacticly.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    Can you please not start new posts for an existing topic.

    There are suggestions in the forum rules on how to proceed if you are not getting a response to an existing post. At the very least you should have made a link to the original post.

    rylo

Closed 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