Excel Macros Needed
$30-100 USD
Maksettu toimituksen yhteydessä
I have a spreadsheet program that needs a little macro work (attached). It would be pretty easy to look it over and then read the rest of this. The purpose of the spreadsheet is that a user will be limited to selecting only 4 fruits or vegetables out of a total of about 20 in the list and they must stay under the amount of money they have available (say $100.00). The purpose is for them to maximize their point totals. Here is what I need accomplished with this spreadsheet: 1. There are columns off to the right with different currency data in them (columns S, T, U). Depending on which currency the user selects in a drop-down box (Dollars, Euro, GBP), I would like those currency figures to appear in column C. 2. The formulas in cells C5 and C7 currently work off of 1's or 0's in column F. I would like these to work off of check-boxes in column F instead. 3. Most importantly, I would like the user to select which ranking method they would like applied, (either Rank A, Rank B, Rank C or manual). Ranks A, B and C are located off to the right in columns P,Q and R. If they select either Rank A, Rank B, or Rank C I would like this data supplied to column A and have Colums A, B and C sorted in ascending order on Column A. I realize that the columns off to the right (O through U) would need to sort as well to keep the data from getting all jumbled. 4. If they select manual, I would like a pop-up listbox to appear (I'm open to other methods)and allow them to manually rank the fruits and vegetables. Here again, when they are finished I would like their ranking to appear in Column A and have all the right descriptions and currency figures appear in columns B and C as well. This data set would also be sorted in ascending order on column A. This is all that I need accomplished on this spreadsheet.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows (excel spreadsheet)
Projektin tunnus: #6180769
Tietoa projektista
12 freelanceria on tarjonnut keskimäärin $71 tähän työhön
Hi. I am Usman and I can write a new VBA macro to do the desired job for you. Kindly share the sheet as you forgot to attach it. Regards. Usman.
Hi, I'll be happy to help you with this project using Excel VBA code (i.e. macro). Please feel free to message me if you need to discuss any questions
Hi, Please share the Excel sheet that you mentioned in job details. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for writing macros in Excel, MS Word etc.. I have more than Lisää
PhD in physics. Large experience in research and complex phenomena simulations using Excel and VBA macros. I will be glad to help you. Please send a message back to establish the details.
Hi, Glad to meet you. We have been doing with developing applications for past 10 years in all major platforms. Though your project specifications are clear, we could not find your attachments. Can you please provid Lisää
Hello Sir, I am interested to work on this. I have 3+ years of experience in .NET,C#,Excel, Access. Await your response.
I can do it. Pls contact me if interested. Thanks, Tom___________________________________________________________________________
Hi, I have 6+ years expereience in VBA, Excel Macros, VBScrpting. Would like to discuss more in detail.
Hello. I'm a licensed engineer (US-Arkansas) who would be happy to create your macros. I'm well versed in Excel and can create an easy-to-use, understandable and robust spreadsheet for you use.
Hello, I have an initial understanding on your requirement and I think it will make clear once I had the copy of your excel file. I am Jhero Cruz and I have a deep experience and knowledge in macro excel and other m Lisää