Excel macro interact table calculation jobs
I need someone to make the excel table filtering tool (located in the header of each column of tables - [login to view URL]) be able to work with multiple values. The value(s) to be filtered needs to be set up into a separated table, one per row. The filter to be developed needs to offer the following conditions options: Equals... Does not equal... Begins with... Ends with... Contains... Does ...
This project consists of taking a list of LLCs and organizing these and listing properties owned by the LLCs underneath. I prefer this to be sheek and organized, color coded but highly professional. Organizing the data may take some time but may the best visual presentation win the contest. Again, this must be an editable format so I can add to the list when I need to.
Time table creation and schedule activity
My Project is to Excel data convert in xml. I will provide specified xml format. its very urgent. Only Expert can Reply on this post
Hi, I need an excel VBA Expert how can draw dynamic chart using Excel VBA or Formula. This job should be done within 2 hours. I need urgent. So, Only bid if you can start it immediately. Thanks
I use VBA and Curl to GET data from a client and place it into a .json file. I need to be able to use vba to pull that data out of the .json file and organize it onto a spreadsheet that I can work with.
Management system revampt Phase 1: Fix dashboard, fix forms, link forms and table.
Instructions Purpose The task of the assignment is to replicate all data analyses in the Excel Demo (BLOCK IV - C). More precisely, you conduct each of the following analysis for the data given in the Assignment C Excel file, which is downloaded from the subchapter "Assignment C": Test the difference between the mean of a variable and a fixed value Test the difference between the means ...
hi, i help companies restructuring teams and for that I need a tool that allows me to define roles and teams plus link employees to those
Looking for professionals only in excel and access I have project (Excel & Access) PROFESSIONALS ONLY
i am looking for data expert who can work quickly. i have 300 short write ups in excel sheet. you have to just highlight 4-5 words randomly in each write ups.
i need convert 1 min bank nifty future and option data into in 3,5,10,15,20,30 min 1,2,3 hour ,day ,week month and store in MySQL in different different table i need at 5 year data so please suggest me proper vender for data i if it is good we can fetch data from api tables structure is like that 1. bn_1min , 2. bn_3min , 3. bn_5min ,4. bn_10min etc option strike price store 1 min in d...
Have 120 Excel files that need to be combined into one main file. Each of the files only has around 20 - 50 lines of data so It's a simple copy and paste job. I need this
This should be a nice project to do this, its just online research and copy paste data. The objective is to find out what cities are best to target with a product that is used by these companies. Attached is a spreadsheet that has Adobe completed as an example, we want the cities of their US offices entered line by line, so we can see at a glance when completed, which cities show in the completed ...
Location : Germany Language : German Only professionals residing in Germany can apply. Manage Windows Server Operating System 2003/2008 R2/2012/2016 · File Servers Management. · Maintain and administer DNS, DHCP, NFS, NIS, DFS roots, and group policy ·  ...
Im looking for someone who can code an entire app. All I got is the sketch of the entire app. I got pictures of everything. I got a detailed describtion for every section of the app. I need someone who can code the app to interact with GPS locations. to show certain things on the app based on the area the user is in. I need someone who can code voice to text. The app will be a multi tool app. Wi...
Hi, I would like to Transpose data in specific data fields. I am attaching an image of the data field for your reference. As of now, I have two columns headers: Data Fields and Data. I would like the transposed dataset where column are: Discount Pct, Name of Restaurant, Rating, Name of Ratings, Cuisine, APC, Promoted, PRO Discount and corresponding to this column the data should flow in separate ...
I have an existing website using Razor pages and SQL Server 2016. I need a few changes to it detailed below: 1)Classification Report form (RAZOR) has a drop down list of values to pick from and currently you can only pick one or ALL. I need it modified to also allow selection of 2 values in the drop down. Same crystal report above needs modification to change the age group headings and the under...
Hello Everyone, I will need you to create an option menu table for presentation purposes. Of course creating a table of options presupposes the existence of objects (tables, forms, queries, reports). You will create a table of options which will have the following three choices: Introduction - data processing (deletion, data, search, etc.) 2) Auxiliary menu 3) Termination The field options in t...
Hello Developers, i am looking ios developer For my Company for a long time and regular work, but this time I need two task from him. 1: Make a ios Developer account for me bcz i don't have credit card for payment . 2: I have Complete code for a webview Application, live that on my Account which you will create... Keep in mind before Quote: if you did this well you will get regular wo...
I want excel form to automate information in the loan application of Bank.
I have a script that processes payments through different APIs. Currently the script runs entirely on the client. The functions of the [login to view URL] file should be converted into APIs, none of these functions should run on the client side, all the functions should run on the server converted into API. The client needs to call the server to use the API service, the [login to view URL] file...
The project consists of comparing several tables in CSV. A) Of these tables it is necessary to compare the EAN, Part Number and price. B) it is necessary to produce a file that places the Ean / part Number that has the lowest price of all the compared tables. C) the file produced must have the columns EAN, part number, price and what table it comes from (table name) D) it is necessary to comp...
Hello Everyone, I will need you to create an option menu table for presentation purposes. Of course creating a table of options presupposes the existence of objects (tables, forms, queries, reports). You will create a table of options which will have the following three choices: Introduction - data processing (deletion, data, search, etc.) 2) Auxiliary menu 3) Termination The field options in t...
Hello, I am looking for a developer that can create a 1) Highly stylized modern and functionally organized website. Redesigning elements of an existing template is encouraged. * I have each page's mockups and examples as JPGs / not PSDs or html 2) The website would present a ranking of Lists based on database entries of consoles, games, music albums and related books. Ranking of the LISTS i...
there are 5 male black widow spiders playing poker they are all looking look at their cards one of them sweating and he is saying "so my girlfriend is pregnant" there is a poster on the wall that says "plan B" there are some bears on the poker table one of them has a poodle next to them and a bonsai on an end table on the corner. There is a clock on the wall the time is mi...
I have already developed a macro myself for financial statements, and need to make some changes in the same, so as to reduce the error still errupyting.
change number based on a formular
I handle project management for a firm and it requires me to follow up with people on a weekly basis on the tasks assigned to them. I have an excel with tasks, deadlines, Handlers, and their email addresses. Need someone who can use VBA and Macros to automate the mails. All the tasks assigned to a single person should be clubbed in a single mail.
This is just a small problem I'm trying to solve using Google Spreadsheet. I need to scrap my Airbnb listing average price, preferable using Google spreadsheet function so that I can include the value into spreadsheet calculation. It's just one line of code if you are good with Import XML and XPATH.
Hi, I have a website, color scheme, and some design modules. I want to have a table that goes well with the rest of the design. It's a pricing table, it has regular price, item details, and discount. I want someone who can design it to look: - Streamlined, takes less space (especially vertically) - Clear (title of item is more visible than the details of the item for example) - Appropriate...
I have a spreadsheet which requires a formula to determine overlapping times, per individual, per day. I have a formula which only works for 1 name at a time. You can see that in column J the overlap is identified if the value is not FALSE. This is fine as I can apply a filter and remove FALSE values. However I want a formula which will identify the overlapping time values for each employee per da...
am currently looking for a front-end (web designer) that specializes in SEO. I am also looking for back-end PHP programmer to assist with cleaning up the CMS portion of my e-commerce travel website. Candidates must be comfortable taking over the work of a previous Freelancer. Front-end / Web Design / SEO development We are looking for a creative and responsible Web Designer that is proficient i...
Requirements Essential: You have experience in the development of web applications with Ruby on Rails You are familiar with PostgreSQL and modern approaches in software development including CI/CD You know why and how to test your code and have an opinion on TDD. You have a big passion for web development & software engineering in general. You like to solve complex problems together with your...
We are looking to hire French Translator (French to English and vice versa) on Contractual Basis. The person needs to interact with our clients and get us the requirements. He will also need to update the client time to time on progress of the project. He will have to be available on different time-zone based on the requirements. Technical background is important.
Hi, I have a table (called list1) with a series of information (last name, first name, email, zip code, birthdate, etc.) and I have another table (called list2) with the same information without the email address. I would need a macro to cross data of the two lists and let me know which people from list2 are also on list1. Best
I want some requirements in advanced excel. Please let me know. Regards, Nitil
I have an excel model to calculate the total cost of ownership for 3 vehicles ( Tesla model 3, Renault Zoe, and VW Golf) across 5 western European countries ( the UK, Germany, France, Netherlands, and Belgium). Now, I want to extend the model to calculate how much car Tesla should sell in each of the countries to beat the Renault Zoe by applying the minimum discount considering Tesla's profit...
I have an Excel workbook that list all my expenses by month (one sheet by month) and by account (bank account, credit card, cash). And I need to summarize all these entries in one table, where I can easily filter entries to create reports. The Excel workbook with all my expenses is "Bruno's Expenses - 2020". I also attached a demo of what I would like to achieve. Please have a loo...
We need 5 different (familiar to each other)graphic designs for a new company based in İstanbul, Turkey. We produce various types of products/clothing made by muslin fabric. It includes baby sheet & towel, table cloths, beach towel and bed cover. Due to muslin fabric's 100% natural, breathable and durable structure, it provides comfortable, high quality experience for people. It also hel...
Hello dears, We need 10 iPhone users from France to participate in an image collection project (you don't need to be native, just to be living in France) Each iPhone user should take 500 live pictures in (.HEIC + .MOV formats) of certain categories. The purpose from that project is to train the artificial intelligence in the search engines. If you are interested, please let me know your i...
i will attach image for refresh in show one table when i click on view data that need fetch data that id wise in second datatable in whole project we are using store proc and javascript just ping i will show what need to do
We have a list of Australian business names we need the phone numbers and email addresses for. Each business name needs to be googled and the relevant data entered into the fields.
This job requires the design of a dynamic mock-up for a web-application considering the actual structure of contents and navigation flow. In order to give some some initial details: the web-application is built on top of less then 10 different web components: 1) A colored button - it MUST contain a title - it MAY contain one or more additional label - it MAY contain a table 2) A label (contain...
Develop Python Application with Excel Report as Output..
Need an expert who has good command on financial calculation including making Balance Sheet and income statement analysis and financial ratios
I want to redesign the home page of my website. Key information/feature to include in home page are: 1. Do not stock iamges. 2. Add atleast 5 banners (personalised to my website). The message in the banner imagess would be: Image 1: Data Uploaded from Excel (Highlight security) Real-time upload feedback Used for BAU or Data Migration No Limit on transactions (bulk load) Su...
This is a business requirement I have included E-R Diagram for table cust_001 in the end and Schema of all tables in the sql file. Task-1 : Create a Procedure that will dynamically insert data from QA2 to Test env in the same database. (Need to take care of all the reference tables (i.e FK constraints) of the table passed in the parameter) Parameters : Table name , DB link name , Unique ids (C...
I need help with the coding. Requirement: Based on the size of the table split them to gunzipped csv files. If the size is large then based on limit split into n number of files. If small sized table just have a single csv. Have to create this using microservice.