Macro excel cells jobs

This project was as previously discussed and is for programmer Levgen S. ONLY!! Other bids will be rejected. Thanks for viewing and your interest.

I need some macro code written to automate and control copying data from a source spreadsheet to a template spreadsheet. The code will sit in the template that is to be populated, and the user will select the file that the data comes from (prompted to do so by the macro). The macro will match column headers in the template to column headers in the source

...need to write a macro that counts the number of cells that have a text value in column B that matches A AND matches has a certain color. Picture attached. So for example cell B2 counts if the value of B16-B200 if they have the same name (value is the same as A2). I need to create a macro for C2-F2 that will count the number of cells that have the same

We are a university research team developing characterisation methods for solar cells. For one of our research projects we need to short circuit a power supply at a speed of <1 us. The power supply will deliver a current of up to 40 A and a voltage of up to 60 V to a solar module and we need to short circuit the power supply to switch off the current

I have a requirement to create automation in excel based on user entering the [login to view URL] you have already created these kind of project before let me know

Columns Filter base on defined criteria Summarize data into another sheet Copy data to other excel file (to respective cell,based on criteria)

I have an excel file with 370 lines of addresses. I need these addresses copied into a separate excel file and split apart into different cells. Example address: Unit 1, 12 Main Street Sydney Example conversion to individual cells for the coded street type+suburb+post code: unit, 1, 12, Main, Street, St, Sydney, NSW, 2000 Being familiar with Australian

1. the Macro should be written in Javascript; 2. get the first empty cell in column C, the number of the first empty cell in column C is n(we will use this number n in step 4). For example, if C101 is not empty and C102 is empty, then C102 is the first empty cell in column C; 3. Using function [login to view URL]() to get the second pet name to the first

...complicated looking Excel Macro which needs updated. Essentially, we use Google Form to collect information, and run the Excel spreadsheet of data through a Macro to come up with a much better looking format. In Google Sheets, connected with Google Form, all the data gets recorded horizontally. That's hard for us to read, so we use an Excel Macro t...

Need six Excel templates developed with some cells that will change colour if amount goes to specific limits (need different colours for the different limits set).

Need six Excel templates developed with some cells that will change colour if amount goes to specific limits (need different colours for the different limits set).

We are set to test anyone from age 65 to 79 for cancer cells in their system we get paid direct fro medicare but it take 60 days the people pay nothing need 35,000 for sales people and teck help plu support we will pay 10% every 6 months for the use of the money

I need Excel macro or program that will for input file make output file (in .txt or .csv format). So for this example: JOB [login to view URL] INST HTS220 SC FT1,1.500,FT ENZ 427144.694,4855122.875,1.280 SC FT2,1.500,FT ENZ 427156.449,4855135.929,0.620 SC FT3,1.500,FT ENZ 427169.657,4855143.852,0.918 SC FT4,1.500,FT

...Interface should allow setting up profiles for use with multiple scenarios eg different games, applications or accessibility. - Ability to setup multiple phrases to each macro. - Macro should be able to map to either a keyboard press or combination of key presses, joystick/gamepad input device, mouse button or a system executable string. Optional : A

I need a work to be done with Excel Macro. Maximum Budget: $20

We have a macro that transforms data given to it in a particular format to another format based on logical rules. The data is separated and then sent to the appropriate columns in the format attached. For example, words in a text string which have been categorized as cities are separated from the rest of the string and directed to the city column in

Hi, I need an Excel macro that gets historical stock price data from yaho fiance and saves it in three worksheets (chronologically newest first) as per the attached excel file. I will only consider offers that start with the word "Carrot" to make sure you have read the description

Hello, I am trying to have the columns on a 3D chart in Excel match the corresponding cell color, which is colored from conditional formatting. I've seen some VBA code out there but haven't got any to work. I have 4 charts in total that I need this done for. I'm willing to pay anyone who is able to get this to work for me. I've attached the file. The

...project with data that is structered in the same way in each excel file. We would need a relatively simple macro to do several things automatically. We want to compare averages and test for statistical significance. We provide the formulas and illustrate clearly what has to be created. The macro should be able to do among other things: Filter data on a

I've a dataset in Excel File, from which I want to create a Pivot Chart. I want to get a Macro Enabled button, clicking on it asks to upload Excel Dataset, and looks at the data, manipulates it a little bit, and creates Pivot Charts from it in a new tab. Here's what I want to do. Column 1 has a data like "190123000000" which translates to "YYMMDDHHM...

Copy Paste Task. Macro popup, more things discuss in chat

Attached is a Word document. We need a macro that pops up, asks how many times to repeat the block, and then, based on the answer, repeats the highlighted yellow text 2 to x times (if the answer is 1 - no repeat). Note the text includes the table and text after it.

To map the masterdata into timesheet tracking by Months (worksheets).

This project relates to scientific finding. We found - TAF5L and TAF6L as new epigenetic regulators for embryonic stem cells (ESCs) state. These two molecules predominantly activate MYC regulatory network for self-renewal of ESCs. In simple, we would like to show this through any analogy or cartoons- how TAF5L and TAF6L (they are very similar) regulate

