Results 1 to 7 of 7

Good evening allI hope that I find everyone well. Okay I have a question and ... IT & Business Pros forum

  1. #1
    charrell's Avatar
    charrell no está en línea Stack level 2
    Join Date
    Sep 2007
    PIN/ID
    240820C4
    Posts
    36

    Excel Spreadsheet Help

    Advertisement



    Good evening allI hope that I find everyone well.

    Okay I have a question and this will be a 2 parter.

    1st off I have Grid Magic on my BB 8100 and it works fine I tried it tonight by sending myself a file then opened it,Visually very small but yeah works fine.I want to be able to to work on my spreadsheets from work as well as on the road,so that part I think I have achieved.

    I have 2 diffrent versions of the same excel file:
    1 will be cumulative that i will send out once a week and the.
    2 will be a daily that I send out that will be a Daily,I need to know how I can link the 2 so that when I add new information to the 2nd Rpt I can automatically update the 1 Report with only the new information without having to cut and past the information back and forth.

    Please let me know If I need to add anymore information....Thaks in Advance.
    "Give me Liberty but I much rather have my Blackberry 8100"







    charrell

  2. #2
    surfanimal's Avatar
    surfanimal no está en línea Stack level 3
    Join Date
    Nov 2007
    PIN/ID
    ask me!
    Posts
    291

    Re: Excel Spreadsheet Help

    I can't really make out what you're trying to say, but if I'm right about what I think you're trying to ask, then the only way to do it is to have the formulas in sheet 1 refer to sheet 2 using the vlookup function.

  3. #3
    Rcbjr's Avatar
    Rcbjr no está en línea Stack Pro
    Join Date
    May 2006
    PIN/ID
    PM - Ask
    Posts
    14,848

    Re: Excel Spreadsheet Help

    surfanimal's method will work for a while, but if you start to really build data, I think it might be easier to handle the import using VBA for Excel, in order to only get the new data. I can do it from VBA for Access, but I'm not that familiar with the excell VBA functions.

    Rcbjr.
    You Ask, We Will Answer
    Can’t Install theme via DM?No Additional Apps Found for Your Device
    Links to Usefull KB Articles

  4. #4
    charrell's Avatar
    charrell no está en línea Stack level 2
    Join Date
    Sep 2007
    PIN/ID
    240820C4
    Posts
    36

    Re: Excel Spreadsheet Help

    Hey thanks guys and yes you do understand my meaning,sorry it has been a long trying day.

    But my knowledge is limited I do not know the formula that will be needed to do this,I do however catch on very quickly so anyone that has the time to write the steps for me would be greatly appreciated.
    "Give me Liberty but I much rather have my Blackberry 8100"







    charrell

  5. #5
    charrell's Avatar
    charrell no está en línea Stack level 2
    Join Date
    Sep 2007
    PIN/ID
    240820C4
    Posts
    36

    Re: Excel Spreadsheet Help

    Good Morning.
    I'm really hoping that you all will be able to give me directions in how to link the excel spreadsheet so that I can pretty much update automatically information from one to the other....HELP!!!!!!!!!!!

    BB be Praised!
    "Give me Liberty but I much rather have my Blackberry 8100"







    charrell

  6. #6
    crackberryist's Avatar
    crackberryist no está en línea Stack level 3
    Join Date
    Dec 2007
    Posts
    261

    Re: Excel Spreadsheet Help

    Quote Originally Posted by charrell View Post
    Good evening allI hope that I find everyone well.

    Okay I have a question and this will be a 2 parter.

    1st off I have Grid Magic on my BB 8100 and it works fine I tried it tonight by sending myself a file then opened it,Visually very small but yeah works fine.I want to be able to to work on my spreadsheets from work as well as on the road,so that part I think I have achieved.

    I have 2 diffrent versions of the same excel file:
    1 will be cumulative that i will send out once a week and the.
    2 will be a daily that I send out that will be a Daily,I need to know how I can link the 2 so that when I add new information to the 2nd Rpt I can automatically update the 1 Report with only the new information without having to cut and past the information back and forth.

    Please let me know If I need to add anymore information....Thaks in Advance.
    do iunderstand you right:

    1st is the summary of the numbers entered in 2. spreadsheet?
    WHY USE DRUGS IF YOU GOT A CRACKBERRY
    UNTIL FURTHER NOTICE I'M THE ONLY "ACTIVE" STACKER IN TURKEY

  7. #7
    surfanimal's Avatar
    surfanimal no está en línea Stack level 3
    Join Date
    Nov 2007
    PIN/ID
    ask me!
    Posts
    291

    Re: Excel Spreadsheet Help

    You can use this formula -

    =vlookup('[file where 2nd worksheet is located goes here.xls]title of 2nd worksheet goes here'!$F$23

    replace the "F" and the "23" with whatever row/column you need that certain cell to refer to.

Tags for this Thread

Posting Permissions

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