Getting Data from a Cell Then Changing the Data Finally Putting it in the Same Cell

[N00bieGal]

Hello Everyone. I wrote a program to save inventory for a business. Originally, Column A would have a reference number that would keep track of what row the product is in. He would be able to use a form to search the data sheet and find the item based on the reference number, get the data into textboxes, change the information, and save it right over the old information by using the reference number to find the correct row. That was working just fine and there were no problems.

Unfortunately, this person wants to be able to edit Column A at any time and then save the changes over the old data. With Column A being changed, I am trying to find a way to save the location itself rather than try to match the reference number. Is there a way that when he selects the item from the worksheet the location (A#) can be stored so I can save over that same exact row?

 

[Jeffrey Mahoney]

Aaah, the age old conundrum! Trying to keep two separate tables identical while allowing edits on both.

I think you had it managed originally.

You could store the reference number in a variable when they select a cell in column A using Worksheet SelectionChange

You could add a duplicate field as the last column that stores the old reference number.