I have a spreadsheet that keeps track of our assets and data plate info as well as inspection schedules etc. It is about 2000 rows long and 50 columns wide. When changes are done, the unit number is filtered, then one moves across the columns to change the cells needing change. Can this be done with a userform? By entering the unit number the formula will find the row, probably with vlookup or index/match? My only problem is going to be units that have the sane number, but have two or three rows of data (combined unit). Not really looking for code, hopefully I can figure that out over time, just if someone has done something like that and is possible. I am wondering if it would be any time saving doing it this way as well? Thanks!
Bookmarks