I have a spreadsheet of data that runs up to column AWI, with just over 2,500 records. I do not have the option of transferring this data to a relational database, which would be my preference.
On any given day, team members need to update various subsets of the data. The most common set runs up to Column BH, with many of those columns very rarely used.
I'm used to working with relational databases, where I can create queries and then design user input and lookup forms based on the subset of fields and specific records. I'm really floundering here with where to even start. I do not want users trawling through nearly 1,000 columns of data. That is simply a recipe for data chaos.
If someone could point me in the direction of a brilliant tutorial on creating user forms that might help me understand the best way to tackle this issue. In the short-term, I'm manually updating every change in the mega-sheet
while programming. Pain the proverbial, so the sooner I can put a data entry system in place the better.
Just as a side query: can I create a workbook called, I don't know, "Update Data" with a bunch of buttons and dialogue boxes that updates my master data sheet, without users ever actually opening it or gaining access to it directly?
On any given day, team members need to update various subsets of the data. The most common set runs up to Column BH, with many of those columns very rarely used.
I'm used to working with relational databases, where I can create queries and then design user input and lookup forms based on the subset of fields and specific records. I'm really floundering here with where to even start. I do not want users trawling through nearly 1,000 columns of data. That is simply a recipe for data chaos.
If someone could point me in the direction of a brilliant tutorial on creating user forms that might help me understand the best way to tackle this issue. In the short-term, I'm manually updating every change in the mega-sheet
while programming. Pain the proverbial, so the sooner I can put a data entry system in place the better.Just as a side query: can I create a workbook called, I don't know, "Update Data" with a bunch of buttons and dialogue boxes that updates my master data sheet, without users ever actually opening it or gaining access to it directly?
