Build simple module in VBA with drop down and buttons

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

(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

Project ID: #17192298

About the project

7 proposals Remote project Active 5 years ago

Awarded to:

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 More

$30 USD in 1 day
(134 Reviews)
5.9

7 freelancers are bidding on average $56 for this job

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 in 2 days
(118 Reviews)
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. More

$88 USD in 3 days
(173 Reviews)
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 in 1 day
(37 Reviews)
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 More

$30 USD in 1 day
(2 Reviews)
1.7