Excelроботи

Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.

Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.

Transfer news websites advertising texts...

Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией

Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.

Need an expert experienced professional coder to assist with adding one portion to my current project that has multiple sheets. Project Already 99.% complete. Will only require about 1-2 hours of work. The coder will need to remote into my machine and we will review and work on the file together in real-time. ***Please do not inquire about this project if you cannot do the work Live and remote.

I have two spreadsheets one with stock values for products from inventory software one with stocktake values. I want someone to add the inventory stock to the stocktake spreadsheet so I can so the differences. More work available if completed efficiently.

Hola, tengo un Excel con 2 columnas, una con los "nombres" de las imágenes, separados por guiones y otras con la "traducción" especifica. Tengo que crear unos archivos .png con Fireworks con capas, cada imagen una capa (con el nombre de la imagen), pero dentro del mismo archivo sin fondo. Y el nombre es la combinación de los nombres de las imágenes (separados por -) y seguido de un . Y la traducción. Es muy importante el nombre y es muy importante que el archivo png este separado por capas y los nombres en cada capa, si no este proceso no sirve... Podéis crearlo con macro de excel o con otros programas pero tiene que quedar tal cual indico. Seguramente necesiteis Adobe Fireworks, para que la macro y demas reconozca...

I have a current excel sheet i manually enter data- i would like to turn it into a form so that every time an entry is made - it submits data to another spreadsheet. the other spreadsheet needs to be able to save the data input from form in a historical manner- example entry made from day 1 will be bookmarked with that date and after there will be day 2 with the new entry data and so forth... attached is an example of the spreadsheet

I have requests on 4 different files. They should be fairly simple as most are removing or reordering bits of current macros. 1.) Master Availability Weekly List I email this file to lots of people, it works well but I have issues with Apple macs. I believe it is some of the calculations, particularly on the “Summary” tab, the calculation to ensure it only shows the rows with data in them. Do you have a better idea of what formulas could be used to work on a Mac? 2.) Mailer Program Generate Availability 2a.) Remove the functionality of 5.) compare live links and the button 2b.) Rearrange the buttons, the order should be 1, 6, 4, 2, 3. Obviously once reordered please renumber them to make it logical. 2c.) The the run all button should be in that order too and also remove th...

...separate database, a version of which currently exists in Excel; I need to be able to edit the working database myself to add (or remove) objects from the display. A degree of filtering is important for (5) and an overall search tool is also important. Each page should have navigation tools to move between page types (and the search tool). I want the pages to display meaningfully on the usual set of browsers, both on a computer and on a mobile device. I expect standard security precautions to be taken in development and for appropriate notice(s) to appear indicating that the images are copyrighted. I will need help to go live with the pages. In consultation with the programmer, I expect to reorganize the information in the existing Excel database as needed to suppo...

I had previously had someone do a partial spend analysis ca...previously had someone do a partial spend analysis categorizing and telling me about the main category spend per month based on my credit card statements. Now I want a spending analysis of my bank statements and credit card statements combined to understand how I spent my money between the months of October 2018 to march 2020. Some notes: - statements are in pdf. You will have to convert them into excel/csv. - credit card statements have categorization already done but bank statements don't. You will have to individually categorize expenditures. I can provide help with it. - you have to give a monthly report on how much money came in and how much went out(in each category). - i'll share a google folder once...

Hi, I have been trying to export the data to excel using open xml. I have succeeded to export the data however, i need assistance to sort the data in excel sheet based on group key. If you’re willing to work on this project please write me. Note I can share my monitor and you need to work on my pc.

We are looking to 'Get' information from a few formidable forms on our website into an excel spreadsheet via VBA. The ideal candidate should have experience with both VBA and Formidable Forms API.

I am looking for a detailed web crawl of any website. I am aiming to crawl each page of a website and pick only certain information to finally store in a database (suitable, to be suggested by you). So, input will be the domain and you need to find a way to compile all the URLs and then collect info as in the excel sheet. - Tab “Crawled URLs” will list out all the URLs of the sites - Tab “Internal Links Raw Data” will list out all the specifics of the internal links Now, for each crawl, you may need to record them under a unique crawl ID. This is the 1st phase of the project. We will expand the scope once we get the data correctly and reliably for large websites. I can explain the details of the required information in the attached sheet. To qualify for ser...

