+ Reply to Thread
Results 1 to 2 of 2

Change text in row based on activerow

  1. #1
    Forum Contributor
    Join Date
    05-01-2018
    Location
    Maine
    MS-Off Ver
    2010
    Posts
    114

    Change text in row based on activerow

    Hello,

    To begin with, I am not sure if this is possible. I attempted to find the answer but most of what I could find was based on conditional formatting which is not what I am needing. I can find another way if its not possible, this would just be ideal.

    The overall reason for the workbook is to send out automated emails. We generate a report that will have about 40 rows of data, each of the rows will be emailed to a different client. In outlook we use specific verbiage in a template but the data from the 40 or so rows (mentioned above) will always contain different info. I already have a working code that will send the emails. I am trying to come up with a way to merge the data row and the template together so when we use the email code it automatically filled in the data to the template. "Template" meaning specific cells that will stay the same while the data row mentioned above will change it slightly. I thought the easiest way would be to click one of the rows and it simply links that data to the template within excel (on another sheet).

    Hopefully that makes sense. I attached an example workbook to this post and tried to include the details in the workbook also to make it easier. I don't know if using the activerow is possible but any thoughts otherwise would be really helpful. I am still trying to learn VBA but this stumped me.

    Thank you in advance for any assistance.
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,989

    Re: Change text in row based on activerow

    Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for Sheet1 and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Double click on any cell with data on Sheet1.
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ 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. Copy ActiveRow to another sheet
    By Darkcloud617 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2021, 01:12 PM
  2. [SOLVED] Delete certain columns in activerow
    By jamief in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2019, 08:42 PM
  3. Copy ActiveRow cells to another sheet
    By lynyrdskynyrd5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2017, 06:50 AM
  4. Replies: 1
    Last Post: 12-17-2015, 03:35 AM
  5. Change column by cell value in ActiveRow
    By stanley in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2014, 01:20 AM
  6. [SOLVED] Macro to Highlight ActiveRow w/ DoubleClick
    By Kehoth01 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-23-2014, 11:37 AM
  7. VBA Copy activerow to another sheet
    By ronvannost in forum Excel General
    Replies: 1
    Last Post: 05-12-2010, 12:46 AM

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