+ Reply to Thread
Results 1 to 5 of 5

Need to plug data from excel columns into an equation

  1. #1
    Registered User
    Join Date
    05-03-2016
    Location
    New York
    MS-Off Ver
    2007 & 2017
    Posts
    5

    Need to plug data from excel columns into an equation

    Hi there,

    Newbie here. I have a long document with three columns of data, columns A, B, and C. Basically, I want to plug those numbers into this equation:

    animation="1" row="A" duration="B">C.jpg

    I would like to wind up with that equation over and over again in a text document, with the numbers from each row plugged in where the A, B, and C are noted. Again, sorry if this is a very basic question.

    Thanks,
    Sean

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need to plug data from excel columns into an equation

    Welcome to the board.

    A
    B
    C
    D
    1
    2
    alan barb cain animation="1" row="alan" duration="barb">cain.jpg
    3
    D2: ="animation=""1"" row=""" & A2 & """ duration=""" & B2 & """>" & C2 & ".jpg"
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    05-03-2016
    Location
    New York
    MS-Off Ver
    2007 & 2017
    Posts
    5

    Re: Need to plug data from excel columns into an equation

    Thanks shg! This is close to what I need. I got the expected result, but I'm looking for a way to automate this throughout the entire document.

    To my understanding, I'd have to then do
    ="animation=""1"" row=""" & A3 & """ duration=""" & B3 & """>" & C3 & ".jpg"

    and then

    ="animation=""1"" row=""" & A4 & """ duration=""" & B4 & """>" & C4 & ".jpg"

    in each subsequent box, manually changing the number each time. This is what I'm trying to avoid. If you know of any way to do this, let me know!

  4. #4
    Registered User
    Join Date
    05-03-2016
    Location
    New York
    MS-Off Ver
    2007 & 2017
    Posts
    5

    Re: Need to plug data from excel columns into an equation

    Ah, sorry. Didn't realize that equation would automatically adjust itself if I copy and pasted. Newbie problems, LOL! Thanks so much!

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need to plug data from excel columns into an equation

    You're welcome.

+ 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. Plug values into a single equation
    By WillFahmy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2015, 10:40 PM
  2. Excel Plug-in ?
    By Lukael in forum Excel General
    Replies: 0
    Last Post: 03-16-2014, 11:24 AM
  3. Replies: 4
    Last Post: 01-30-2014, 03:19 AM
  4. Replies: 3
    Last Post: 03-06-2011, 01:38 PM
  5. Plug Excel Values into Web
    By bconner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2010, 11:14 AM
  6. Excel Chart plug-in
    By nmss18 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2010, 04:26 AM
  7. How to plug data from 1 worksheet to another - not just linking 1 by 1
    By jamieboo8073 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2008, 01:09 PM

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