We are looking for an excel VBA expert with strong client management skills to work out of our client location in Mumbai for about 2 months. The consultant must have 4+ years of experience, past experience with a consulting firm will be preferred.
Hi, I need a VBA excel script that can generate me all possible variations from 3 attributes(variables). For instance, I have a product that has 40 Barrel colors, 40 handle colors and 7 logo colors. I need a script that loops out all possible variations out of that in a excel spreadsheet (see uploaded image file).
I need the Python or VBA expert for multiple jobs. Please bid if you are expert
I need the Python or VBA expert for multiple jobs. Please bid if you are expert
I have a table in my Access 2016 database that holds data that has comma separated lists in two of the fields like this Name....Item Qty....Item...Quantity and the Name and add them together so that I can have the data output like this 1 - Bat 3 - Hat 4 - Ball 5 - Glove I am sure this is relatively easy using access vba but I lack the knowledge.
I have a table in my Access 2016 database that holds data that has comma separated lists in two of the fields like this Name....Item Qty....Item ...the Quantity and the Name and add them together so that I can have the data output like this 1 - Bat 3 - Hat 4 - Ball 5 - Glove I am sure this is relatively easy using access vba but I lack the knowledge.
...I wrote several tools in VBA for Excel. Users select input data and the tools produce numerical tables and charts. These tools should now be ported to Python, making sure: - both versions produce the same results - the output will be an Excel file - there is a simple online interface where to manage it all The Excel file attached to this post
I need you to develop some software for me. I would like this software to be developed in vba.
Hello, we need a VBA for Word 2016. The aim is to create a coloured register at the right hand side of the page. It shall insert a RectangleShape per Page for several pages on the very right border. The Rectangle position and filling colour should vary depending on "Sections" (not the actual Sections from Word / VBA but the sections I specify using
I have a file with list of company names (File to [ログインしてURLを表示]). I would like the entire list to be rid of terms that are contained in another file ([ログインしてURLを表示]). Pls note that those terms are case-sensitive and they may contain space before or after the alphabets. For example, one of the terms in [ログインしてURLを表示] is " SA". Therefore, a company name like "Robertet SA" in Fil...
Am looking for a VBA expert who could develop excel checklist based on manually selected checkpoints. For example if user selects certain checkpoints related checklists should be popped up in the next sheet
Adapting the supplied VBA code description, identify and list the pairs contained in 3 RNA designs within an excel spreadsheet (see attached excel file for complete description and supplied VBA code/outline in Tab4). Milestone will be the return of excel file that successfully creates these 3 lists.
...company and we need to work our data better, I am looknig to take a dump of data from our system on a daily basis and this will be saved on our cloud server say at 6.30am, then a VBA Macro will take that data and using another spreadsheet, this will add some columns and some new values to these new columns, with the guidance of the other spreadsheet. this
Hi All, When using outlook with multiple email accounts, is it possible to change which email account (the non default account) the emails are sent from automatically via VBA code when a new message is composed. I understand that by changing the default account this would allow the "From" account to be what I need, however I am required to keep the
I have done some macro VBA programs in excel. There are three macro program files which I am unable to load as there is a message "Cannot find project / library" which pops up every time I try to access the macros. I am prepared to pay the fees if this problem is solved for me. *Removed by Admin*
It involves generating projects with various characteristics, ranking the projects using several methods, buying projects using available money, and continuing th...for five capital budgeting periods (years). At the end of the five years the wealth accumulated by the various ranking methods will be determined and compared. This is a VBA Excel project.
Hi, i need to retrieve eurusd exchange rate from a specific website into Excel (i need the exchange rate published at "2.00pm Frankfurt time" I was able to do it till recently but now i m blocked. Please help me to find a way to do it without being blocked. see attached file. thanks
Hello and thanks for reading my post. i need a macro that retrieve lines info under a certain condition from one sheet to another
...and a contact list. You will see that in cell A3 i have a dropdown list for contacts. when you select a different contact, the data changes. If it is possible, i need some VBA to help email this dashboard (the black area that is used only) to the email address shown on the contact list. However, i need the data to be unique to each person that it
My idea is, that the user opens a empty Excel file (with macros) and has several options to generate different types of outputs. The VBA code should: - open a window to choose the csv file - read and clean data - sort data according to my specifications - generate output as new Excel files and PDF files The data is structured and comes with headers
I have attached an excel file and jpg file. The pic is a program I use that I would like to make a excel sheet do the same thing. I need to be able to sort each column by the value in that column. Example: make column I have ALH at the top I need to have a field that will push text into a selected cell. Let me know if you need any other clarification
Hello There is a free website that has data for thousands of files that I would like to mass copy into excel. There is also associated PDF files that can be downloaded but I would like to mass download them too. The site appears to have an easy to follow web address (I have a list of file numbers) which are the only changing parts to the web addresses
Hello and Happy Holidays :) My project consist of 2 seperate VBA tasks that require documentation. I ATTACH full description kindly review and let me know if interested. Our deadline is on 29 December! Thank you in advance :)
Possuímos uma ferramenta desenvolvida em Excel e Visual Basic for Applications (VBA) e desenvolvemos uma RFC dentro do SAP. O objetivo é conseguir fazer a ferramenta em Excel cadastrar dados especificos no SAP através do envio de parametros para a RFC. É esperado que o algoritmo a ser desenvolvido seja capaz de: - ler credenciais de acesso do SAP p...
Hi the project requires you to extract information from [ログインしてURLを表示] from every p...required: 1) Advertisement title 2) Address 3) Property Type 4) Rent 5) Bedroom 6) Details 7) Contact Name 8) Contact Number The data is to be extracted into excel/CSV format I strictly want the python/vba script. This is not a data copy and paste assignment
We would like to get a simple macro if you are familiar with VBA in excel. The base is an excel sheet with a few hundred-thousand building addresses. For each address, a link to a pdf exists. In this pdf, on page 1, multiple data need to be read out and put to the corresponding address line. On page two it should be counted how many "apartments" are
I have a spreadsheet to create labels for an ever changing inventory of lighting fixture samples. Iwant to be able to go immediately upon pressing a trigger (CTRL +SHFT=F) to the first empty row in the SAMPLES tab and start filling in the data. I then want it to autofill the 4 blank label templates on the Tag Template tab. I then want to print the 4 new labels, save the workbook and erase the j...