Same here , link multiple excel sheets to update formulas , then update pivot charts and Excel Dashboard Automatically 👍
6 years ago
| 5
Use python to scrape details from specific Outlook emails. I'm currently doing this via Excel vba but think it can be done using python with more rules to treat certain emails differently. Another idea is using python to compare two different Excel files and display what is different. This is achievable using MS Access unmatched query via the query wizard.
6 years ago
| 5
Using consolidating multiple excel files and updating excel formulas, updating pivot tables and charts or dynamic charts
6 years ago
| 5
Little late to this: Standardizing column names across multiple excel files then combining into master sheet. Extracting values from specific cells across multiple sheets then combining Awesome channel!
6 years ago (edited) | 0
Whatever u upload brother I will watch Nd learn from ur knowledgeable videos
6 years ago
| 2
Delete duplicates based on info in one column, sort Z to A based on price, Create a Pivot Table that organizes a histogram and displays split groups based on numbered ranges like cost buckets. Going back to the data, split that newly sorted information based on the number of rows in a set numbered range onto three different tabs ordered by max cost descending.
6 years ago | 0
A form that you input data into multiple fields that creates a SKU and also a random generated number, with this data getting logged into specific places in a spreadsheet database
5 years ago | 0
Upload more Excel automation using python. Salute you for the good work.
6 years ago | 0
I do mapping. Search every barcode one by one from one excel file and search it in another excel file to find the entry name and paste it in outcome file. Wish it can be done with automate.
6 years ago
| 1
Hi Derrick, work with images and charts would be nice too. I work with excel reports everyday and in all of them I need to manipulate .png images and charts. So far I didn't find a proper guide that would help me to automate these tasks in Python. Maybe you could offer some help? Thanks and keep up the good work!
6 years ago
| 3
I would like to work on data with both open and connect to the same data source. With Excel I would like to use the Excel data model instead of just a flat sheet because of performance with larger files.
6 years ago
| 0
it would be awesome to enter information about the expenses and earnings of the day in google form and that it all go to an excel file and automaticaly make several reports
6 years ago | 0
Say you have some ancient printout that’s important and you lost the original excel file. So, scanning/photoing a printed excel document with lots of tables and measurements in weird things like inches and feet with single/double apostrophes, and recovering the actual csv
6 years ago
| 2
I run a crystal report every morning with a list of people who have arrest warrants. I save that list as an excel file so I can sort and filter. I’d like for python to do the entire workload for me. From creating the crystal report to formatting the spreadsheet. :)
6 years ago | 0
Collating data from multiple files. What would be the best approach to create one procedure that dynamically collates files with same data structure? So the same procedure for data collation activity.
6 years ago | 0
Hi Derrick, It would be great to see reading data from O365 excel into Pandas, and then making some changes for writing it back
5 years ago | 0
Can you make a tutorial on how to link specific data from one excel workbook to another using Python It's like I want the data from a raw excel workbook to get automatically updated in my excel dashboard so that I don't need to manually update data
6 years ago (edited)
| 2
Hi Derrick your videos are amazing brother. I have a video suggestion if you can do it. Can you do a video how to send emails in outlook using excel and extract the to, cc, subject, email body and attachment info from excel with a loop?
4 years ago | 0
Derrick Sherrill
Hey guys! I'm putting together a more structured playlist on Excel automation with python. What would be helpful? What do you do in Excel that you wish you could automate/replace?
6 years ago | [YT] | 67