Recent questions tagged excel

0 votes
1 answer

Iterate thru specific controls in a form using a loop

Jan 29, 2023 in Others by Kithuzzz
 • 38,000 points • 1,391 views
0 votes
1 answer

Repercute value on other sheet with "auto-detect"

Jan 29, 2023 in Others by Kithuzzz
 • 38,000 points • 1,313 views
0 votes
1 answer

How do I find top row visible on Sheet in Excel

Jan 29, 2023 in Others by Kithuzzz
 • 38,000 points • 1,599 views
0 votes
1 answer

Excel - How do I make rows that contain row headers into two columns

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 2,013 views
0 votes
1 answer

VBA How To Paste With Blank One Column Over?

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,581 views
0 votes
1 answer

Conditional Formating in Excel comparing dates between cells

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,823 views
0 votes
1 answer

How to remove data within a multi-line cell that comes after a few line breaks

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 2,328 views
0 votes
1 answer

Sum the total of a column in excel and paste the sum to a different workbook

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 2,386 views
0 votes
1 answer

Excel - return a value only if a condition is met via VBA

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 2,256 views
0 votes
1 answer

VBA Help to find a column based on header value and cupy it to an other worksheet

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 6,175 views
0 votes
1 answer

Excel formula returning multiple values according to two criterias

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,486 views
0 votes
1 answer

Automatically adding the date/time to a cell when another cell is updated AND clearing it when this cell is empty

Jan 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,932 views
0 votes
1 answer

Excel VBA: Trying to read all files in folder based on cell input and output to another cell

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 2,063 views
0 votes
1 answer

Multiple Select Case Statements in a Single Procedure

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,334 views
0 votes
1 answer

VBA, Loop through sheets not detecting parameters?

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,624 views
0 votes
1 answer

VBA Create and Rename Tables

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 2,746 views
0 votes
1 answer

Excel not closing using the COM in Python

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 5,501 views
0 votes
1 answer

VBA code help - Add a line for each missing date with the start and end date defined in a cell

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 2,983 views
0 votes
0 answers

VBA Excel MID Function Array

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,513 views
0 votes
1 answer

Output python dataframe to excel and create a new data_validation column in the exported excel sheet

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 3,224 views
0 votes
1 answer

Get inserted image to adjust the row height in Excel

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,665 views
0 votes
1 answer

Attributing the value of a cell based on another corresponding cell

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,731 views
0 votes
1 answer

What VBA Code to Hide Excel Quick Access Toolbar?

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 3,025 views
0 votes
1 answer

Changing code to adjust number of charts on each powerpoint slide VBA

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 2,085 views
0 votes
1 answer

Automating production of graphs using VBA

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 2,641 views
0 votes
1 answer

In =RTD(ProgID,Server,String1,[String2],...), passing array for String2, String3 and so on

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,649 views
0 votes
1 answer

Need a formula that will pull the specific value that matches a unique code from a set of data and produce another table of that specific data

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,785 views
0 votes
1 answer

Excel VBA If range.value = something then fills Columns G

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,512 views
0 votes
1 answer

Calculate 3 days back but skipping weekends

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,411 views
0 votes
1 answer

Excel Function to Exclude rows based on certain values

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 10,037 views
0 votes
1 answer

Calculate the rank based on the two or Three criteria

Jan 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,466 views
0 votes
1 answer

Split and group values in excel

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,803 views
0 votes
1 answer

Macro that deletes all asterisk signs from cells

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,689 views
0 votes
1 answer

How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 2,172 views
0 votes
1 answer

Excel VBA: Auto increment cell value after each printing

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 3,350 views
0 votes
1 answer

Public variable for captura path in vba excel

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,956 views
0 votes
1 answer

How to do multiple transpose in excel vba

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

VBA code to take some string components, search them inside a workbook and replace the components with the cell addresses found

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,574 views
0 votes
1 answer

Why is a Variant parameter changing its type on function call

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,451 views
0 votes
1 answer

Vlookup error when lookup value cell has been populated with formula

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,715 views
0 votes
1 answer

Excel, AVERAGEIFS, Date discrepancy

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points • 1,575 views
0 votes
1 answer

Is there an excel function to tell if a cell has a dependency?

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 2,317 views
0 votes
1 answer

Given a column of int64, make a REST call for each value, return results to a single table

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 1,643 views
0 votes
1 answer

Excel VBA - Subscript Out of Range Error (Run Time: Error 9)

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 3,206 views
0 votes
1 answer

Excel function to dynamically SUM UP data based on matching rows and columns

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 2,266 views
0 votes
1 answer

Excel VBA userform paste text in expanded format (not just to one cell)

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 2,021 views
0 votes
1 answer

Excel: Is it possible to reorder the data in 2 columns to match up if they have a certain number of characters / a string in common?

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 2,115 views
0 votes
1 answer

Iterator should return strings, not bytes (the file should be opened in text mode)

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 3,590 views
0 votes
1 answer

My VBA macro slows down dramatically with each use

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 1,998 views
0 votes
1 answer

VBA Change Cell colors based on value, and it can deal with single cell and multiple cells changes

Jan 21, 2023 in Others by Kithuzzz
 • 38,000 points • 2,228 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.