I need 12,000 first time experiences in an excel file. Example is the first time eating icecream, first time seeing the birth of your child, etc etc. I have already started but you need to fill in the rest in the yellow cells of the provided excel file. You can use anything and from anywhere, even your own experiences so I think it will be a really fun project. There must be no duplicates and please spell-check your work. Payment only on completion. Good luck.

For the POC is for LAB tester written in C# all test tests are written in python ( not for the POC) we need create a basic UI (save/edit/delete) and store in DB , requirements are in the excel The main tasks are : 1. create local DB , I will send the SQL scripts later Winform with the following buttons and dialog If all goes well , will add more logic MySQL etc…

I have an excel sheet that you fill out spaces and completes another sheet and i need to copy it with another format.

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

Hi Viruksha Sharma , I Noticed your profile and would like to offer you my project. We can discuss any possible details over the chat . This project will be alloted to a person only if the person is having a experience of 3 months + and this project is based on a lgt project Content Writing, Data Entry, Excel, PDF, Typing

Hi! We are interested in a salesperson (Cold Caller) who has the following skills and experience: Technical and essential skills: - Excel: intermediate/advanced - Virtual conversation management (customer service) - Cold call expert - Wholesaling - Fluent English and Spanish - Have Knowledge in Asana + Super plus: have knowledge and experience in Real Estate Personal skills: - Be able to close sales in the imboliary area. - Work organization (be extremely attentive to detail) - Adaptable schedule - Ability to mo...

I have a new word document that is a treatment plan to be used in a counseling practice that I want to turn into a word template with fields that can be filled expand as needed. May also need to integrate a crisis plan within this template that was created with Excel. Approximately 10 pages max. Will upload generic forms for reference and will provide files with edits that I would like to use for final product once we start working on project. Would like to start on July 5th.

Data Entery, Ms Excel Ms power Point

