2 Excel Macros with dynamic data

Đã hoàn thành Đã đăng vào 6 năm trước Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

I need help developing two very simple excel macros.

The macros will do the following:

1. search through all rows of tab 1 of each spreadsheet and search for matches in tabs 2/3 of the excel. it will copy data from tabs 2/3 back into tab 1. note the # of rows and columns in all these sheets will vary daily - keep in mind when coding.

2. it will then do some formatting/highlighting of cells in tab 1 based on cell values. finally, it will show an alert at the end of the macro ending summarizing which rows do NOT have matches found.

**These macros should be made compatible on both windows AND mac excel. There should have a button on tab 1 to run the actual macro.

Nhập liệu Xử lí dữ liệu Excel Visual Basic Visual Basic cho Ứng dụng

ID dự án: #15875015

Về dự án

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

Được trao cho:

imteyazkhan85

Hi there, I am an expert VBA and Excel macro developer, I will place a button on tab 1 to call the macro function. And i read your requirement, and i understood about it. Just 1 confusion is, is there any differen Thêm

$30 USD trong 1 ngày
(18 Đánh Giá)
3.8

5 freelancer chào giá trung bình$32 cho công việc này

osmemon

I have 7 years of experience in Excel and VBA with 100% client satisfaction history. see my profile for client reviews. Looking for your response

$30 USD trong 0 ngày
(30 Nhận xét)
5.5
dvcontact

Hi, I have read very carefully your project details about developing 2 Excel macros. I am absolutely sure that I can do the project very well. Rather than just show you past Excel Macros projects, I can exceed you Thêm

$50 USD trong 1 ngày
(14 Nhận xét)
4.4