Recent questions tagged excel

0 votes
1 answer

Python - Generate PDF from created Excel workbook - cannot save pdf document

Apr 6, 2023 in Others by Kithuzzz
 • 38,000 points • 3,804 views
0 votes
1 answer

Plot multiple datasets on the same chart with VBA

Apr 6, 2023 in Others by Kithuzzz
 • 38,000 points • 2,326 views
0 votes
1 answer

Comparing worksheets from a directory of xlsx files

Apr 6, 2023 in Others by Kithuzzz
 • 38,000 points • 1,855 views
0 votes
1 answer

Click cell to generate dynamic table

Apr 6, 2023 in Others by Kithuzzz
 • 38,000 points • 1,386 views
0 votes
1 answer

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

Apr 4, 2023 in Others by narikkadan
 • 86,360 points • 6,022 views
0 votes
1 answer

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

Apr 4, 2023 in Others by narikkadan
 • 86,360 points • 5,018 views
0 votes
1 answer

Validation of postcodes in several countries

Apr 4, 2023 in Others by narikkadan
 • 86,360 points • 1,536 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 by narikkadan
 • 86,360 points • 3,572 views
0 votes
1 answer

Conditional formatting based on value with offset

Apr 4, 2023 in Others by narikkadan
 • 86,360 points • 1,973 views
0 votes
1 answer

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

Apr 4, 2023 in Others by narikkadan
 • 86,360 points • 1,947 views
0 votes
1 answer

Filter only certain columns in Excel Pivot Tables

Apr 4, 2023 in Others by narikkadan
 • 86,360 points • 1,548 views
0 votes
1 answer

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

Apr 4, 2023 in Others by narikkadan
 • 86,360 points • 2,291 views
0 votes
1 answer

Check if cell found is in column "AP"

Apr 4, 2023 in Others by narikkadan
 • 86,360 points • 1,846 views
0 votes
1 answer

Excel - allow result to change if value is greater than

Apr 3, 2023 in Others by Kithuzzz
 • 38,000 points • 1,422 views
0 votes
1 answer

Excel - FIND function (case-sensitive) ignores case?

Apr 3, 2023 in Others by Kithuzzz
 • 38,000 points • 1,970 views
0 votes
1 answer

Create dependable dropdown of unique items in vba

Apr 3, 2023 in Others by Kithuzzz
 • 38,000 points • 1,741 views
0 votes
1 answer

Field Wrong Calculations

Apr 3, 2023 in Others by Kithuzzz
 • 38,000 points • 1,744 views
0 votes
1 answer

Export Attachment from outlook to excel cells

Apr 3, 2023 in Others by Kithuzzz
 • 38,000 points • 1,724 views
0 votes
1 answer

Choosing a random text value from a list

Apr 3, 2023 in Others by Kithuzzz
 • 38,000 points • 1,437 views
0 votes
1 answer

How to get subscript into formulas text string

Apr 3, 2023 in Others by Kithuzzz
 • 38,000 points • 2,355 views
0 votes
1 answer

User form to print an array of sheets

Apr 3, 2023 in Others by Kithuzzz
 • 38,000 points • 1,388 views
0 votes
1 answer

Using Substitute or Replace to change specified characters to characters in another cell in a specific order Excel

Apr 3, 2023 in Others by Kithuzzz
 • 38,000 points • 1,787 views
0 votes
1 answer

File module issues with excel format

Apr 2, 2023 in Others by narikkadan
 • 86,360 points • 1,744 views
0 votes
1 answer

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

Apr 2, 2023 in Others by narikkadan
 • 86,360 points • 2,164 views
0 votes
1 answer

How to format calculated land size in excel

Apr 2, 2023 in Others by narikkadan
 • 86,360 points • 2,594 views
0 votes
1 answer

Type the max number title in Excel

Apr 2, 2023 in Others by narikkadan
 • 86,360 points • 1,490 views
0 votes
1 answer

Excel If Statement with Wildcards and Value Search

Apr 2, 2023 in Others by narikkadan
 • 86,360 points • 1,490 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 by narikkadan
 • 86,360 points • 2,448 views
0 votes
1 answer

Tab creation failure using macro

Apr 2, 2023 in Others by narikkadan
 • 86,360 points • 1,365 views
0 votes
1 answer

Modify table data in excel sheet by userform

Apr 2, 2023 in Others by narikkadan
 • 86,360 points • 2,070 views
0 votes
1 answer

Vba range object single column autofill

Apr 2, 2023 in Others by narikkadan
 • 86,360 points • 1,609 views
0 votes
1 answer

Conditional formatting on a calculation in excel

Apr 1, 2023 in Others by Kithuzzz
 • 38,000 points • 1,920 views
0 votes
1 answer

Automatically Moving Emails to Excel, Code works but I don't want the whole email body just a portion of it

Apr 1, 2023 in Others by Kithuzzz
 • 38,000 points • 1,805 views
0 votes
1 answer

How Do I Correct a ByRef Mismatch Error in VBA for Worksheet_Change Sub in Excel?

Apr 1, 2023 in Others by Kithuzzz
 • 38,000 points • 6,060 views
0 votes
1 answer

Excel Nested IF INDEX MATCH Function

Apr 1, 2023 in Others by Kithuzzz
 • 38,000 points • 2,202 views
0 votes
1 answer

Processing in vba

Apr 1, 2023 in Others by Kithuzzz
 • 38,000 points • 1,417 views
0 votes
1 answer

VBA - Insert Spilt Cell Value

Apr 1, 2023 in Others by Kithuzzz
 • 38,000 points • 1,347 views
0 votes
1 answer

Loops through Check Box in VBA

Apr 1, 2023 in Others by Kithuzzz
 • 38,000 points • 2,369 views
0 votes
1 answer

Global Collections

Apr 1, 2023 in Others by Kithuzzz
 • 38,000 points • 1,694 views
0 votes
1 answer

Stuck on a Query for a stock trading spreadsheet

Apr 1, 2023 in Others by Kithuzzz
 • 38,000 points • 1,365 views
0 votes
1 answer

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

Mar 31, 2023 in Others by narikkadan
 • 86,360 points • 25,343 views
0 votes
1 answer

Macro throwing error when run from customized ribbon

Mar 31, 2023 in Others by narikkadan
 • 86,360 points • 1,444 views
0 votes
1 answer

How to transpose data in an other tab in excel

Mar 31, 2023 in Others by narikkadan
 • 86,360 points • 1,655 views
0 votes
1 answer

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

Mar 31, 2023 in Others by narikkadan
 • 86,360 points • 2,088 views
0 votes
1 answer

Code breaks after executing copy statement in VBA?

Mar 31, 2023 in Others by narikkadan
 • 86,360 points • 1,788 views
0 votes
1 answer

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

Mar 31, 2023 in Others by narikkadan
 • 86,360 points • 1,527 views
0 votes
1 answer

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

Mar 31, 2023 in Others by narikkadan
 • 86,360 points • 1,795 views
0 votes
1 answer

VBA - Applying border around the areas with value/text

Mar 31, 2023 in Others by narikkadan
 • 86,360 points • 2,121 views
0 votes
1 answer

List Fridays and Saturdays in excel

Mar 31, 2023 in Others by narikkadan
 • 86,360 points • 1,363 views
0 votes
1 answer

A button in excel sheet does not work for the first time

Mar 30, 2023 in Others by Kithuzzz
 • 38,000 points • 1,759 views
Page:

Most popular tags

"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.