append text

  1. V

    Automatically Append Excel Data to another Dataset

    I'm trying to automatically append any new data from one excel tab (ReportExport) to another tab (MappingTool) if the vlookup on the MappingTool tab is equal to N/A. Example: A new ReportExport is run everyday. The Report Export is linked to the Mapping Tool tab using a VLooup to confirm the...
  2. G

    Append text to new entries in a specific column.

    Hi, I want to add the string "_manual" to any new data entries which I will be making in column number "D". Can anybody kindly advise macro for this? Thanks in advance. Vinod Nair.
  3. C

    VBA - IF Contains then wrap with Chr in another cell

    Good-day. I have 2 columns of data (D, E), each with multiple rows of data in (number of rows changes depending on task): 1st column (D) = base term (blue widgets) 2nd column (E) = Exact, Phrase or Broad (can you tell what I do for living!?) I need something that copies the value in column D...
  4. D

    How to append text?

    I have a textbox used as a comment. This textbox on a form writes to a cell on a worksheet. For example, I type, "Hello World" in the textbox. "Hello World" gets copied to cell "A1" on another worksheet. How do I append the text, "Hello World", to what is already in cell "A1"?

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...