Hi,
I have a list in a sheet called Base_Data, the length of which may change. There are 35 columns which will not change.
Column C contains the name of a company. I want to be able to click on the name of this company and then be taken to my other sheet, called Summary_Sheet, which displays the 36 columns in a form like appearance.
Then I need any changes that happen in the yellow boxes to be reflected in the previous sheet, Base_Data, when you click back to the Base_Data by a button. At this point I need the SUmmary_Sheet to be cleared of data and to be ready for another record to be processed in the same manor.
I have attached my spreadsheet in a zip file.
Any help would be gratefully received.
Regards
Tubbsy
Bookmarks