Turn array functions into VBA code to be able to handle larger database later on

$10-30 USD

Ολοκληρώθηκε

Αναρτήθηκε

πάνω από 4 χρόνια πριν

$10-30 USD

Πληρωμή κατά την παράδοση

I have a dataset with a "Sheet1" that is a summary tab that pulls information from the previous two tabs for a given State you pick from a drop down. I need to transform the array functions that pull information from the "Network" tab and spread out across rows (since there are numerous network entries per state) into VBA code because when I run the spreadsheet with more entries I get an error message saying "excel has run out of resources." To prevent this I want to have the VBA code instead of the array functions.

Excel VBA

Excel Macros

Ταυτότητα εργασίας: 22206068

Σχετικά με την εργασία

8 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 5 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

$35 USD σε 1 ημέρα

5,0

(14 αξιολογήσεις)

5,0

8 freelancers δίνουν μια μέση προσφορά $31 USD για αυτή τη δουλειά

@dalsaniyasonu123

Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project done as you mentioned in the description. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Sapna Dalsaniya

$30 USD σε 2 ημέρες

5,0

(10 αξιολογήσεις)

4,3

@shahinrahimi

I have rich experience in excel (Advanced formulas,Charts,Forms, VBA, Macro,....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Time Commitment # Availability Thanks, Shahin

$30 USD σε 1 ημέρα

5,0

(12 αξιολογήσεις)

3,9

@writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps

$25 USD σε 1 ημέρα

5,0

(3 αξιολογήσεις)

2,7

@zu02

Hi I'm professional ms access/ Excel/ vba coder. I can code it using ado/sql vba. I'll detail in private chat. Beat Regards zurab

$55 USD σε 2 ημέρες

5,0

(3 αξιολογήσεις)

2,8

@akritisood94

I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time

$20 USD σε 7 ημέρες

4,7

(2 αξιολογήσεις)

2,1

@vivirain

Hi, Good day! I’m interested in the job and can work out VBA program to resolve the issues. Hope we can get in contact soon. Best Regards,

$30 USD σε 1 ημέρα

5,0

(1 αξιολόγηση)

0,8

@aminuli255

I have read your project and I am expert in this field. I can do this for you within due time and honestly. I also have a few questions to discuss. Kindly contact me and we will discuss time and budget. Thanks

$20 USD σε 2 ημέρες