2 Excel Macros with dynamic data

Dokončeno Zveřejněno před 6 lety K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

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.

Zadávání dat Zpracování dat Excel Visual Basic Visual Basic pro aplikace

Identifikační číslo projektu: #15875015

O projektu

5 nabídek Projekt na dálku Aktivní před 6 lety

Uděleno uživateli:

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 Další

$30 USD za 1 den
(18 recenzí)
3.8

5 Freelnceři na tento projekt zveřejňují nabídky v průměru $32

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 za 0 dní
(30 Recenzí)
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 Další

$50 USD za 1 den
(14 Recenzí)
4.4