Đã hoàn thành

VBA within Excel Spreadsheet

I need some VBA within an Excel Spreadsheet to generate an unspecified amount of tables.

It needs to create a new table using the template (Sheet "Non-Conformance") and pull through data from the sheets listed below when "Score" is less than 4.

Sheets to scan:

Planning

Emergency Planning

Welfare

Operational Ctrl

Safety Culture

Ops Ctrl (Must)

Ops Ctrl (Resp)

Ops Ctrl (Stress)

The data being populated would be as follows:

Audit Criteria: Column B

NC Category: Column V

NC Ref: Auto-generated, format to be determined

Also there's a slight issue when scrolling the offset sometimes messes up - please can that be fixed too!

Kĩ năng: Xử lí dữ liệu, Excel, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: excel spreadsheet vba data entry form, vba excel spreadsheet work, access vba open format excel spreadsheet, excel vba worksheet name, excel vba, for loop vba, workbook.worksheets vba, vba reference worksheet by name, excel vba range, excel vba sheet name variable, excel vba worksheets, vba front end excel spreadsheet, automatically email excel spreadsheet vba, vba excel spreadsheet, excel vba open spreadsheet start macro, vba excel manipulating spreadsheet, access vba manipulate excel spreadsheet, excel vba refresh spreadsheet, access vba data excel spreadsheet, access import excel spreadsheet vba

Về Bên Thuê:
( 30 nhận xét ) Wisbech, United Kingdom

ID dự án: #19243892

Được trao cho:

KozlouAlex

Hello. Below are examples of very similar works done by recently https://www.freelancer.com/projects/excel/create-auto-updating-excel-spreadsheet/?w=f https://www.freelancer.com/projects/data-entry/vba-for-microsof Thêm

£38 GBP trong 1 ngày
(16 Đánh Giá)
4.0

8 freelancer đang chào giá trung bình £37 cho công việc này

citijayamala

1. I am an expert in Excel,VBA, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex Thêm

£100 GBP trong 3 ngày
(64 Nhận xét)
5.6
IbexEnterprises

Hi There, I am very much interested in doing this project. I am having a very rich experience in this field. Please give me a chance to work for you. You can check my previous project feedback/Review/Rating from cli Thêm

£50 GBP trong 1 ngày
(7 Nhận xét)
2.1
minhdungnguyen

Dear Sirs, It's exactly what I can do the best. I've been an accountant for 9 years at several international firms with strong excel VBA techniques. I work together with my husband who is proficient in VBA and cod Thêm

£28 GBP trong 10 ngày
(2 Nhận xét)
1.9
Abdulwahab6699

Hello! Sir I am very interested in your post project. I am really looking for this kind of project for a long time in freelancer since I have experience in it. I think this project is very suitable for me and I sure I Thêm

£10 GBP trong 1 ngày
(0 Nhận xét)
0.0
Saitejab16

I AM AN SOFTWARE ENGINEER AND CAN DO DATA ENTRY WORK, ALL MICROSOFT OFFICE TOOLS WORK AND COMPUTER LANGUAGES ETC

£28 GBP trong 10 ngày
(0 Nhận xét)
0.0
aroralakshay2001

Respected sir/ madam I have great hand in excel and confidence to complete your work perfectly and on time Relevant Skills and Experience I can do excel work with speed and have 2 years of experience in a reputed fir Thêm

£13 GBP trong 10 ngày
(0 Nhận xét)
0.0
yoyo09

Hello, Hope you are doing great!! I have read and understood the description. I'm skilled in most common artistic and visual software’s Flash, Photoshop, Illustrator, After Effects and Premiere. Please provide more d Thêm

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