Matt_Straya
Member
Hi,
I am looking for some vba that can easily edit and change the cell contents in a column. For example, if Column A contained numbers 1 to 30 and was headed ID and column B contained names I'd like a button on another sheet ("Team") that you would click and you could then see the ID number and edit the name, save it but not necessarily see the actual sheet as the name would show on the "Team" sheet.
I have attached a sheet I am revamping. the sheet that the code would edit is called "List Data", specifically column B. All the other sheets (to be added) would pull their data from this Sheet.
Any help would be awesome.
I am looking for some vba that can easily edit and change the cell contents in a column. For example, if Column A contained numbers 1 to 30 and was headed ID and column B contained names I'd like a button on another sheet ("Team") that you would click and you could then see the ID number and edit the name, save it but not necessarily see the actual sheet as the name would show on the "Team" sheet.
I have attached a sheet I am revamping. the sheet that the code would edit is called "List Data", specifically column B. All the other sheets (to be added) would pull their data from this Sheet.
Any help would be awesome.