I am looking to be ...consolidated table. Additionally, I am looking for a workbook designed to take data in one table and copy a rows in the table to separate spreadsheets based on criteria in one of the cells. (i.e. one column has names in it. I want the row to copy to a template in the other sheets in the workbook based on the individual's name)

Attached is a Word document. We need a macro that pops up, asks how many times to repeat the block, and then, based on the answer, repeats the highlighted yellow text 2 to x times (if the answer is 1 - no repeat). Note the text includes the table and text after it.

Thanks for taking the time to review this project. If you love to work in Excel, take a look at the image I've attached to this project and let me know the best way to create a script or formula that will take the data in columns B-W and substitute the data in cells B2:B4, C2:C4, D2:D47, E2:E25, F2:F6, G2:G4, H2:H4, I2:I47, J2, K2:K5, L2:L12, M2

...you to use the bee cells in different styles to create the final concept : 1- Cells varies in depth ( height ) from each other , or graduating in depth solely or as groups 2- cells have different outlines , some with borders , some without 3- cells have different cove light outerlines ( lightened ones , and darken ones ) 4- cells graduate in colour

I attache a txt file with the url: [login to view URL] I attached an Excel file with example how i want the table structure on MS Access. Excel file is only an example. You have to use the xml as source. You can create a new Access database with a table, and a form with a button. When click on a button, must to

..."ideal" PDF that should be generated with the ideal layout in A4 landscape view is what we wanted (see the description column nicely fit the text multi line wrapped around the cells in desirable cell width size as well as the font size in A4 landscape format is suitable to read). Also we would like to reconfigure dashboard in the front page - this will

We would like to be able to set up a spreadsheet so cells will be highlighted to which changes have been made. The types of changes to be highlighted would include: -adding text to a cell -deleting a cell's text

I have a custom uitableview with custom uitableviewcells. One of those cells contains a list that i read from server api. I need you to do the layout for the cell, so that i can simply add it to my project with live data and use it. I will show you the android version as an example. Basically, there is a bunch of info, then user can either select

A simple spreadsheet where when i enter my Youtube link (B1) and this link can be auto insert into other URLs (embedded link rows) some rows have different ways to paste the youtube id link,(1) [login to view URL] (2) [login to view URL] (3) [login to view URL] (4) [login to view URL] etc to make it easier for you, you do not need to arrange the sites according to the same order i sent u

A simple spreadsheet where when i enter my Youtube link (B1) and this link can be auto insert into other URLs (embedded link rows) some rows have different ways to paste the youtube id link,(1) [login to view URL] (2) [login to view URL] (3) [login to view URL] (4) [login to view URL] etc to make it easier for you, you do not need to arrange the sites according to the same order i sent u

I have many CSV files in a...create a giant CSV file out of it, which technically is a compilation of all data into a single spreadsheet. So, CSV1 will have 100 rows and CSV2 file has 200 rows. I want an Excel Macro, which will take [login to view URL] and [login to view URL] files (which are in the same folder), and creates another CSV file, which has a total of 300 rows.

So I have a spreadsheet, I need a) Some cells show a specific word, remove it b) Append a text on some cells c) Remove duplicate, email, phone number, address Need this done now.

Need someone to write a google apps script in google sheets to take contents from 2 dif...are received through the day so triggers at different points in the day to update the daily file. Output - Google spreadsheet in a specific format - CSV export of specific cells in a prescribed format (below format) in a CSV file) .CSV (comma delimited) format

Excel VBA I have three columns of Excel (Column A, Column B, and column C) I need to create each individual HTML file for each Row, I need to replace the (value) with contents of column A and column B with HTML file and rename as Column c and save Ex column A | Column B | Column B bat cat meow text contents: the #columnA

...need some Excel code that will set the number of decimal places in calculating cells that are based on an input cell for resolution. For example, if I enter in a resolution cell .001, then all cells were data is entered and calculated default to the same 3 decimal places. Same if I enter .0001, then all data entry and calculation cells have 4 decimal

There's an shopping app called Frenzy on both the iOS and Google Play Stores Basically, users are directed to tap the screen at a certain time, select the size, and select payment. I need an script that will automate this. I know there's a script out there so I know it can be done. 100% of the payment will be sent after you can demonstrate that the script works on limited releases.

I am looking for an Excel Macro expert. I have a spreadsheet with multiple columns, one of those columns has a full name that may include first name, initials, other names and last name. I want a macro that will only pull out the first and last name.

...of "120/208V" or "277/480V" in cell AC6. I need these numbers to go all the way up to 84 in both color sets for all the cells under "CIRC. NO.". I have gotten it to work for one celll only but it will not transfer to any more cells for some reason when I change the range. So I would end up writing the function for each rule in each cell 168 times whic...

Need codes to measure the cells circulatory and size

i have a macro that runs on 2016 however it does not work on 2013. place the attatched files in the same folder then open the two project files run the macro

I need some support on creating macro from excel to generate file from template that upload and download data to a SQL database. it is not a large project but can go on step by step. not many hours a week but can last a couple of months. attached you can find a sample file: there are a couple of main table that can be stored on a SQL. You need to:

Hello, I need quick help in creating the small excel form for nomination collection. 1) User will fill the information in excel template. 2) On clicking the submit button, email (outlook ) to be sent to pre-defined ID with excel file as an attachment. 3) Also excel file to be uploaded in a sharepoint folder.

I need an excel spread sheet updated and streamlined to be more user friendly and easier to make changes to that carry over to all tabs. We use this spread sheet to keep testing data up to date and easily accessible. This sheet will need to contain all the information provided, have cells that data can be entered into, be easily updated and have up

Need a realtime excel programming or script based on a trading strategy.

I need a professionally looking and functional cover page, which is a part of a PDF report generated from an Excel spreadsheet. Unique data is imported from other cells of the spreadhsset to the cover page so it needs to be an a part of this spreadheet. Samples opf similar completed projects will be an advantage. I will provide further information

I am looking for somebody who can write VB or Java to copy and paste data from a spreadsheet into a master sheet. The data is the same , but not in the same cells. See green section of the 3 files. An example master sheet is on the data tab of sheet 1. I am open to all suggestions to complete this project.