Build simple module in VBA with drop down and buttons

Finalizat Postat la acum 5 ani S-au achitat serviciile după ce au fost prestate
Finalizat S-au achitat serviciile după ce au fost prestate

(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

Excel Visual Basic

ID Proiect: #17192298

Detalii despre proiect

7 propuneri Proiect la distanță Activ acum 5 ani

Acordat lui:

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 Mai multe

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD în 1 zi
(134 Recenzii)
5.9

7 freelanceri plasează o ofertă medie de 56$ pentru proiect

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.

$100 USD în 2 zile
(118 recenzii)
6.4
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. Mai multe

$88 USD în 3 zile
(173 recenzii)
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

$35 USD în 1 zi
(37 recenzii)
5.2
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 Mai multe

$30 USD în 1 zi
(2 recenzii)
1.7