Tamamlanmış

Build simple module in VBA with drop down and buttons

(1) Create two sheets “Summary”

(2) Create drop down in cell B4 with values: HB_BUSAVG, HB_HOUSTON, HB_HUBAVG, HB_NORTH, HB_SOUTH, HB_WEST, LZ_AEN, LZ_CPS, LZ_HOUSTON, LZ_LCRA, LZ_NORTH, LZ_RAYBN, LZ_SOUTH, LZ_WEST

(3) User inputs value in cell B1 and B2 and selects location from cell B4

(4) Assume user selects HB_HOUSTON

(5) Create sheet named HB_HOUSTON

(6) Read date from cell A1

(7) Read interval ending from cell A2

(8) Read data from URL: [login to view URL]

(9) 20180617 is the date from cell A1

(10) Dump data in sheet HB_Houston for only column selected from (2) above

(11) Use formula in column C for sheet HB_HOUSTON and create column DateTime

(12) Average the hourly data and create summary table starting cell F3 in sheet HB_HOUSTON

(13) Plot the average prices from table in sheet Summary covering cells E2:L16

(14) Print value corresponding to given hour interval in cell A10. Read the given hour from cell A2

(15) Create a button to execute the command on Summary sheet

Beceriler: Excel, Visual Basic

Daha fazlasını gör: excel userforms templates, excel vba userform to input data, vba drop down list userform, excel userform data entry, excel vba forms advanced, vba userform ok button, option button vba userform, excel vba userform examples, build simple multiplayer flash game, simple excel vba open external program, build simple mp3 player site streaming, build simple php questionnaire, oscommerce build product module, simple programs vba, joomla create simple module 2008

İşveren Hakkında:
( 3 değerlendirme ) Adams, United States

Proje NO: #17192298

Seçilen:

sourabhg98

Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 rep Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(43 Değerlendirme)
4.6

Bu iş için 8 freelancer ortalamada $50 teklif veriyor

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(302 Değerlendirme)
7.2
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(33 Değerlendirme)
6.5
avinav606lx

Hello there, I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Daha Fazla

in %bids___i_period_sub_35% gün içinde88%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(160 Değerlendirme)
6.5
crazynightwalker

Hi. I can finish the VBA task that will do everything as you specified. I've read your points, it's easy to implement

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(34 Değerlendirme)
4.8
salimmurshed1111

i can do this, have a lot of experience and can bring a good result for you..... i will take the cheap rate but good service for you................ very much interested for this project............ and want to build a Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
1.7
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0