Simple Excel Macro Development

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

I have an Excel file with one column of zip codes (postal codes) - ZIPCodeMaster (File A). I have another Excel file (I will have different file name for each day) that has multiple rows with addresses with name and other info in each row - call it File B. I have attached one such File B. I want the ability for me to go into File B (which will be different name each day) and then to be execute a macro/script which will read File A and then select all records in File B with the zip/postal codes (Column G) and extract the complete relevant rows and then create ANOTHER and NEW worksheet in the same excel file (File B) consisting of such selected addresses with zip/postal codes as given in File A. The new worksheet can be name for today's date.

Excel Programming

Project ID: #13808748

About the project

35 proposals Remote project Active 6 years ago

Awarded to:

serdaryalcin

Bid Summary It is an easy Excel VBA project, would not take much time. Project Requirements VBA, comparing worksheets, and creating a new worksheet, using the data compared. Relevant Skills and Experience Years of V More

$20 USD in 2 days
(25 Reviews)
4.7

35 freelancers are bidding on average $25 for this job

cgullapalli

Bid Summary Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra Project Requirements File B is changin More

$34 USD in 0 days
(1042 Reviews)
8.2
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD in 1 day
(473 Reviews)
8.0
mantislin

Hi sir, This is kimi and I am scraping expert, I have did too many scraping projects, please check my profile page then you will know. https://www.freelancer.com/u/mantislin.html Can you tell me More

$30 USD in 1 day
(190 Reviews)
7.3
vsprybhanu

Bid Summary I have read your instructions carefully. Its a data manipulation work between two Files "A" and "B". Extracting data from B according to zip code of A. Project Requirements I will use loop through all More

$30 USD in 1 day
(94 Reviews)
5.8
zu02

Bid Summary I'll do that via Excel(macros/vba) or via Ms Access GUI wth Excel automation Project Requirements SQL, ADO, Excel Object Model with VBA, coding Relevant Skills and Experience VBA, ADO ActiveX, macros, Exc More

$30 USD in 1 day
(24 Reviews)
5.6
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. More

$29 USD in 2 days
(43 Reviews)
5.6
prabakarm23

I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I More

$35 USD in 1 day
(49 Reviews)
4.7
kahilH

Bid Summary Hi I suggest you a solution for your problem with Java program Iam a java developer and i did many scripts simillar to your project Project Requirements its about manipulating excelsheets Relevant Skill More

$30 USD in 1 day
(27 Reviews)
5.0
massm90s

Bid Summary Hi there, I'm an Excel and VBA expert; please check out my profile. Project Requirements I just need the two files alone in the same folder, since the names are not static. Relevant Skills and Experience More

$25 USD in 1 day
(22 Reviews)
4.0
JLQ006

Bid Summary This is fairly easy one. I can start working on the project right away and probably finish it with 3 hours or so. Project Requirements So basically you want the macro to replicate the File B on File A base More

$25 USD in 1 day
(18 Reviews)
3.8
HawkGuyIA

Good day. I can do this for you.

$30 USD in 1 day
(3 Reviews)
3.5
ketas

I have many experience with Ms Excel macro using VBA . Could make your request done within one hour. I'm pleased to helpnyou with minimum cost sine this is my first bid on this site.

$10 USD in 0 days
(13 Reviews)
3.9
vl16vaidya

A proposal has not yet been provided

$15 USD in 1 day
(5 Reviews)
3.5
oyasniy

Bid Summary I need to write a macros that extracts the information from fileB and put it into new spreadsheet Project Requirements A macros that perform the operation as described Relevant Skills and Experience I hav More

$25 USD in 1 day
(3 Reviews)
2.9
sachavukic

Bid Summary Hello, I'm writing Excel macros for more than 20 years. You demand is quite simple, and should not take a long time to be achieved. Project Requirements Your demand is to reseach informations located in fi More

$25 USD in 0 days
(5 Reviews)
2.4
Vineeta2327

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
aajmalshah

Bid Summary i will charge 15 dollar and delover you in 1 day Project Requirements i have alot of experience of your requirement Relevant Skills and Experience I am diploma information technology holder Proposed Mile More

$20 USD in 1 day
(0 Reviews)
0.0
EHANBLUE

A proposal has not yet been provided

$20 USD in 5 days
(0 Reviews)
0.0
khairulanam92k

I will send you a sample for checking.. Please give me only 10 mits. If you're interested about my proposal.

$10 USD in 2 days
(0 Reviews)
0.0
Nnick91

Bid Summary 20 dollars is what I am charging for this project. Project Requirements Data has to be read from two files and a new sheet is to be made fulfilling a set of conditions. Relevant Skills and Experience A pr More

$25 USD in 1 day
(0 Reviews)
0.0