Build simple module in VBA with drop down and buttons
$10-30 USD
Πληρώθηκε κατά την παράδοση
(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
Ταυτότητα Εργασίας: #17192298
Σχετικά με την εργασία
Ανατέθηκε στον:
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 Περισσότερα
7 freelancers κάνουν προσφορές κατά μέσο όρο $56 για αυτή τη δουλειά
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.
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. Περισσότερα
Hi. I can finish the VBA task that will do everything as you specified. I've read your points, it's easy to implement
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 Περισσότερα