Build a tool that can scrap data off a website and I can run this tool on a daily basis. Project details: i) Go to a list that is updated in Excel or Google Spreadsheet every day and select keyword ii) Go to website, login, click on the right section of the website (about 3 clicks) and once in the right section input the keyword in the search bar (I'll disclose which website after project is awarded) iii) Get all the available search results and input them into Excel or Google Spreadsheet (about 10 items per search result and about 100 search results per page) iv) Go to the next page and repeat until the pages are done v) Go back to step i) and go to the next item on the list and do it all over again I have one more project after this one is done.

>>I have a complex excel macro work book >> i need an excel guru / professional to study it and make things simpler and robust the macro has lots of code written by two different developers.

>>I have a complex excel macro work book >> i need an excel guru / professional to study it and make things simpler and robust the macro has lots of code written by two different developers.

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

Enter information from a web site into a spreadsheet. Lots of copy and paste. Approx 375 companies to start in state of Florida. Other states to follow. Excel will have these columns Name of Company address city state county zip code Tel number Fax number email if available website url Expect to complete 25-30 complete entries an hour

Covert a word doc. to excel sheet so I can fill in information on the spreadsheet to create an invoice. I also need to change the logo in the top left to a different logo.

Requirement : Part 1: Data format Creation : USER Create a utility to upload excel format (set by user1) for data collection: PrimaryExcel The ‘primary excel’ is configurable basis varying needs so the number of columns or rows is not fixed. The column headers will be set by user basis the need. Part 2: Format upload & intimation : SYSTEM & USER The primary excel will be converted into secondary excel formats and corresponding intimation will go to the selected mailer group (MGrp). The mailer group will have a set of email ids along with description. User can define mailer groups beforehand and the system should allow multi-select option for MGrps while initiating any data collection request as explained in part 1. Secondary excel for...

Tengo una aplicacion excel con varios formlarios y base de datos en excel, quiero hacerle unas cuantas modificaciones y pasarla a access. Caracterisitcas que quiero agregarle: 1. Agregar comentario al crear tarea, este debe visualizarse al ejecutar la tarea 2. Agregar observación (comentario) al finalizar tarea. 3. Clave de seguridad a la data de Access 4. Alerta de tareas en curso, al finalizar el día (hora establecida admin) (Pausar o finalizar tareas en curso). 5. Alerta de tareas por vencer 6. Abrir automáticamente y presentar tareas pendientes 7. Mensaje de nueva tarea asignad (Fecha de Vencimiento y Nivel de Prioridad) 8. Carga masiva de tareas desde un Excel 9. Modificar el usuario de creador de contenido, todos los botones del panel adminis...

Excel and Vba to fill out forms with client details like name, pan card, address, fees, rates etc in a set agreement.

Hi there, my project is trying to save time on my inventory file. Currently once a week i add my stock order (additions) to my inventory, i then deduct all the items we have used for that week (deductions) from the inventory. to do this cu...add 37 to this making it 105. Later i would run through deductions and find that sku 4931465388 has been used 32 times so deduct this from 105 making it 73 this is then our current stock level. as you can imagine this is extremely time consuming and i am sure there must be a formula that could be written to do this automatically. our inventory is kept in google sheets but can obviousy be moved to excel etc for the purpose of this. I have attached a copy an example file for all i have spoken about above, really hope someone can help. Kind regards...

Hello Can you please create a baseline flowchart as per the attached excel file. It needs to be professional and in our company colours including our company logo. this is the first revision so i will use your design to show management and their will be further revisions. it should be clear the different departments/phases and the tasks within each department. it will need arrows between the tasks. task follow down the rows.

Please scrape the following webpage: I need the following fields in an excel spreadsheet: - rang, - name, - country, - age, - weight

Hello, We require someone to assist us with admin tasks - we are a small construction company your day to day tasks will be 1 - Taking photos from WhatsApp and dragging them into a SharePoint folder syst...little understanding of buildings and structure (gutters, bricks, etc. You will need to be able to right a report from what you see in the photos and the descriptions from the whatsapp chat. We will understand this may take a while to pick up but we can assist you along the way. some days you might have 5 whatsapp groups with some groups having 10 photos some having 30 2 - Your skills in word and excel need to be high so you can edit and make our current documents look much better - as well as document control. There will be many more day to day task but these will be the ...

Guten Tag, ich suche ein VBA Makro das mir ein rekativ komplexes Verhalten automatisiert um eine Excel Liste zu erweitern. Das Problemn ist, dass die Menge an Zeilen die kopiert werden soll absolut dynamisch ist. Hierfür kann ich die Anzahl der Zeilen mittels Formel auslesen und so vielleicht dem Makro diese Zahl mitgeben, damit es weiß um wie viele neue Zeilen die Excelliste (Tabelle 1) nach unten erweitert werden muss. Es wäre echt klasse, falls einer dafür ein makro schreiben kann :) Ich versuche mal Schritt für Schritt darzustellen was dieses Makro machen müsste. Die variable Anzahl der Zeilen nenne ich x. Schritt 1 Kopieren Kopiere folgende Zeilen von Tabelle 2 in Tabelle 1: Dabei muss das Makro immer in der letzten Zeile der Tabelle ...

-Move all the information from the PDF to Excel in a format that makes it possible for us to import it into our CRM. -Placing information from the PDF into corresponding columns of an Excel sheets. -The 10 PDFs no contains more than 1000 records. -Put all the PDFs in the same Excel. -Screenshots of examples are attached Please place your bid

I have SharePoint database excel file from which i need to create a Dashboard which i can share on Outlook

I have collected a lot of data in an Excel spreadsheet. I need help organizing it and understanding certain values there. Need help with understanding what formulas to use to get the most out of the data. Data file has over 60 000 rows.

The file attached explain the work better then a description :-)

I have SharePoint database excel file from which i need to create a Dashboard which i can share on Outlook

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

Looking for Microsoft Visual Basic excel Expert to reverse one .exe application to excel Application importe notepad database and export in excel format with segregated tabs

Dynamic Excel Dashboard, showing many information (office 365)

It's a digital art space, that combines contemporary and classical

Need to sort the ntries from column wise to row wise. examples given

Will explain the details in Chat. New freelancer with VBA skills are welcome. Total Budget for the work is $5

Update MCQ in a websites from word/excel/other source. 10,000 MCQ (eg 1 question 4 answer)

I need someone who can create an Excel Macro that will automate my web browser (chrome or edge) to do product upload from a CSV. I have attached an image of the form so you can have an idea of what it entail. If you can do this for me, please place a bid.