Excel VBA jobs
Ich möchte einen VBA Code für eine Tabelle, der mir aus der Tabelle einen Ordner generiert, wenn man dort eine Zeile ausfüllt und in der Tabelle einen Link zu dem Ordner anlegt. Grundcode vorhanden, aber komme nicht weiter. Das brauche ich noch: * wenn ich Änderungen an den Spalten vornehme, aus denen der Name zusammengesetzt wird, sollte eine Abfrage kommen "Ordnernamen auf Server ändern?" => dabei darf aber der Inhalt nicht gelöscht werden => die Änderung soll sich dann sowohl im Ordnernamen, wie auch in der Neuerzeugung des Links wiederfinden * die Option den Ordner via dieser Excel bei Doppelung zu löschen und neu zu erstellen (=> aktuell über eine Abfrage) sollte eine Ausgabe bringen "Ordner existiert bereits", welche man nur schließen kann. Der Ordner darf nicht via Excel-Befehl löschbar sein ! * kann ich zudem programmieren, dass er bei Eingabe einer neuen Zeile eine Prüfung bestimmter Spalten auf gleiche Werte in der Spalte vornimmt und eine Meldung ausgibt " dieser Wert existiert schon in Zeile XX, wollen Sie den Wert dennoch verwenden ? JA NEIN * wie muss ich den Code anpassen, damit er mir den Namen aus 4 Spalten erzeugt C, D, E, F * Last but not least: weiß jemand, ob das VBA auch funktioniert, wenn ich die Excel via Excel Online bearbeite ? (ich habe diese Tabellen lokal in einem Onedriveordner und eine Freigabe für mehrere Damen in der Verwaltung, die parallel LIVE daran arbeiten können, wenn Sie Office-Online nutzen) TENOR: ich brauche Sicherheit, dass wenn ich mit dieser Excel arbeite, keiner aus Versehen einen Ordner mit Artikeldaten löscht. Auf dem Server kann ich das Löschen über NTFS-Berechtigung eigentlich auch ausschalten.
VBA programmer needed for writing an excel programme to organize and sort out large database dump. short project with quick turnaround time.
Need an Excel script/function that will do the following: 1: Copy a property address within the existing excel sheet 2: Open up a URL like [url removed, login to view] and paste the address in 3: Pull the property value back into a specified Excell cell 4: Pull the Parcel Number back into a specified cell 5. Pull the County and link to county site back into a specified cell 6. Pull the number of bedrooms, baths, square footage, lot size, year built back into a specified cell. Need Demographics: 1. go to [url removed, login to view] and pull in the following to specified cells: A: Crime B: income C: School ratings D: Population E: Unemployment
Creación de Macros con base en múltiples archivos de Excel para contabilidad / finanzas.
I need a power point macro expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
I need a power point macro expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
Programming Excel Macros/other programming/SQL Raw Data needs to be manipulated and re-populated to form a catalogue of SKUs for inventory.
Looking for a google script writer for a extensive project. Must be good with google script. I have a google spreadsheet and want to automate it to generate labels for printing based on the search criteria. Labels are mostly on pdf format, so it will be required to be uploaded through script to find the correct label and then print. Please use - "Google spreadsheet script" in your cover letter.
I want to get trained on Vba web scrapping. Can anyone trained me on that.
Se solicita FreeLancer para hacer cálculos básicos a un volumen alto de libros de Excel. Se trata de procesar varios libros con cálculos fijos para cada uno de ellos que se repetirán de uno a otro para luego guardar en formatos también especificados por nosotros. Este trabajo debe hacerse toda la semana para aproximadamente 180 libros. Las macros para el procesamiento automático de la data serán suministradas por nosotros, es cuestión de ejecutarlas de un libro a otro y verificar que los datos estén completos. Además, la data deberá ser descargada de forma remota a través de TeamViewer, de forma continua. El buen desempeño será premiado con contratación constante todas las semanas para la misma tarea. En la imagen adjunta se puede ver el diagrama de como deben ser procesados los daros y los documentos resultantes de cada descarga.
Bonus : up to $200 extra based on performance Hey guys , I need to analyze a group of values one by one and decide when to buy/sell . Below is the data file with around 11k values . Each value pair consists of 1 minute . [ask_price,bid_price] . Basically buy at the ask price and sell at the bid price. {buy low - sell high} . In the event that i'm selling and the values keep going down - i should assume a loss and sell then start buying. The one with the best algorithm wins . I will also award small prizes to those who made an effort and got good results [url removed, login to view]
a click to call function was set - it will open up skype to open up application to dial the number . - there will be a Skype record to record the conversation. I need to do a set up as such . -To have the skype voice record auto save in the google drive folder -The calls make via the click to call from the sheet is tag to that record . The data will be distribute to callers .. Eg Caller A will not be able to See caller B sheet But I will need to have a admin or master sheet where to be able to access all sheet by the way for import data or export data to the caller individually 1) The voice record will be save with a hyplink to the cell on sheet 2) a function to export a row of cell data to telegram with the voice clip hyperlink attached
I would like to extract data from bluestacks app 1) Install bluestacks 2) Install [url removed, login to view] 3) Use relevant programming language to extract data after logging in 4) Export to CSV If you have other means of extracting, i am open to suggestion
I would like to extract data from bluestacks app 1) Install bluestacks 2) Install [url removed, login to view] 3) Use relevant programming language to extract data after logging in 4) Export to CSV If you have other means of extracting, i am open to suggestion
I would like to extract data from bluestacks app 1) Install bluestacks 2) Install [url removed, login to view] 3) Use relevant programming language to extract data after logging in 4) Export to CSV If you have other means of extracting, i am open to suggestion
Further develop a module that works with a maximum of small Excelbases and can create through a dashboard with functions what we need. Orderhandling, Stock, Invoices, Packinglists, Serialinumberlists and all what can be sourced out of the background data.
Further develop a module that works with a maximum of small Excelbases and can create through a dashboard with functions what we need. Orderhandling, Stock, Invoices, Packinglists, Serialinumberlists and all what can be sourced out of the background data.
I need a website that works similar to [url removed, login to view], but for the Australian Share Market.
Hello - I have an excel file on my virtual machine running Windows 2008, machine doesnt have excel, that updates every 15 minutes. The challenge I have is this machine doesnt have excel (something to do with volume licensing) and the file downloads in proected view so when I try to load this file to Power BI none of the data loads. I need a script to open this in excel online and save the file or another way to disable protected view without a) excel or b) the file opening prior to loading to Power BI. Or an inexpensive way to get excel on my Azure VM
I would like to find out the ranking of my advertisement from a search query 1) Id of the ad will be provided 2) URL of the search query will be provided 3) The script will then calculate based on its web scraping, the rank number of the ad and page number of the ad and export it