Hello We are working on new customer pricing - and our ERP does not have the ability to create future price files. I ne...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
...of column is not known) - The excel holds a list of invoices line items, there might be more than a single row per invoice - Each invoice has an ID Macro Requirements - Two Macros are required - The Macro will create a new table instead of the existing one, on the same sheet - For each Vat Percent a column will be created, e.g. if there there are distinct
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.
pulling data from Cisco and pasting it into an excel file. I need it to automatically update certain columns such as " Agent log in time, logout, lunch log in logout etc. Looking to make this report completely automated.
...Codes to look-up the property record on [login to view URL], export the data, and paste it into the address source spreadsheet in the appropriate columns. 2. Assume the method is a VB Macro embedded in the spreadsheet. 3. If creating a separate CSV file containing the data is easier, more accurate, or costs less, let's discuss. 4. Please note that I may not have
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: [login to view 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.
...requirement so the code has to be able to keep this flexibility. Besides this , there is another requirement. I want an embedded macro where if I give the following inputs: Worksheet Name Cell or Range of Cells And I press the Macro button, all the cells that are in the given worksheet should be copy pasted for values....
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.
...desired time horizon. i.e. a scheduler that can switch the level of resolution of the tasks. For e.g., in the main Timeline sheet, the time horizon can be selected (through macro buttons) to choose the resolution of the timeline. view 1: Year on Year timeline. Show tasks and time bars in exact dates with comments field on the bar. view 2: 5-year time
I would like two Word macros written to enable me to save files with a consistent naming format. I have set out details in the attached document. Please only enquire about this job if you have experience in the writing of Word macros.
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
...customer ID, name, phone number, ... and I need: 1. I want write macro, AGI script to change from customer's ID to customer's phone number. So when user call to customer they don't need to know customer's phone number, user call to customer by dial customer's ID. 2. I want write macro, AGI, ... when customer call back to trunk, It's replace customer...
I need you to fix a complex macro to execute it flawlessly as stated in the project info file enclosed. The code and other files with project info files are uploaded here [login to view URL] Bid only if you are very confident to do this in 12-15 hours from now Can give $25 max. Bid confidently
...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. [login to view URL] only bid if you are really good at formulas and VBA, I don't have time to explain every single detail.
I have 2 excel spreadsheets with multiple worksheets in which I have to add one data point each month on each worksheet. I would like to be able to put all the new monthly data in a separate worksheet and for the rest of the file, the graphs and tables to be updated. I would also like the tables and graphs to be saved as a picture so they can easily be inputed into presentations. If we take the C...
Hi, Looking for someone to create a VBL / Macro in Excel to download and concatenate all the images from excel hyperlinks to specific folders. Collumn A : Folder Number Collumn B : 1st Picture Link (if only one picture) Collumn C : 1st Picture Link (if 2 pictures) Collumn D : 2nd Picture Link (if 2 pictures) this up to 4 pictures possible Images
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 have several 100 .xml files of some size. I need a script that can find data between 2 tags and write that data to a...these 2 tags inside the App record however they may not be above one another in each file as to say other tags maybe in between. I do have notepad++ if someone could write a macro? to do this or I am flexible for other solutions.
i am looking for a program that can analyze websites The person who bids need to have the following skills...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
...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].[IDField] = [tbl_WORKING]
...net/dev/docs#time-machine-request) pls note than in order to complete this project you probably must know how to convert Unix Timestamp to human readable date There should be a macro in the sheet which will sent request to Dark Sky using data from cells C4 and E1 and will print response to cells U27:U29 U27 - temperature (In Celcius) U28 - wind speed (km/h
LIVE Macro spread sheet for major crypto curencies showing arbitrage positions. Like this but one that works Use Dropbox to download file: [login to view URL] Excel Buttons: ‘Refresh Exchanges’ button — Refreshes Data and price differences on Bittrex, Poloniex and Cryptopia. ‘Refresh
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 [login to view URL]
HI, Need 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
I have a python code to be rewritten or fixed, with good knowledge of python and vba required.