Macro excel cells jobs

Microsoft Excel Expert To Come Up With Some Formula And Charts

I have a daily Excel spreadsheet that needs to be split into separate individual Excel files containing some of the information only, and then hopefully able to automatically send to each relevant individual using the SHARE (via Onedrive) button. The more automated the better. I can supply an example sheet.

Hi Aubrey, we use a excel db for inventory, manufacturing/forecasting/sales and i have some new products which need to be added in. The employee who created this has now left the company so i need some excel skills to add in the products and ensure that values are updated for manufacturing, sales, inventory etc... I can send through the db and we can discuss. I have put only $10 as i need to chat ...

I have a formula I need written to solve the below problem. It needs to be a formula not a macro. Please view attached images as a reference. I will attached a worksheet to work on. I gave a hlook up formula in Column D. Its looking for a match in a specific cell of Column A. At times I want to delete rows in Column A, however I do not want to cell reference in the Hlook up formula to change. I ...

Copy Paste from PDF to Excel (URGENT) 300 Rupees

Run a music department in a secondary school. Each year students enrol in a variety of instruments and ensembles in our program with a variety of teachers. Wanting to create a tool that can display cohort and retention data. So tables of percentage and numbers for retention in 2nd, 3rd year etc, recruitment % of total etc. all sortable by teacher, instrument, ensemble, year level, gender etc. All ...

Develop a custom WHMCS module to integrate with PortaOne VOIP Billing. The following features need to be integrated as required: Admin Area: Create, Suspend / Un-suspend, & terminate PortaOne account View Call Logs with Detailed Dialed Information (Report of call history made to view or download) DID/SIP Number Pool (Fetched from PortaOne DID Allocation) Passes client number as CallerID &...

I need to append multiple Excel files to ONE. I will have to use Power Query.

About the role Finder is one of Australia’s largest digital advertisers, with digital media strategy, buying and optimisation managed in-house by our experienced team. Millions of users around the world use Finder to compare over 100 categories, providing a unique opportunity for you to develop complex strategies covering varied verticals. As a Digital Marketing Specialist, you’ll be ...

Create an excel valuation model for a renewable energy business. I work as a finance consultant and the job would be to produce/create the model with my inputs of the business model and assumptions.

Attached is the excel file. Column H If cell equals "Not Scheduled" then it should automatically copy the entire row into a new tab "Not Scheduled" If cell equals "Scheduled" then it should automatically copy the entire row into a new tab "Scheduled" If cell equals "Delivered" then it should automatically copy the entire row into a new tab "D...

Hi there, I require some assistance with some coding in R Studio to produce some basic charts (approximately x4 pie charts and x4 bar/line graphs). I will provide the raw data in xls format. The charts are simple/quick to produce in Excel but i need them in R Studio format for consistency within a document and dont have time to teach myself the required R code. Thanks

This is currently in pdf format, want it changed to excel and made editable. I changed it to word and the text boxes didn't work so will need to be re-entered. I also want 4 other versions of this template - I will provide the text.

need an updated financial excel sheet . Need someone who can plug in some numbers from a P&L quickbooks into an excel sheet

I have an existing data set with one column with dates in xx/cc/hhhh format. I need the dates sorted from nearest to today to furthest out. It’s about 2000 lines.

This is Ariful and i'm a professional data entry writer. last 4years to go i was working experience in many online platform . I can help you free up your time by taking over the responsibility of all your data entry, copy-paste, web research, or any other recurring job. I am detail-oriented and super fast. I will ensure we are on the same page about any tasks you will assign me, so we both ...

I have retail shop and I created some excel tables. I'll send it for you then you have to create some creative charts from it. The excel sheet is about the trading. I have created last 6 months sheets.

I need an expert Excel VBA Freelancer for regular tasks.

I have a pivot table that is currently setup to display only one month of data. I need it changed to display up to 12 rolling months of data. The Sales View window needs to display the next 12 rolling calendar months based on the data from the DB tab which I manually update from my system. The problem is that I can only show one month at a time so if I need to show the next 12 months, I have to do...

I have a PDF that needs to be edited in Word/excel in order to replace/edit some text. I will need 2 files edited and i need it ASAP, meaning today.

I have a cell which has a stock price streaming to it. This value refreshes every 5 minutes. I wish to copy this value every 30 mins and put it into an excel sheet. The times are 9am, 9.30am 10am ….18.00 - every 30 minutes Monday to Friday I will set this running on Monday and then the times will automatically be copied into cells.

