I need to automate setup of an excel model
I have a working excel model that consists of 3 identically structured submodels (3 workbooks called WS, SMS and CC), 4 input workbooks and 1 summary workbook. Input for submodels consists of structured data tables with 200k-500k records of <15 fields.
1. To automate data set-up For the submodels:
1.1 data validation that identifies null values from input
1.2 applying a (known and manually executed) algorithm to extend input data. This appends records to input data tables.
1.3 updating pivot tables in workbook
2. To automate input into summary workbook. Mainly linking-copy paste worksheets from submodels/input workbooks
16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hello, I am among the highest rated Excel modeling developers. Please share the sheet and discuss details. I shall be able to surpass your expectations. Thank you, Usman
Hello Dear, Perhaps you forgot to attach the file. OR Please give me you data file so that I can set the "Automated setup" for you. Reply for more discussion. Thanks ....