+ Reply to Thread
Results 1 to 6 of 6

Convert data from formula to text then jump to next row

  1. #1
    Registered User
    Join Date
    01-15-2014
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Convert data from formula to text then jump to next row

    I am new here and pretty much new to Excel, so any help is appreciated.
    I have a workbook with two sheets: Sheet 2 (CustomerVehicleInfo) contains a client database. Sheet 1 is kind of a virtual work order where the mechanic enters the name of a client (in A1) and all his info pops up in cells B4-F4, according to Sheet 2.

    I used a simple VLOOKUP for that:
    =IF($A$1<>"",VLOOKUP($A$1,CustomerVehicleInfo!$A:$E,1),"")

    Same formula for cells C4-F4.

    Problem is that the client data needs to convert from a formula to static text and next time the mechanic enters a new name in A1 it needs to jump to the next row, starting at B5.

    I hope all this makes sense and if anyone needs more info, please let me know.

    Thanks a lot!

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Convert data from formula to text then jump to next row

    could it be coded in VBA to automate your request? if so, send a sample and you'll get the VBA macro in return

  3. #3
    Registered User
    Join Date
    01-15-2014
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Convert data from formula to text then jump to next row

    Sure, here you go.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Convert data from formula to text then jump to next row

    i coded a simple automated macro that kicks in if cell A1 is changed
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-15-2014
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Convert data from formula to text then jump to next row

    Works great, thank you!

  6. #6
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Convert data from formula to text then jump to next row

    just one last request, mark the post as solved and if you like add to my reputation (I'm thye wrong guy to ask that)

+ 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. Formula as text in cell -> convert to formula result
    By AHFoddeR in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-12-2013, 02:00 AM
  2. Convert Text Dates, Perform Calculation, Convert back to Text
    By Orada in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2012, 05:25 PM
  3. Macro Text To Jump Columns
    By clarmech in forum Excel General
    Replies: 2
    Last Post: 08-16-2010, 12:14 PM
  4. How to jump to end of text only?
    By Joe Bloggs in forum Excel General
    Replies: 3
    Last Post: 08-12-2006, 03:40 PM
  5. how to convert a formula into text in order to display the formula
    By Claudio Hartzstein in forum Excel General
    Replies: 2
    Last Post: 07-13-2006, 05:05 AM

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