+ Reply to Thread
Results 1 to 2 of 2

Importing Formulas

  1. #1
    Registered User
    Join Date
    06-14-2019
    Location
    USA
    MS-Off Ver
    2011
    Posts
    1

    Importing Formulas

    I am importing data into excel from a 3rd party program. each time new information is entered into the program it exports data into Excel and inserts new line at the bottom of the page. I need to calculate data automatically from the cells imported. I have tried to paste a formula in the cells, but as it inserts it moves the formula to the next line down, thus it won't calculate. Is there a way to keep the formula in a column frozen so it will not move when a new row is inserted?

    or

    I can get the 3rd part program to export a formula into excel with the data. But It will have to have dynamic row numbers. Is there a way to create a formula that will detect what row it is on and thus be able to calculate different cells on the row on which it is inserted?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Importing Formulas

    This is hard to answer without concrete information about the formula you want to use and where you want to put it. Do you have this formula on each row, or one time to summarize all the data? Where is the formula? What is the formula?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Importing CSV file causes problems to formulas
    By Beach Walker in forum Excel General
    Replies: 9
    Last Post: 07-29-2014, 07:17 AM
  2. Importing CSV changes formulas
    By Beach Walker in forum Excel General
    Replies: 0
    Last Post: 07-10-2014, 12:49 AM
  3. [SOLVED] Importing formulas/code from one cell to another, to affect multiple cells.
    By AirSteward in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-07-2014, 12:43 PM
  4. Running formulas on worksheets after importing them from other workbooks
    By hugedomer11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2011, 08:11 PM
  5. Conditional Formulas to Another Sheet + Importing Lists
    By nurse.jason in forum Excel General
    Replies: 1
    Last Post: 07-12-2011, 09:50 PM
  6. Replies: 5
    Last Post: 05-05-2008, 02:22 PM
  7. Importing Usable Formulas from ODBC
    By Semolar in forum Excel General
    Replies: 2
    Last Post: 02-15-2006, 05:27 PM

Tags for this Thread

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