I have an EXCEL spreadsheet that Users enter specific information and the sheet performs numerous calculations. I need to pull information from various cells on the spreadsheet and load to an AS/400 file. There will be numerous spreadsheets created during the day. I would like to load each completed worksheet as a new record to the AS/400 file.
1. I currently map the cells I need to concurrent entries on the spreadsheet - highlight the entries - then transfer to the AS/400. Is there a better way?
2. I need a quick way for the Users to seemlessly push this information to the AS/400.