Visual Basic Jobs

In the attached excel file, I would like to get the Week endings between the following columns: Columns Q to AN represent stages of a call ticket. For example: Column Q represent the start date of stage DNQ 1 and Column R represent the end date of DNQ 1 and also Start Date of DNQ 2. .and so on. I would like to know how many WEEK ENDINGS it took DNQ 1 (Column Q) to move to DNQ 2(Column2 Q) and display the result in Results tab. Note: Week Endings should be calculated MONDAY TO FRIDAY. Column Q and R are an example in my explanation, and this concept should apply from Column Q to AN Purpose: Compare dates between column stages and distribute the data in result tab by Week Ending (M-F) and also another table by month.

Her Marka/Model Farede Çalışan Legit Macro/Script Yazılımı .lua ve .mgn2 uzantılı Macro/Script dosyalarını ortak çalıştıran Özel bir yazılım istiyorum detaylar aşağıda; Bloody, Logitech yazılımları gibi güvenli olacak. Arka planda Belli olmayacak! Anti-Virüse Yakalanmayan Temiz bir yazılım olacak. Bloody, Logitech scriptleri ve makro uzantılarına destek verecek ve çalıştıracak. Örnek: (.lua ve .mgn2 ) Her mouseda marka model ayırt etmeden stabil çalışacak. --> Yazılıma Girişler: günlük, aylık, haftalık , yıllık key ile olacak.*** --> Key sadece 1 Bilgisayar/1 Kullanıcı için geçerli olacak *** Uygulama içinde Harici Bir Macro Editörü olacak. Kullanımı, ara yüzü kolay ve anlaşılır ola...

I need a spreadsheet to collect and count catering information over multiple dates organized by pick up times. I have some raw data and I need help organizing and putting necessary formulas / macros together.

There are 3 files that currently work together to filter data and produce results. "v3Updated current " - Initial filter file. Results are produced in cells "EN195:FA2658" "" - Indicates which filters from the "v3Updated current " to filter "aapl " - Results from cells "EN195:FA2658" of the "v3Updated current " file are pasted to this file. Instead of pasting all of the results from "EN95:FA2658", I would like to be able to filter the results based on a secondary filter found in cells "EN4" ("TYPE"), "EO4" ("COND"), and "EP4" ("OCCUR") - total of 3 filters to be added. These 3 filters correspond to the same columns in the "EN195:FA2658"...

Please write "I know SmartConnect and Magento 2" in beginning of the proposal for consideration for this project Hi We are looking for an individual or company knows how to build an integration between 2 platforms: SmartConnect and Magento 2 This projects will get the source data from SQL Server and write back data to Magento 2 using its Rest API. Knowledge of 2 platforms required.

need experienced person in excel vbscripting for scraping data and sorting

I have an MS Dos program using Comma separated values that is used in my work. I need to update the database so I can use it in Excel. Some of the information is already in an excel spreadsheet and the CSV data needs to integrate with it. Data needs to go from uploaded file (see [login to view URL] )to an existing excel database

I have a VBA app with issue. Hope to fix issue. I will send more via chat.

We currently have for work 3 separate Google Sheets documents; one for table bookings, one is a calendar with all our live music & DJ bookings put in & one is a date list with all our upcoming events. I need someone to ideally create a google sheets document that would ideally be a formal weekly calendar with all three of these documents as one. We wanted to use a software like ResDiary but our owners want to strictly keep all documents on Google sheets, but we're aiming for this document to be the same kind of thing. We need a booking-calendar-event management. We need a Google Sheets and Google Apps script to build a Booking management system. Synchronise booking data with your GOOGLE calendar - Delete/add/update/ mark as done.... You can access to it via phone/table...

In need of a developer to 'finish' a Windows Desktop Application. The Foundation & Structure of the application has already been 70% completed by a different developer. In need of a new developer to finish application. Ample experience in .NET, VB.NET and Microsoft Access

I need an excel expert to create a Dashboard on excel for a manufacturing company. Only Senior profiles with minimum 5 years experience in the field will be considered. Send across your work samples with your bid to be considered for this role. One time project for now, may lead to recurring work.

I need someone to teach me in english without coding and done it automatically using excel E.g summary (i also have the address located at b1) I have different name tab e.g company in there e.g c1 is the address, everything inside is fix row and column, e.g name date How can i do such that if in the future i create a new tab e.g company b it will automatically display the thing i want address,name, date at the summary page without clicking each and every individual tab to find out the detail NEED IT BY TOMORROW

hello ,, i am looking for my own set up for generating signals based on nse fno data ( trade book data ) . I am already in talks with one data vendor who can provide data. Need a good coder of excel with good experience in excel data coding for stock market

