I have two xlsx files that have multiple tabs. I need to compare values in each tab based on the tab name. (e.g. sheet1 in file1 needs to be compared with sheet
My goal is to add a icon to my toolbar in the quick access section. I wish this code could look at the file that is open, check if the file name contains or rat
I am trying to filter data in an excel worksheet, copy the filtered data only and move it to a new workbook. However, when I complete that step, I still have ac
I have a data structure (array) in Access - 6 columns and 10 rows. I'm trying to write to a range in Excel ie B3:G12. I'm getting tied up in loops, literally. F
A user is trying to open an excel file (.xlsx) (using Open in App instead of in browser) from their Sharepoint site, but system tries to open it up in MS Word i
In Microsoft Excel I am considering columns and cells to make specific sums in a calculated column, here's an image as an example where the column "G" is where
My goal is to put the current week number in the subject of outgoing mail. Below gives me this week + 1. I used to have 2016, now have 365. Problem is still her
I have a table that contains the file path, when the button is clicked the macro will display an image according to the url path. Here is my code (sourch : Link
Here it is answered how to change a single cell to text format. In a nutshell, I can do from openpyxl.styles import numbers cell.number_format = numbers.FORMAT
I'm looking for help with some VBA Excel code to do some merging of various sheets into a workbook and during the copy perform some worksheet functions (e.g.).
please, I am making my own dictionary and cant figure out how to pull translation definitions from google translate. My idea is that python will open my excel f
I have two tables on two sheets - let's say tblFruits1 and tblFruits2. Both have a column "Name". Apple - for example - exists on both lists. The lists might ha
I'm trying to merge these 2 codes together. I'm very new to VBA and I can't figure out if it is even possible. I know I can't have the number change before the
I am trying to figure out a formula that will count each row in a range, that contains any cell that is not empty. For example Item 1|Item 2|Item 3 Cat 1
Having UDF that extracts the words in sentences that have any colored character. The code is working but too slow. I tested the code at only 300 rows and it too
This block of code was working fine but I deleted some lines above Find() that broke it. Any ideas? Sub CopySheet() Dim TotalRow As Integer
I have 200 workbooks (1 per subject) with two sheets each. I was able to merge all sheets 1 and all sheets 2 in two separate data frames using the following scr
I have a vba script that copies and paste data from one workbook to the other. The data that is being pasted over are wrapped text. I need my vba script to take
How can I loop through a set of variables which are numbered consecutively (Bay1, Bay2, Bay3, etc.)? I have 10 variables and I need to examine
Given a .xlsx with many Groupings/Levels: Not expanded: Expanded: I am trying to iterate through the .xlsx and remove any rows, where Management Style is == a