I need a person who is expert in theoratical supply chain and in excel solver to do an urgent task

Arrange and distribute given company names to excel

Need help backtesting strategy 1 for options trading. Excel sheet must be included

I need a Macro (created with Visual Basic for Applications) to do a routine in CATIA V5

Good afternoon! We are looking for a reliable & motivated virtual assistant for ongoing internet research & data entry. Your job will be to go through a pre-built list of websites & find the owner of the website's contact details. We will provide a complete training video & walk you through step-by-step on how to find owner contact details. What we are looking for: 1. Rel...

I need computer operator for excel work

I want 10-20 full time or part time free lancer for data entry. He must have good knowledge of excel and good speed in browsing internet. Basically we have to browse the data from internet and enter it in a excel sheet. I have different project with different rate.

I want 10 hrs/ week virtual assisstant who is proficient at using excel and other office coordination tools.

Principal Component Analysis of 10 sets of data (collected in excel) max entries 350 10 variables. Code to be provided (ideal run in octave)

SPSS (Data Processing) and quanta crunch ₹750 – 1,250 INR per hour Posted 6 minutes ago Hi, We are looking for senior guys who has very good experience in SPSS (Data processing tool) and quanta crunch Data Processing Excel +3 more Hourly Rate 5 Bids 0.0

Hy I am data enter opratoer in different programs word excel. I can do the work in office.

Hi, I need help in questions around quantitative aptitute, logical reasoning and data analysis. Knowledge of data analysis in Excel is required.

I need a live data feed in excel template to be downloadable myself every day. And a dash board report of stocks. It should bring in top 500 companies, profile segmenting , few other details like live price, quantity purchased along with critical indicators, 52weeks high low etc.,, keep a record of value changes every 2-5 min. Show trend analysis. Choose scrips based on set multiple criteria and ...

would like to show analytical graph from excel.

Design a rule base expert system for a mobile robot to move from its current position to a goal position while avoiding obstacles in a 50 by 60 matrix. The rover can orient itself in 8 directions +/- 45 degrees to move from one cell to another cell. Rover can detect the 3 cells in its current orientation. Goal is to avoid the cell if there is a obstacle in that and reach destination. Rover can mov...

I need the Microsoft Excel exercise file attached to be completed in full. All work must be presented on the workbook tabs as outlined in the exercise

I would like to hire someone who can easily download a large excel file from a comic book storage/list app, then put the correct information in the eBay Excel template, and upload it to eBay for listing. I would also like this done for a baseball card app I am on. I used to know Excel pretty well, and could probably figure it out, but just don't have the time. If it works out, this will be a ...

Hi Nanda Kishore M., I would like to join with u in new project.. This one is very simple one.. I need crude oil option chain raw data in excel.

Hi. I have an an organisation training matrix excel spreadsheet that needs multiple (11) tabs combined onto one sheet and improved for easier ongoing management.

Live Crude oil option chain data is to be extracted from MCX website to excel

I have a food blog on WordPress and I’ve created a CSV export of all my posts (67 posts) and recipes (170 recipes). A number of cells in the export contain markdowns, HTML, meta-data. I require this data to be cleaned up to only display the written/legible content and the image URLs. View CSV File here: [login to view URL]

We are looking someone who can copy content from The website to excel. This is regarding peoduct review copying into excel. Thanks

I need this invoice created and formatted exactly like the PDF but editable in Excel I need the exact same size and font - in other words - if I were to print it, it would look identical to the PDF I need it quickly

Hi Ivan V., Previously you wrote an excel macro for me. I have a similar task. Actually, I wrote some of the macros but there are some bugs, and some unfinished code.

I want to create the MD5 hash from the first cell from the value of one cell in another cell. The values from column A should be displayed in the yellow cells.

Leading securitization, assets repack and structured finance provider is looking for a Legal Executive to support the company with its business transactions. Your key responsibilities: • Providing comprehensive legal support in relation to each transaction. • Drafting and reviewing transactional legal documents on each deal (structured transactions) including but not limited to loans, eq...

Macro research project , quick turnaround expected. Only for experienced professionals .

Revise macros in existing worksheets. Additional programming to other excel macro programs

I have a PDF that needs to be edited in Word/excel in order to replace/edit some texts.I will need 2 files edited and I need it ASAP ,meaning today