완료

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.

기술: Excel VBA, Excel Macros

확대 보기: 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

고용주 소개:
( 1 리뷰 ) the woodlands, United States

프로젝트 ID: #22206068

수상자:

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일 이내)
(14건의 리뷰)
5.0

이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 8명, 평균 입찰가: $31

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 don 더 보기

$30 USD (2일 이내)
(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 fir 더 보기

$30 USD (1일 이내)
(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 더 보기

$25 USD (1일 이내)
(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일 이내)
(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 S 더 보기

$20 USD (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일 이내)
(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일 이내)
(0 리뷰)
0.0