I have a column containing around 8000 of values The column describes a volume of alcohol bottle. The job is to parse the column and reduce to new columns: 1. Clean volume 2. is no. of bottles >1 For the cleaning regex there are several rules but it easier to show an example of the first 100 values, I attached an example of the parsing in the attached
...have 5 columns, all sortable except second column for it would be to open row details. Each row details row should display several client-side customizable data sets (link, banners, banners embed code) extracted from MySQL database with the same ID as column 1 ID on it's own MySQL database table and column. Initial table should be loaded separately
I have an excel spreadsheet that pulls 2 worksheets, parses and combines data, and creates a report for each customer. Lately the spreadsheet stopped working and is throwing a type mismatch error 13 on one of the routines. I do not know what changed but I need to get it fixed. I'm also open to just having the whole spreadsheet re-done or at least cleaned
Update the sign-up fields of a member press page to be two column instead of single column.
I'm a poker player and have around 100 ranges that I would like a...that shows the idea exactly. The grid size on each sheet will vary, but each cell of the grids will link to pictures of ranges across the grids bet sizes. At the bottom of the excel video you'll see there are 6 sheets with the same macros on each. All the information will be provided.
...where whenever I copy my urls into a google sheet the links have hyperlinks automatic. I can remove then in Excel easily, but as soon as I paste them they become hyperlinks. How do I stop that in just the 1 column from happening? Also I need 2 blank rows every 5 rows. need to work on this now, anyone available? Can be done in Excel or google sheet
The requirement is to create a macro on an excel data set. The macro should be able to do the following tasks: 1. Should do minor data corrections with the click of a button 2. Identify the trending of data 3. Generate graphs based on certain logic These are high level requirements. Details will be shared once confirmation received.
Need a developer to make an excel macro. The excel macro when run should do the following: 1. Download closing prices of a family of stocks (NSE/BSE India) from the internet 2. Update them in excel automatically 3. For each stock, perform exponential regression, calculate ATR, 100 day EMA, and if there is more than a 15% gap in prices in the past
I have a set of Excel spreadsheets that builds out graphs on stock market data, but a while back, Yahoo Finance cut off it's free download API and I am not able to get the stock market data. I just need someone to program the macro to: 1. Download the data for the symbol that I put in up to the maximum years back per the data vendor 2. Put the weekly
I need a Macro which can extract specific data from a word file and then generate a User form with drop down having the data from the word file and finally generate a word template with the values selected from the drop down in the user form
...two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other and vice versa. I need a macro/script to align all DATES and TIMES and delete the mismatched values in sheets up to 250k lines efficiently. I have uploaded one examples of raw data that need to be aligned
i have an excel out put from an app which i want to paste it into excel on one sheet and then have another sheet on the master file which pulls key data from the pasted file and then i want to click on a macro button to copy the new manipulated sheet and create a new sheet without the manipulator in it. i also want the new excel file to reta...
...need to extract only the dimensions (like 12 x 24 x 36 inch) from our product description column in our product csv file, and have the dimensions put in a separate column. I am hoping I can get this done for $200. There are roughly 2,500 product in the csv file. I think this could be done with a script or something instead of manually, but I do not
I need help with economics. Three projects to be finished in a timely manner. Masters in economics is preferred.
We have a financial modelling calculator that is having issues when transferring data in from an external source (CSV file). The original programmer is no longer available to trouble shoot. We are in need of a programmer going forward so there may be more work to follow if this task is completed to our satisfaction. ASAP Update: AUS/NZ preferred
I would like to automate a report based on a series of questions my empoyees fill out out. I need a way to auto generate a sample phrase into a word document based on a yes no question. So the employee checks of yes or no on a form. If it is no then then word will generate a response. If the employee checks yes they will have the options to check a/b for an answer and that will generate an answe...
I need you to develop some software for me. I would like this software to be developed for Windows.
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
I have a very complex macro which takes a csv of all our orders and put it in a neat printable html format. It isnt doing one of the things its supposed to properly so I need that fixing and I also need to give it some extra functionality.
- Updating of pivot tables to ensure that numbers change when cells are updated - Advanced filtering - Having a data entry sheet and using VBA to transfer the new data to the bottom of the existing data set - Improve user experience by making future data entry convenient
Hi, What I need is probably really simple but I can’t figure it out. I have a bunch of tables in excel that I want to copy into word; with the appearance matching how it would look if I did the copy and paste manually. Each table is on its own worksheet and is a named range (local name... name is same on each sheet), each sheet also contains a named
Please see attached file. You need to get the following data: Rows 2-780 Columns A, C, H, I, J, K, L, M, N, O, P, Q, R, S into the same Columns for Rows 783-2495 You will create a script or macro that will look at Column D, from Rows 2-780, and if the first 8 characters of the data in Cell D2:D780 match D783:D2495, then you will paste the data from
Hi, I am in the first steps development a downloadable excel calculator. The interface and calculations are confirmed and tested. To improve the usability of the tool, we will need the excel spreadsheet to host a number of specific VBA's to improve usability and functionality. I need a VBA programmer for approximately one week with proven VBA credentials
some one to program my JiTBit Macro Recorder to 1. Wait for Image/message 2. Based on Image Macro to Respond e.g Yes/No 3. Only respond of corresponding perimeters are met e.g. (price level) 4. Wait for time to elapse before restarting the process. This is simply my repeating a task where I would have to be in front of my PC to monitor. Can be
Macro to be written in the Personal File First File is output from MYOB. Second file is output from Ordermentum. Compare the two files using invoice number is primary criteria. - If there is a discrepancy in the final amount or tax amount, highlight the relevant row of the first file in red (This includes cases where the item is not existing in
Hi so this is a small CSS php task: implementing a button column and loading a different page depending on the button clicked. For more info see description and picture. Make sure your design looks good if you want some bonus.
...necesita una macro para LibreOffice que vaya guardando a lo largo del día el trabajo realizado. Las particularidades del proyecto son: - La macro deberá guardar el archivo abierto de forma constante durante todo el horario laboral, es decir, de 8:00 am, a 17:30. O bien desde que se ejecute la macro, hasta que se cierre el archivo. - La macro deber&aacut...
...launch an Excel Macro every X seconds within a specific workbook. Please don't bid if: You are not sure how to handle the constraints listed below, You don't explain the basics of how you intend to build the script in your offer. The script must ensure that the following constraints are met: -Excel must be usable between each launch of the macro. The
...described above. The due date is scheduled one week apart from each other. Task #1 due date is one week from when the button is clicked. The reminder date is to be the same day as the due date. The reminder time is to be 9:00AM. Task # 2 would be due two weeks from when the button is clicked. The reminder date is the same as the due date and the reminder