Lengkap

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.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: vba excel cut cell values, excel macros search copy cell paste, excel macros getting values internet, microsoft excel, 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

Tentang Majikan:
( 8 ulasan ) Brooklyn, United States

ID Projek: #15875015

Dianugerahkan kepada:

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 Lagi

$30 USD dalam sehari
(18 Ulasan)
3.8

5 pekerja bebas membida secara purata $32 untuk pekerjaan ini

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 dalam 0 hari
(30 Ulasan)
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 Lagi

$50 USD dalam sehari
(14 Ulasan)
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 Lagi

$30 USD dalam 3 hari
(1 Ulasan)
2.3
$20 USD dalam sehari
(1 Ulasan)
0.0