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

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.

Skills: Excel VBA, Excel Macros

See more: vba code create xml, vba code string gzip, tsv msaccess vba code, excel vba code optmization, vba code generate report excel, vba code check html link valid, vba code create pdf file access 2007 report, resize jpg vba code, excel vba code optimis, processor access vba code, vba code extract email text field, downloading vba code, wininet vba code receive, vba code handle pdf files, vba code control handle excel, turn vba code dll, vba code multiple functions, functions in excel vba code

About the Employer:
( 1 review ) the woodlands, United States

Project ID: #22206068

Awarded to:


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 in 1 day
(14 Reviews)

8 freelancers are bidding on average $31 for this job


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 don More

$30 USD in 2 days
(10 Reviews)

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 fir More

$30 USD in 1 day
(12 Reviews)

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 More

$25 USD in 1 day
(3 Reviews)

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 in 2 days
(3 Reviews)

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 S More

$20 USD in 7 days
(2 Reviews)

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 in 1 day
(1 Review)

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 in 2 days
(0 Reviews)