I have a table of data arranged in columns, the usual way. I want to call in the data from the table into a separate form on another worksheet. Then, I want to be able to update the data without leaving the form. (I.e., I don't want to be forced to update the data in the table directly; there are too many columns and rows to search through.)
How do I create a form to do this? I suspect the solution uses some form of VLOOKUP, and I know how to do that part. (I can successfully display the data using the form, but the only thing I can edit is the formula in the cell, not the data is is calling up.)
How do I create a form to do this? I suspect the solution uses some form of VLOOKUP, and I know how to do that part. (I can successfully display the data using the form, but the only thing I can edit is the formula in the cell, not the data is is calling up.)