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
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.
Manipulate cells to combine 2 databases into one. For example there are 3 columns for first name - middle name - last name and these need to be combined into full name. The comments section on one db runs over multiple columns and need to be combined into one. Date and Time column needs to be reformatted. ID column requires a prefix added so that there
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 ...called Completed and save the files in it. It will be a sub directory of the directory it was working in. The saved filename will be created from the date picker selected date and from data in the Cells B12 and D12 The new file name will be YYYYDDMM B12 D12
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
Hi, I have just created a Google Sheets Deliv...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 of Payment 3) Create a fill-able product list Thanks!
I am a genealogy buff and have a detailed listing of about 1600 interred persons at a cemetery that I'd like to have populated in a versatile, sortable Microsoft Excel spreadsheet. Headings would include Section, First Name, Middle Name, Nickname, Maiden Name, Last Name, Born, Died and Comments. Here's an example: Section A1 John Robert "Johnny"
...web-based spreadsheet that displays the real-time crypto prices. My needs are as following: It needs to import: EUR/KRW (exchange rate from any source) XRP/EUR (from [url removed, login to view]) XRP/KRW (from [url removed, login to view]) One cell containing XRP/EUR(Kraken) * EUR/KRW(exchange rate) One cell showing the percentage difference between
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
...Signal Strength details No Manual Network Setting Process , need auto set and auto log (2-4 Button ) Compatible with All Android version ( up to latest ). Compatible with All Android Mobiles ( up to latest ). With User Restriction & Aaccuracy. 2G/3G/4G serving and neighbor cells information measurement SPOT & NEIGHBOUR CGI. - Cell ID, LAC, MCC
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
I am looking to gather personal email addresses and names associated with emails of those who operate playlists on Spotify. On the Google sheet I will have a link to their spotify and names if I have already found them.
HI, Looking for a Excel expert that can create a restocking sheet, we have around 50 products. 1. 5 Employees 2. Need to put in restock of products where choosing what product and qtn and date. 3. Need to put in how many of each product and employee is taking each date. 4. Need to show current stock, and when to restock it, a limit. 5. Need