General discussion

Locked

excel equivalent of 123 "appendbelow"

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

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

excel equivalent of 123 "appendbelow"

by mslizny In reply to excel equivalent of 123 ...

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

Collapse -

excel equivalent of 123 "appendbelow"

by mslizny In reply to excel equivalent of 123 ...

P.S. The criteria you want can be communicated in an input message, an error message, or both.

Collapse -

excel equivalent of 123 "appendbelow"

by john.taussik In reply to excel equivalent of 123 ...

Poster rated this answer

Collapse -

excel equivalent of 123 "appendbelow"

by etittle In reply to excel equivalent of 123 ...

What about right click cell and insert comment?

Collapse -

excel equivalent of 123 "appendbelow"

by john.taussik In reply to excel equivalent of 123 ...

Poster rated this answer

Collapse -

excel equivalent of 123 "appendbelow"

by sfath In reply to excel equivalent of 123 ...

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

Collapse -

excel equivalent of 123 "appendbelow"

by john.taussik In reply to excel equivalent of 123 ...

Poster rated this answer

Collapse -

excel equivalent of 123 "appendbelow"

by john.taussik In reply to excel equivalent of 123 ...

This question was closed by the author

Back to Windows Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums