I want a way to convert excel files with 1000s of rows in column A to columns with 199 rows each. Sample files are attached. Ther'es an original and then what the result would be. I dont just need it for this file but for anytime I have a file that I need to convert like this. it can be all in excel or a small desktop program.
Il progetto consisterà nella esportazione di un contenuto di una pagina web. L'idea è quella di creare una codice VBA con delle regole per andare a estrapolare tutte le info necessarie dalla pagina. Vi allego qui un esempio di una pagina tipo. Solamente tramite delle credenziali è possibile accedere al sito quindi lo script dovrà essere implementato
I have a spreadsheet in excel that includes a macro simple (less than 50 lines of code) It mainly just moves stuff around I have recreated the spreadsheet in google sheets [login to view URL] but I can’t recreate the macro as I don’t know google apps script. Is this
...look, I also dont mind any layout as such as long as its simple to navigate - I trust your creative sense on that. It would be useful if you could incorporate a SEO and heat mapping tools. I don’t mind if it is made with Wordpress or HTML - I would consider both. Could you please provide me with a quote for a Wordpress and HTML? Thank you in advance
I have a column containing around 8000 of values The column describes a volume of alcohol bottle. The job is to parse the column and reduce to new columns: 1. Clean volume 2. is no. of bottles >1 For the cleaning regex there are several rules but it easier to show an example of the first 100 values, I attached an example of the parsing in the attached
Hello i need someone to to convert a file from and map out whats inside the file into a txt file thru a small simple app windows for the user just to select the file thru the window app user will get convert button and it will save that converted txt file into a folder on a desktop thank you
...have 5 columns, all sortable except second column for it would be to open row details. Each row details row should display several client-side customizable data sets (link, banners, banners embed code) extracted from MySQL database with the same ID as column 1 ID on it's own MySQL database table and column. Initial table should be loaded separately
Update the sign-up fields of a member press page to be two column instead of single column.
...sheet the links have hyperlinks automatic. I can remove then in Excel easily, but as soon as I paste them they become hyperlinks. How do I stop that in just the 1 column from happening? Also I need 2 blank rows every 5 rows. need to work on this now, anyone available? Can be done in Excel or google sheet, I just ideally would like to have it in Google
I need some help with API connectivity to 3 cryptocurrency exchanges. The following functionality in excel VBA needs to be created: 1. Get live price data (bid, ask, sizes of bid and ask) for selected crypto currencies - including depth of the market 2. Live price data collection and archivation. 3. Ability to access archived data. 4. Get cash
Hello, I require an excel expert to work on an existing excel sheet. You must have an excellent knowledge of Excel VBA, Macros and add-ins. The sheet already contains a lot of existing code which has some bugs which need to be fixed. The main part of the project is to create an add-in for mapping. This need to be dynamic. It needs to map the values
I need a VBA expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
I have an Excel tracker file from which two dashboards and graphs are to be generated. The tracker gets updated regularly. The dashboards and graphs are to be updated automatically. Time line to complete task would be 2 days. More details will be shared with short listed freelancers.
Hello, i am looking for someone who can scrape the DHL parcel information with MS Excel vba. The tracking number is given (Column A) and the tracking information (Column C:L) should be scraped from DHL page (Link in Column B) This should regulary be done for up to 50 tracking ids.
Saludos cordiales, estoy trabajando en un proyecto de una hoja de excel para uso de pro-formador y base de datos, para una micro-empresa en el área textil, he avanzado algo con la programación y la obtención de costos en de los productos, y necesito ayuda para darle el acabado de presentación y que esta calcule algunos parámetros, necesario para el
I need a Macro which can extract specific data from a word file and then generate a User form with drop down having the data from the word file and finally generate a word template with the values selected from the drop down in the user form
I need a 3D model dress like the images I attached, with variants on pocket, buttons, jacket vents and color. The va...jacket vents and color. The variants must be separated objects that can be hidden and showen without changing the quality of the model. Required project with all components, mapping and texturing, fast work. Software: Marvelous , Maya
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other and vice versa. I need a macro/script to align all DATES and TIMES and delete the mismatched values in sheets up to 250k lines efficiently. I have uploaded one examples of raw data that need to be aligned.
CJ Darcl Logistics Limited ( Detail co...India and operates through network of 200 branches, Gurgaon is our corporate office located in sector 44. we are looking for consultancy in two specific areas, competency mapping and JD"s KRA for all levels. Also we are looking for a consultant who has prior experience of working in logistics sector if possible
Map through an array of product objects and to sort products in locations and quantities for each location. Create a new array with objects organized to provide quantity counts for each location the product is in. Refer to the input array attached and the required output array attached. For each product name create a new object that provides a list of the locations and respective quantities.
Necesito un código en VBA que extraiga la data que está en la siguiente web: [login to view URL]:9d16c843bb5201b86696ba79f964adbf/stock/AAPL/financials y la coloque en una hoja llamada DATA. Adjunto el archivo excel donde debe realizarse el codigo. ---------------------------------------------
I want to map fitness gyms in metro Jakarta, Indonesia (gyms with weights, that have spin/boxing/zumba etc classes), anything that may compete with the major brands, Celebrity Fitness, Fitness First and Golds gyms. I have uploaded a file with "some" of the major gyms to get you to start, but I want someone to research say 50 additional gyms in Jakarta metro area. I then want a map of met...
I need to extract only the dimensions (like 12 x 24 x 36 inch) from our product description column in our product csv file, and have the dimensions put in a separate column. I am hoping I can get this done for $200. There are roughly 2,500 product in the csv file. I think this could be done with a script or something instead of manually, but I do
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
please only German programmers Das Projekt muss mir VBA in Excel realisiert werden. Die genaue Beschreibung ist im Anhang zu finden. Es sind zusätzlich Dateien nötig, um die Aufgabe zu erledigen. Dies ist ebenfalls im Anhang enthalten. Die Programmierung soll in der Datei "[login to view URL]" erfolgen. In dieser sind bereits Module und Code zur vorgesehenen
Try to code in VBA but it's not working. Trying to select on range of 2 original columns and match a new column and replace it with one of the original columns.