+ Reply to Thread
Results 1 to 3 of 3

Share Data between to Excel Workbooks and Sheets

  1. #1
    Registered User
    Join Date
    10-25-2011
    Location
    NJ
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    2

    Cool Share Data between to Excel Workbooks and Sheets

    I was wondering if someone can tell me if the following is possible, or it it's just wishful thinking on my end

    I have two workbooks. One is a check register with multiple sheets for different accounts, and one is a payment submission form. The check register is more or less to track a series of different budgets.

    What I'm doing now is filling out the payment submission form, and essentially reentering the data into check register. I was wondering if there is a way to simplify this and some how GET certain data from the payment request into the proper sheet. The tricky part of this would by dynamically adding the entries to the check register under the correct account code. I suppose there would be some type of IF statement... saying if account number xxx123 enter the data into sheet 2, if it's account yyy123 enter data into sheet 3, etc...

    Not sure if this makes any sense or not, but any help, direction, or even if it's possible would be much appreciated.
    Last edited by joe_k; 10-26-2011 at 12:43 PM.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Share Data between to Excel Workbooks and Sheets

    probably putting if statements in diff. sheets( if meets certain criteria)
    for the workbooks sharing you can use paste links.

    a sample workbook will be much appreciated so others like me can cope up with your problem.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    10-25-2011
    Location
    NJ
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    2

    Cool Re: Share Data between to Excel Workbooks and Sheets

    Thanks for your reply. Please find the attached spreadsheets.
    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