debug excel file macro error I have created a simple macro in excel 1997 version that works well. It gives me an error in later excel versions. Can you correct the error in the macro?

i exported product's data (product name, options, price, etc) from my e-commerce website (as attached in 3rd excel file below) there's a column in this excel file that contains the price data (formatted into a group of data as seen in 4th excel file below) i want to highlight specific rows from this price column (in 3rd excel file's Column AG) and right-click. from the right-click, it will create two new copy options. 1st copy option is pop-up a dialog window to ask me the percentage to discount/markup, after i type the value, the macro will start to process and calculates each prices from the highlighted row, and change the price based on the markup i typed (but remember to search within the formatted price and replace the necessary values only) 2nd copy option is pop-up...

i have two excel files. one is product pricelist table. second is the excel table where i copy-paste the prices from first excel file. after i copy the price into the 2nd excel file's table, i will drag and highlight whole table & right-click copy. afterwards, i will paste that whole data into my e-commerce system, so the system will generate readable price by itself. now i want easier automation for the process i do (copy-paste price to another excel table). i want a loadable macro in my 1st excel file, so whenever i highlight the rows of price in excel file 1, and right-click copy, it will automatically re-formats the data into a table and apply it on my clipboard. so i can direct paste into e-commerce system.

Buenas noches a todos, tengo algunas macros creadas, que cumplen su funcion hasta cierta parte, no como quisiera totalmente 1: Resaltar fila y columnas con que tengan valores duplicados, que se resalte toda la fila, y toda la columna que tengas datos duplicados con otra fila, pero que no resalte las celdas adyacentes que compartan valores duplicados. 2: Tengo una lista de nombres base, que estan escritos correctamente, y otras hojas que tienen los nombres pero escrito de diferente manera (ya sea por acentos y otros inconvenientes), a tal punto que con la funcion "buscarv" no los encuentra, seria hacer coincidir los nombres mal escritos con los nombres base sin alterar el orden en el que estan. 3.- Buscar las notas de esos nombres (estudiantes), en otros libros excel, por nombr...

Hello, I need to program a pipeline excel spreadsheet that pulls in raw data from a separate spreadsheet. It’s all based in on foundational number. Thanks

I Need to create an excel sheet where I need to develop an automated way to cross reference pick and pack list that is categorized. I started making queries, power bi to manage relationships but keep getting stuck. If someone can help me.

Needed are very basic samples for CMD (commandline dialog, black window) for Windows Rules: 1) read all instructions before you bid 2) Expert is needed that will do these tasks less than 5min per each task. If unexperienced programmer applies that is fine, however cost is still evaluated same due it's complexity. 3) Time needed is 2day that is more than enough due codes are very simple 4) no copyright. all rights are transferred to buyer of course, when transaction is complete 5) expected ZIP file of all programs in time 8) see attached instructions, all tasks should be complete 10) batch files are to be separate, each in separate .bat file and numbered accordingly 11) batch files are to be written in Windows Notepad, saved as BAT and should do what is in requirements (attached TXT f...

Need to create automatic questions and answers in PowerPoint through Excel data.

Microsoft Automate expert required to take news feeds Multiple from twitter directly into an excel page. It must also be editable for the owner to add extra twitter accounts to the automation. The excel will need to auto create a new tab daily also to distinguish between each 24 hour period the feed is taken from. must be done using chrome.

I need to create several excel spreadsheets I need them done ASAP we will need discussion around this

You will combine two datasets to create the dashboard. (All datasets are attached) 1. 2. Indicator Create beautiful slicers using the Indicators, "cal_region" and "b201a_nkosuo_suport_received". I also need a map. Please use both datasets for the dashboard. NB: 1. The 3rd Excel file (Indicator ) is just a guide that tells you the units that the indicators are measured. Some of the indicators are measured in percentage, others in numbers, and others in currency. 2. 5 indicators from "Indicator " have direct links to 5 variables in the dataset "". See the word document titled "Variable Linkage". 3. The attached image "Color Code" shows the color blend I need for the dashboard. 4. Please do what you can and attach snapshots of you...

I need to create several excel spreadsheets I need them done ASAP we will need discussion around this - Budgets, Reports, Performance sheets, Tasks sheets all in Excel ideally have one master sheet with others that are attached and feed into one reporting sheet. There are 52 locations to keep track of across several work spaces. - I need to to be simple and scalable if needed.

We are looking for someone who can create scripts to convert detailed pdfs into excel sheets. This is a fairly straightforward task and provided the task is completed in a satisfactory manner we can provide full-time work.

We are looking for someone who can create scripts to convert detailed pdfs into excel sheets. This is a fairly straightforward task and provided the task is completed in a satisfactory manner we can provide full-time work.

