General discussion

  • Creator
    Topic
  • #2084068

    excel equivalent of 123 “appendbelow”

    Locked

    by john.taussik ·

    storing data input in first workbook into second workbook. neither template wizard nor data form works beacause i need to give user input help as they pass each entry cell. ican move the data ok but want the input range to grow with each additional record

All Comments

  • Author
    Replies
    • #3775850

      excel equivalent of 123 “appendbelow”

      by mslizny ·

      In reply to excel equivalent of 123 “appendbelow”

      You might want to consider using Data Validation. You can select this for entire rows or columns. Data validation in Excel allows you to specify a range of values or specific values which would meet the criteria you set.

      On the other hand, explain “append below” more, as I have not used this function before

    • #3787862

      excel equivalent of 123 “appendbelow”

      by etittle ·

      In reply to excel equivalent of 123 “appendbelow”

      What about right click cell and insert comment?

    • #3727254

      excel equivalent of 123 “appendbelow”

      by sfath ·

      In reply to excel equivalent of 123 “appendbelow”

      This might be what you need.
      range B1 for example is the start range with the next cell down not being empty other wise you will end up at the bottom of the spreadsheet.

      Range(“B1”).Select
      Selection.End(xlDown).Select
      Selection.Offset(1, 0).Select
      ActiveCell.Value = EmpName
      Selection.Offset(0, 1).Select
      ActiveCell.Value = EmpNumber
      Selection.Offset(0, 1).Select
      ActiveCell.Value = PayLocation

    • #3762636

      excel equivalent of 123 “appendbelow”

      by john.taussik ·

      In reply to excel equivalent of 123 “appendbelow”

      This question was closed by the author

Viewing 3 reply threads