Hi, I would need to automate the reporting that I have created manually and I would like assistance to ...Solved Then I do a weekly ranking and then I do a year to date ranking. If you need more information from my side please let me know but I would like to automate this via VBA or any other suggestion that you may have. Thanks in advance, Edson.
Hi, I want a VBA application made for picking a team of 11 people out of 2 groups of 11 Participant each. The Participant must be chosen from for races, like black, white, brown & yellow. Each category of races will have minimum and maximum limit to be included in the final 11. Further there should an option to set no of players from to be picked
Hello guys, i am looking for an expert who can help me building an excel macro. What has to be done? There is an XLS file which contains content and this content has to be inserted into an outlook otf file when you click on a button in excel. What content has to be inserted in placeholders? - customer name - customer e-mail ... - offers for customer (price, logo of company, percentage custome...
We have a complex excel speadsheet with many tabs and 3 VBA Macros . We need to have this online as a Google Sheets with input from HTML or Google Forms. Do not apply unless you have expertise to convert Excel VBA macros to Google Sheets apps script to achieve this. Please explain how you will do it and how long it will take. Autoresponders and
Hello We are...new customer pricing - and our ERP does not have the ability to create future price files. I need to merge our "everyday" pricing with contract pricing. The end result will be an excel file - of about 600 items - for about 30-50 customers. Must be good at vlookups - if you have VBA experience, this project could be very easy Thanks
i need a coding in excel vba/ vb Main Point :- Must not have mandate Admin access mandate- should be able to work on client systems Must be multi user enabled- At times its possible 30 or more users access the file. i have a small firm. I need my emp to keep track of the information. So i want my emp to fill the forms and we seniors/manager
We have regular projects in Excel and VBA, We require an expert in Excel and VBA to work on these projects. Need Someone with good logical thinking and problem solving attitude. You would require to showcase your previous work if selected.
I have a workbook (excel model) I built but need to protect it to allow only genuine subscribers to access if they supply correct username and password so as not to just keep sharing it all around.
Hi, It is a small work. I have a excel with some english words in column A, and a Download button. You have to write VBA code to download and parse json data from below url, and past the result in corresponding rows. That's all. Excel file attached. API Url: [đăng nhập để xem URL]
I need some help creating a User From in Excel that takes user input then places it into a spread. Just like a database, each row in the spread sheet should be a different record with the columns of the spreadsheet representing the data-field.
The final deliverable is the working version of the vba script that opens power point presentation in Mac and adds graphs & tables. I already have the script working in Windows.
I need a vba coder who have very good experience in writing vba
Using Microsoft Access, I need a tool that maps fields from one table to corresponding fields in a s...field values modified in order to meet the data requirements enforced by the external system. The tool must present a user interface with buttons and controls programmed using VBA expressions (not macros). It will be used by non-technical personnel.
Hello, I have a formula which I want you to transform it to VBA code in order to iterate a list of inputs. The formula needs to work in google sheet. I enclose you a case file, in order to understand better. The formula is =$C6*MAX(0,DAYS(MIN($B6,EOMONTH(E$5,0)),MAX($A6,E$5)))/DAYS($B6,$A6) and corresponds to the value of cell E6. Columns A,B,C
...one by one and get the relevant data and copy into the master file. I need to run it every day in a scheduled time. ( whatever required data cells, I already coded in the VBA code, so what you need to do is code to open files one by one and add to the master sheet) will send you files, if you are selected Budget 20$ This is an easy job if you know
1. If you bid and then ask what I need. I will flag you and never respond. 2. Primarily I am looking for a person to give ...instead of hello write "olleh". This way I know you actually are a detail oriented person and not just a FL scraper. [đăng nhập để xem URL] only bid if you are really good at formulas and VBA, I don't have time to explain every single detail.
Need to fetch multiple worksheets and correlate reports in Excel using VBA
I am seeking someone with VBA skills who can quickly develop a script to import information from a spreadsheet into another spreadsheet. This will produce a monthly report with updated graphs when the script is run. Requirements are attached in the Requirements Attachement worksheet in the Monthly_Change.... spreadsheet. Thank you in advance. Paul
i am looking for a program that can analyze websites The person who bids ne...ASP.NET(C#/VB) MVC 6) MongoDB, PostgeSQL, DynamoDB, MySql, MS Sql, Sqlite etc. 7) Apache Cordova/Ionic ✔ Desktop 1) C#/VB/JAVA/PYHON 2) Excel/Access/Word/PowerPoint with VBA ✔ Pro Scraper 1) Selenium/Scrapy/BeautifuSoup 2) Excel Macro IE Scrap ✔ Google App Script
...the tables and copy some information from one table to another. tbl_EMPS tbl_WORKING frm_WORKING When cycling through records in frm_WORKING (I need you to create the "Current Action" vba script) IF [tbl_EMPS].[CODE] is not null WHERE [tbl_EMPS].[Active]=True THEN Copy/Paste the [tbl_EMPS].[CODE] into [tbl_WORKING].[CODE] WHERE [tbl_EMPS]
...we upload the file, loop through all rows that has a date We create an event for each of the row that has a date, elements: “Time interval” is starting time and ending time of the event As "event title" add value in the column “Shift” + “Duration” example “SHIFT 08:00 hours" Create a ICS file of it (example attached...
I need a script that will read an Excel .csv file column (images) these are all .jpg images listed in the column and go to a seperate folder and copy the images and create a "new" folder with only those images that are in the Excel .csv folder This is a Google Folder link with full instructions and examples [đăng nhập để xem URL]
...someone with decent excel VBA skills for a project to automate and existing mortgage calculator. Most of the basic calculations are already present. the project involves clubbing of 2-3 different existing sheets, such that data flows as output from one sheet as input to another sheet. The collated data then needs to automatically create graphs. Someone with
I have a python code to be rewritten or fixed, with good knowledge of python and vba required.
It is a program by using Excel VBA that calculates the number of points for an employee in the case of performing tasks for example : Employee Numbers : 90 - tasks - 200 Mohammed Ahmed - Employee Number 001 Time of attendance, time of departure, first and second lips, etc. Days .. etc all date will be data entry ( add task ) ( remove task ) (
I am looking for assistance with an excel project that is part of an on-line course I am taking just for fun and my own personal learning. I already have a rough structure of what my vision looks like for this project but need help 1) Suggesting ideas to accomplish the objectives and 2) Putting in some of the legwork to construct the spreadsheet as I suddenly have very limited time for this. We ...