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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!