using google apps script or anything you like i need to get links from Google Photos Albums - and sort everything by name like this [url removed, login to view] you put album link here and it give you all the links of videos inside the album i need something like this but that also sort the result by the file names so.. [url removed, login to view] links
VBA project, automating population of word documents (test sheets) from excel with multiple versions of office. Existing system struggles with different versions of Microsoft Word Object Library. Also needs to be easily expandable for new and different test sheets. Test sheets are a controlled document which sit on a server in a separate folder to
I would like to create a macro that consolidates the following; > modify page setup settings (macro active) > print worksheet to PDF and file name as per ...each worksheet. I would like to create a macro that consolidates the page setup and print to PDF for each worksheet and move to the next worksheet and so on until the entire workbook is printed.
Daily Time sheet database , required - main navigation menu , Team leader list - against each team leader Time sheet for sub employees with multiple locations of manhours. Archive menu to access old saved time sheets.
Wir sind in der Baubranche tätig und haben eine Kalkulations- sowie eine Angebotserstellungs- und Rechnungserstellungstabelle im Excel erstellt. Es gibt ein paar Details, die wir gerne ändern möchten. Hierzu sind VBA Kenntnisse erforderlich, die wir in der Firma nicht haben.
i keep track of my daily expenses on excel sheet. i would like to create a simple form, that has the following - Drop Down Cells (DATE - CATEGORY - SUBCATEGORY - CURRENCY) - OPEN cells for text (AMOUNT - NOTE) - then the button OKAY / SEND / ACCEPT Once i go through the drop downs, selecting date, and category ie. HOUSE, then sub, ie. LAUNDRY
Simple project. I need it to process all xls files in the directory, one by one. Directory is selectable the worksheet in all files is Sheet1 Select the date with datepicker format M/D/YYYY, this date goes in cell B8 Select week 1-5 are drop down selections. The 3 choices are Pending Holiday - When it saves the files it will create a new directory called Completed and save the f...
Although Excel training won’t avoid every possible error, someone who understands the risks and how to minimise them, is going to be far less likely to end up starring in the financial mishaps pages of the national newspapers than someone without essential Excel skills and with little appreciation of the issues involved. The most frequent and major
I need an excel file that pulls real-time pair data (cryptocurrency pairs, e.g. BCH/USD, ETH/USD, etc.) for all cryptocurrency pairs on Kraken, Binance, and GDAX. I want to use the excel spreadsheet to create real-time pricing graphs/metrics. I need to pull all data for each crypto pair, and have it load in a single workbook, but each exchange in a
Hi, I have just created a Google Sheets Delivery Note myself. The delivery note is very basic. However, it is quite inefficient as I need to input Name, Address, Tel etc on my own and it is time consuming. Is it possible for you to create a delivery order under Google Sheets that can auto-input: 1) Name, and contact from my Google Contact 2) Auto fill or create a drop-down for mode...
Preciso de um orçamento para a construção de um sistema WEB (preferencialmente) ou VBA (alternativamente). O sistema deverá ser acessado pela internet, porém deverá funcionar como se fosse uma intranet, permitindo somente o acesso de usuários logados com login/senha. O login poderá ser integrado com facebook/google/microsoft. O sist...
I am looking to be able to extract Google calendar information into Excel. In the code, I would like to specify the following: 1. Login information 2. From date 3. To Date The information I need back from the calendar is the following table: 1. Date 2. From Time 3. To Time (or duration) 4. Title 5. List of guests.
Need the workbook I am working on formatted as per the attached workbook.
vba/ macro auto create tab, dropdown and sheet based on data. i have excel file, i would like to create macro/vba to refresh/create tab, dropdown, sheet based on 1 tab called data1. let me know if i can call to make it eaier to explain
I shall provide in excel worksheet, data in English. A small API, just to take x1 row to google translate or deepli translate, change into the language requested and paste in front (2nd column) same row in excel. At the moment, I do 10-20 rows translation copy them back and continue doing it. Just need automation of this work. In the app, we