Questions by narikkadan

0 votes
1 answer

Two different fonts in one cell using excel vba

Apr 10, 2023 in Others • 2,159 views
0 votes
1 answer

Find specific term in a text string and return that term in the previous column

Apr 10, 2023 in Others • 1,313 views
0 votes
1 answer

Error Trying to Display The Names of All Excel Data Models in a Workbook

Apr 10, 2023 in Others • 1,419 views
0 votes
1 answer

Trying to import a CSV file and convert it into a table using VBA

Apr 10, 2023 in Others • 3,704 views
0 votes
1 answer

Use AutoFilter on the current visible data

Apr 10, 2023 in Others • 1,205 views
0 votes
1 answer

How to run Macro when press enter automatically and paste in different cell

Apr 10, 2023 in Others • 1,614 views
0 votes
1 answer

Not Like has no effect while looping an Array

Apr 10, 2023 in Others • 1,458 views
0 votes
1 answer

excel not reading some data

Apr 10, 2023 in Others • 1,341 views
0 votes
1 answer

Document changes in a graph excel

Apr 10, 2023 in Others • 1,370 views
0 votes
1 answer

How to split columns into two sub columns under their parent column using python in excel

Apr 7, 2023 in Others • 3,484 views
0 votes
1 answer

Combing data from multiple workbooks into a single master workbook using power query

Apr 7, 2023 in Others • 1,531 views
0 votes
1 answer

Excel VBA SQL Query on not saved Workbook

Apr 7, 2023 in Others • 1,532 views
0 votes
1 answer

Excel: importing data from another Excel file using VBA

Apr 7, 2023 in Others • 1,627 views
0 votes
1 answer

MS Excel Reordering letters in cell

Apr 7, 2023 in Others • 1,161 views
0 votes
1 answer

VBA - Split table rows based on a column value

Apr 7, 2023 in Others • 2,429 views
0 votes
1 answer

How to automatically assign a color to the maximum and minimum values in a set of selected cells in Excel?

Apr 7, 2023 in Others • 1,629 views
0 votes
1 answer

For loop to add up areas of openings excluding certain rows keeps returning #VALUE! error?

Apr 7, 2023 in Others • 1,421 views
0 votes
1 answer

Conditional Formatting not applying to all the cells in a given range

Apr 6, 2023 in Others • 1,503 views
0 votes
1 answer

How to read a dataframe from an excel sheet containing multiple tables?

Apr 4, 2023 in Others • 5,491 views
0 votes
1 answer

Error: AttributeError: 'str' object has no attribute 'row'

Apr 4, 2023 in Others • 4,624 views
0 votes
1 answer

Validation of postcodes in several countries

Apr 4, 2023 in Others • 1,214 views
0 votes
1 answer

Is there a way to have a Excel file attached to Visual C# project without the need of always having the correct directory location?

Apr 4, 2023 in Others • 3,108 views
0 votes
1 answer

Conditional formatting based on value with offset

Apr 4, 2023 in Others • 1,580 views
0 votes
1 answer

How to use COUNTIFS with multiple conditions and columns in Excel?

Apr 4, 2023 in Others • 1,577 views
0 votes
1 answer

Filter only certain columns in Excel Pivot Tables

Apr 4, 2023 in Others • 1,202 views
0 votes
1 answer

VBA Check to see if file is open before reopening a second file

Apr 4, 2023 in Others • 1,944 views
0 votes
1 answer

Check if cell found is in column "AP"

Apr 4, 2023 in Others • 1,521 views
0 votes
1 answer

File module issues with excel format

Apr 2, 2023 in Others • 1,426 views
0 votes
1 answer

Copying an existing row which also copies the checkbox with its code

Apr 2, 2023 in Others • 1,814 views
0 votes
1 answer

How to format calculated land size in excel

Apr 2, 2023 in Others • 2,089 views
0 votes
1 answer

Type the max number title in Excel

Apr 2, 2023 in Others • 1,225 views
0 votes
1 answer

Excel If Statement with Wildcards and Value Search

Apr 2, 2023 in Others • 1,254 views
0 votes
1 answer

How to pass a JSON-formatted string from Excel VBA as argument to a MySQL Store Procedure

Apr 2, 2023 in Others • 2,049 views
0 votes
1 answer

Tab creation failure using macro

Apr 2, 2023 in Others • 1,084 views
0 votes
1 answer

Modify table data in excel sheet by userform

Apr 2, 2023 in Others • 1,745 views
0 votes
1 answer

Vba range object single column autofill

Apr 2, 2023 in Others • 1,310 views
0 votes
1 answer

Copying a sheet with specific formatting from an excel file to a new output

Mar 31, 2023 in Others • 21,256 views
0 votes
1 answer

Macro throwing error when run from customized ribbon

Mar 31, 2023 in Others • 1,166 views
0 votes
1 answer

How to transpose data in an other tab in excel

Mar 31, 2023 in Others • 1,382 views
0 votes
1 answer

Run macro when on Worksheet change (i.e. changing sheets, not data within sheet)

Mar 31, 2023 in Others • 1,650 views
0 votes
1 answer

Code breaks after executing copy statement in VBA?

Mar 31, 2023 in Others • 1,490 views
0 votes
1 answer

Adjacent excel cells show same cell address on using =cell("address") formula.

Mar 31, 2023 in Others • 1,176 views
0 votes
1 answer

How to change date format from 201904 to Apr-19 in excel

Mar 31, 2023 in Others • 1,439 views
0 votes
1 answer

VBA - Applying border around the areas with value/text

Mar 31, 2023 in Others • 1,780 views
0 votes
1 answer

List Fridays and Saturdays in excel

Mar 31, 2023 in Others • 1,069 views
0 votes
1 answer

How to do the comand IF THEN in Excel

Mar 28, 2023 in Others • 1,453 views
0 votes
1 answer

Is it possible to create a universal hyperlink in excel for windows and mac without programming

Mar 28, 2023 in Others • 1,738 views
0 votes
1 answer

Why am I not being able to read the Excel sheet in my Jupyter Notebook

Mar 28, 2023 in Others • 1,790 views
0 votes
1 answer

How do I build a loop into this TimeStamp VBA Code?

Mar 28, 2023 in Others • 1,146 views
0 votes
1 answer

Is there a function in excel to automatically calculate age using date of birth?

Mar 28, 2023 in Others • 1,443 views
Page:
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.