select all columns that contain specifc value in excel / googlesheets Problem Description: I have a table like this where Managers are listed in one row and all the months they are working are listed beneath them in the same column: Now I want to create a quick way to determine based on the month, … Read more
Excel moving shape with VBA Problem Description: I have a small Excel VBA problem that is beyond my current abilities. I have a range of 10 cells in column, like B1:B10 that will have a numeric value manually inserted. I also have a range of cells between L3:Z30, and somewhere in that area there are … Read more
VBA Highlight matching records Problem Description: I wanted to know how to apply conditional formatting rules using vba… I have the following dataset: As you can see the first column is the UNIQUE_ACCOUNT_NUMBER which consists usually in two matching records, followed by other columns showing data related to the account numbers. I want to apply … Read more
VBA Highlight matching records Problem Description: I wanted to know how to apply conditional formatting rules using vba… I have the following dataset: As you can see the first column is the UNIQUE_ACCOUNT_NUMBER which consists usually in two matching records, followed by other columns showing data related to the account numbers. I want to apply … Read more
Macro that sum different values between worksheets Problem Description: I’m new to the platform and I was wondering if there is a way to write in a "main" sheet the value of total characters for every first column in every sheet in the file ex: 1st sheet -> count of total characters -> write down … Read more
How to get Excel range for only filled Rows with Interop Excel? Problem Description: so I’ve read with Interop Excel from every Row the data. The problem is that some excel files have a lot of empty rows for example I have an file that has like 2000 rows but only the first 100 have … Read more
How to get Excel range for only filled Rows with Interop Excel? Problem Description: so I’ve read with Interop Excel from every Row the data. The problem is that some excel files have a lot of empty rows for example I have an file that has like 2000 rows but only the first 100 have … Read more
How to get Excel range for only filled Rows with Interop Excel? Problem Description: so I’ve read with Interop Excel from every Row the data. The problem is that some excel files have a lot of empty rows for example I have an file that has like 2000 rows but only the first 100 have … Read more
How to get Excel range for only filled Rows with Interop Excel? Problem Description: so I’ve read with Interop Excel from every Row the data. The problem is that some excel files have a lot of empty rows for example I have an file that has like 2000 rows but only the first 100 have … Read more
How to get Excel range for only filled Rows with Interop Excel? Problem Description: so I’ve read with Interop Excel from every Row the data. The problem is that some excel files have a lot of empty rows for example I have an file that has like 2000 rows but only the first 100 have … Read more