Report auto populator
£20-250 GBP
Thanh toán khi bàn giao
Further Details - I have the first part of VBA working so can send you a s/sheet. However I need to make the data pull from the analysis sheet into the report sheet dependent on a variable category, category being selected from a drop down. The logic to define what needs to be pulled into the report is complete, so I just need to interrogate 4 different columns for 4 different categories in the drop down and if "1" is in that column, write the data into the report.
Details. If "Open - Late to Baseline" is selected in Report sheet cell N26, then if a "1" is present in Analysis sheet column AA, then the report needs to pull the relevant data from the Analysis sheet row containing the "1" (as per the the current report - you can see the details in the existing VBA).
However, if Report sheet cell N26 is changed to "Open Task Look Ahead", then the code needs to look for a "1" in Analysis sheet column AF and pull in the relevant data. Likewise, if Report Sheet cell N26 is changed to "All Tasks" then the code needs to look for a "1" in Analysis sheet column AJ and finally if N26 is changed to "Tasks in Backlog" then the code needs to look for a "1" in column AO.
Therefore as the user selects the category from the drop down, the relevant data is presented to them in the report. File attached.
ID dự án: #35863766
Về dự án
4 freelancer chào giá trung bình£91 cho công việc này
I am working as a Developer, Programming Expert, Data Scientist and expert in ->Python, Tensor Flow Framework, C, C++, C#, VB, Visual Studio, Online Scrapping, ->Analysis and Modeling MATLAB, Predictive Modelling, St Thêm
Hi Sir, I read your requirement I can give my servise to you with good solution ,waiting for more detils to move forward. thanks Sameera
HhI I am experienced in and I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your replyyy