I have two lists: - a bill of material showing with the following columns: product code, drawing no., qty - a list of product with the following columns: product code, delivery date first lot, qty lot 1, delivery date lot 2, qty lot 2 I need to allocate the product of the second list to the drawings of the first list, showing the latest date of reception of material for each drawing .

I have slicer to filter the data...after the data is filterd i just need to copy paste the visibile line alone to another sheet

I have slicer to filter the data...after the data is filterd i just need to copy paste the visibile line alone to another sheet

Proyecto para ir cargando grandes cantidades de registros , Big data , machine learning .

Remove 10 rows from current excel sheet w/o messing up values. New budget spreadsheet with about 10 items to calculate

Pivot / data analysis . Need it in a day

I am a excel coder But I don't have time to complete the project my self so I need a pro excel coder who can complete the project within 5 days . You will be provided with look up tables and small complicated formulas to back test simple strategy in excel . Once the project is done I want to use the data to use inferential statistics .Some one who is expert can apply for project.

I'm looking for a data extraction script which could extract data from indeed and LinkedIn and could grabs the jobs which are listed in country with search terms, where it could be in customised in Excel format, and raw data in document feilds i need are company name, description, job title description, job type, job requirements, salary, and some description customisation and title customisation Bottom documents are generated from single job where you can observe that in title: language name -- title of the position -- location like that in document it's just company description, job description and requirements Same as with excel but only few points with some customisation Any doubts please contact

I wanted a excel expert who can create an excel using VBA which can create or genrate appointment letters (200) and then crating a pdf and then mailing it to respective manager

Simple database to link customers, parts and orders together We need a simple MS Access database to be built. it will need forms to allow engineers to get / add data from a mobile or tablet. We have a basic database in place to amend or copy

I am having some calculation sheet, want to connect all data and do the sheet formatting for printing as per standard template.

Download automatically atachment from Outlook vba

I have an excel with data in certain format, and I need to redo it in a different format of my choosing, can provide you with sample excel and the needed format. Sample of my formatted excel is shared.

I got variable row lengths with any numbers between 1 and 45 Eg 9 numbers in row 1, 12 numbers in row2 10 numbers in row 3 and so on. The number of rows vary as well could be any number of rows in a sheet. Each line must be crossed with all the lines in the sheet eg 10 lines will result in 45 crossed rows. The result of each crossed two rows must count the common numbers and only if the count in the duplicate numbers is 5 or 6 the those duplicate 5 or 6 numbers must be output on a new sheet. If the number of results is more than 500000 the results must continue to cells away from the first row result.

Needed are very basic samples for CMD (commandline dialog, black window) for Windows Rules: 1) reall all instructions before you bid 2) Expert is needed that will do this in less than 15min altogether. If unexperienced programmer applies that is fine, however cost is still evaluated same due it's complexity. 3) Time needed is 1day that is more than enough due codes are very simple 4) no copyright. all rights are transferred to buyer of course, when transaction is complete 5) expected ZIP file of all programs in time 6) do not wait for me to reply. communication will be very clear, Freelancer is to be selected, then simply posts results and after verification payment will be released 7) up to 72h for verification and low internet connectivity from my side 8) see attached instructions,...

develop mathmatics formula on advance excel

I need to communicate between a VB6 SERVER and a FLUTTER CLIENT over LAN. If you read this letters, start from name of any country.

I want to create daily reports for my organisation. I have a table that contains data based on date. I am trying to create a report that fetches data from the table based on a single input of date. Just to give a little background, I have a manufacturing concern where I need to keep track of production at different locations.

I have a excel sheet project which requires VBA Macros to automatically fill the form according to data in excel workbook

• Read two HDF5 files with temperature data: one with predicted data and the other with observed data. Note: observation station locations can be found in the JSON metadata file. • Calculate the RMSE index for each 6-hour interval in the time-series at all points in the matrix. • Plot two-dimensional maps of the index for each period and a graph of the time-series of the same index for Bergen (Latitude 60.39299 and Longitude 5.32415). • Create a file with descriptions of all the steps to install and use your software. • Write the index calculation result in a NetCDF file

I have a project in VB6 that uses variable values from excel sheet, data storage in Acess and out put in Autocad. I want to convert this to Php.

I have a project in VB6 that uses variable values from excel sheet, data storage in Acess and out put in Autocad. I want to convert this to Php.

I would like to create an excel spreadsheet to manage and follow patient complaints. I have attached an inspiration for design. This is the spreadsheet we use for scheduling our patients I would like Patient Complaint spreadsheet to be similar, but will need modification to the columns and dropdown options. The Tracker will also need to be modified.