Hi,
I starting a new project that I would like to do in Excel and need some general advise.
User will have to,
1. Add data to a table
2. Change data on rows that matches certain criteria in columns
3. Remove rows from a table matching a certain criteria.
4. Create nice looking reports that are a summaries of maximum three different tables.
5. Import data to table from CSV
6. Export data to Rstudio amongst other.
Plan is that all these actions will be done from a userform and I have read that Excel tables is not that easy to work with from VBA. Should instead to this from Access?
For instance, I would like to fill a combobox with unique values in third column of table and I have not seen an easy way to do this.
This forum maybe not intended for questions like this, but I appreciate all kind of info before I get to far in this project. Dont want to hit a wall with excel after I put into many hours in this.
Bookmarks