Report auto populator

Đang Thực Hiện Đã đăng vào 1 năm trước Thanh toán khi bàn giao
Đang Thực Hiện 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.

Excel Visual Basic

ID dự án: #35863766

Về dự án

4 đề xuất Dự án từ xa 1 năm trước đang mở

4 freelancer chào giá trung bình£91 cho công việc này

ShakeelASESE

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

£30 GBP trong 7 ngày
(41 Nhận xét)
5.6
NANSAMEERA86

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

£50 GBP trong 4 ngày
(28 Nhận xét)
4.1
soniayt7

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

£135 GBP trong 7 ngày
(0 Nhận xét)
0.0