Ολοκληρωμένο

2 Excel Macros with dynamic data

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.

Ικανότητες: Εισαγωγή Δεδομένων, Επεξεργασία Δεδομένων, Excel, Visual Basic, Visual Basic για Εφαρμογές

Περισσότερα: vba excel cut cell values, excel macros search copy cell paste, excel macros getting values internet, copy cell excel macros, excel macros assign cell content variable, excel macros copying data cell cell, excel macros next cell previous cell, excel macros check data cell, copy cell vbs excel macros, converting lotus 123 macros excel macros, excel macros unicode, excel macros programmer, excel macros create text files excel, excel macro move data existing cell, excel macros comparing

Σχετικά με τον Εργοδότη:
( 8 αξιολογήσεις ) Brooklyn, United States

Ταυτότητα Εργασίας: #15875015

Ανατέθηκε στον:

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 Περισσότερα

$30 USD σε 1 μέρα
(18 Αξιολογήσεις)
3.8

5 freelancers are bidding on average $32 for this job

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 σε 0 μέρες
(30 Αξιολογήσεις)
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 Περισσότερα

$50 USD σε 1 μέρα
(14 Αξιολογήσεις)
4.4
TetyanaS

Hi! I am Tanya from Ukraine. I have done more than 50 works in VBA and Vb. net for another clients (UpWork, GlobalFreelancer and Freelancer), and I think I can help you too. But first of all I need to get the whol Περισσότερα

$30 USD σε 3 μέρες
(1 Κριτική)
2.3
$20 USD σε 1 μέρα
(1 Κριτική)
0.0