+ Reply to Thread
Results 1 to 6 of 6

Populate specific cells on different sheet with cell contents of a preselected row

  1. #1
    Registered User
    Join Date
    12-05-2013
    Location
    Where Am I
    MS-Off Ver
    Excel 2010
    Posts
    23

    Populate specific cells on different sheet with cell contents of a preselected row

    First, thanks for any help you can lend.

    I have contacts list that I made and want to take it to the next level, but don't know how. See attached.

    The goal:
    1. Highlight an entire row of someone's contact info (i.e. row 9)
    2. Click the "ORDER FORM" text box to activate a macro that populates specific cells on the 'order form' sheet with the customer's contact information from the highlighted row. The information I want copied over is in red on the order form sheet. THAT'S IT!! (Oh, and 'paste value' the current date from H5 so that the date is static on the order sheet

    If possible, I would like to have an error check in case no row is selected prior to clicking on the text box that pops up the note "Please highlight a contact row before clicking the 'Order Form' button."

    Thanks for your help!!

    -Ekid
    Last edited by Mr_Ekid; 03-26-2014 at 10:55 AM.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Populate specific cells on different sheet with cell contents of a preselected row

    Maybe:

    Please Login or Register  to view this content.
    Note: I have to unmerge cells in B11:C11 on your Order Form to get it too work.
    Last edited by JOHN H. DAVIS; 03-25-2014 at 03:34 PM.

  3. #3
    Registered User
    Join Date
    12-05-2013
    Location
    Where Am I
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Populate specific cells on different sheet with cell contents of a preselected row

    Thanks! that is more or less what I am looking for.
    Question: It looks like you wrote that upon error do nothing. Is it possible upon an error of not selecting a row, to have a pop up state that no row was selected?

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Populate specific cells on different sheet with cell contents of a preselected row

    Maybe:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    12-05-2013
    Location
    Where Am I
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Populate specific cells on different sheet with cell contents of a preselected row

    Awesome Thanks!

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Populate specific cells on different sheet with cell contents of a preselected row

    You're welcome. Glad to help out and thanks for the feedback.

+ 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] Saving cell contents to specific cell in another sheet based on value in list
    By lukestkd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-24-2013, 02:51 PM
  2. Replies: 2
    Last Post: 01-26-2011, 11:16 AM
  3. [SOLVED] Populate pivot table with preselected items
    By sourav.dhar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2006, 08:15 AM
  4. [SOLVED] Open specific sheet depending on cell contents
    By monkey harry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2006, 11:50 AM
  5. Rename active sheet to contents of specific cell
    By burl_rfc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2006, 07:40 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