Table extractor in excel
Budget: £20 – £250 GBP
I want a data entry form/user interface that
1. allows me to browse a folder to select an excel file and import it into excel (a new sheet on workbook)
2. Rename this sheet from a cell within the imported file
3. display on userform the info in 4 cells (address, start date, end date and officer name)
4. allow me to visually check that the correct cells have been displayed (if not then a button to click to allow me to select the correct cell in the relevant sheet)
5. Write the displayed info on userform to a master sheet within the excel workbook.
1. allows me to browse a folder to select an excel file and import it into excel (a new sheet on workbook)
2. Rename this sheet from a cell within the imported file
3. display on userform the info in 4 cells (address, start date, end date and officer name)
4. allow me to visually check that the correct cells have been displayed (if not then a button to click to allow me to select the correct cell in the relevant sheet)
5. Write the displayed info on userform to a master sheet within the excel workbook.