+ Reply to Thread
Results 1 to 3 of 3

a Function for transfering and collecting data?

  1. #1
    Registered User
    Join Date
    01-12-2011
    Location
    Oregon, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    a Function for transfering and collecting data?

    Hi all, I need a function that would take the value of a cell, put it into another cell that is the starting point of a Excel calculation and take the result of that calculation (from another cell) to the cell where the function was called.

    IE. Sheet "1st", A1 has a value of "2000", this is taken from Sheet "1st" B1and inserted in Sheet "Lcalculator" A1, which is the starting point of the excel calculation, then the result is given in Cell Sheet "LCalculator" B1, lets say "300" I need this return value to be shown at "Sheet "1st" B1 which is where I am calling the Function originally.

    Thx

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: a Function for transfering and collecting data?

    I suggest you post a sample workbook.

  3. #3
    Registered User
    Join Date
    01-12-2011
    Location
    Oregon, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: a Function for transfering and collecting data?

    Here is a copy of part of the file I am working with...
    As you will see there is a lot of calculations involved, but the real starting point is at "Lcalculator: E94" for external data and the output number is at D149. now, this is just for one store and one day, we have 15 stores and it will used for the whole month. so that is 15*31 calculations and all need to be keep up to show the record.

    http://www.mediafire.com/?rdv8b541ffa03ch

    thx for helping

+ 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