Excel General
For all general questions relating to Excel but not including VBA or formulas.
-
-
-
Look up cell value and return matching value from other sheet 2
- _triple_h_
-
- Replies
- 2
- Views
- 1.7k
2
-
-
-
-
Modifying list making macro to tie comment cells to proper list name cell. No rows. 1
- _Rapier_
-
- Replies
- 1
- Views
- 1.2k
1
-
-
-
-
to place picture into cell's background. not whole sheet 7
- _Rapier_
-
- Replies
- 7
- Views
- 2.1k
7
-
-
-
-
Transpose (switch) rows into rows. and columns into columns. 3
- _Rapier_
-
- Replies
- 3
- Views
- 1.7k
3
-
-
-
-
Join Variable With Number 1
- _NFio_
-
- Replies
- 1
- Views
- 1.9k
1
-
-
-
-
on error test inside a loop not testing each time through loop 4
- _NFio_
-
- Replies
- 4
- Views
- 7.8k
4
-
-
-
-
Assign cell with value chosen in a combobox 14
- _NFio_
-
- Replies
- 14
- Views
- 45k
14
-
-
-
-
RegEx - test formula in range 2
- _NFio_
-
- Replies
- 2
- Views
- 7.7k
2
-
-
-
-
Find unique values where criteria is met 5
- _NFio_
-
- Replies
- 5
- Views
- 6.9k
5
-
-
-
-
FormulaArray - interpolate variables 3
- _NFio_
-
- Replies
- 3
- Views
- 4.1k
3
-
-
-
-
Data Validation : Accumulating Data from a quastionare 17
- _NFio_
-
- Replies
- 17
- Views
- 7.7k
17
-
-
-
-
Mobile Number Filter ( Formula for begins with in data) 2
- _lovemeet_
-
- Replies
- 2
- Views
- 5.9k
2
-
-
-
-
Locate Cell Using its Values and then Copying the Adjacent Cell to Other Workbook 4
- _Janyce
-
- Replies
- 4
- Views
- 1.9k
4
-
-
-
-
Private Sub Worksheet_Change(ByVal Target As Range) issues with Protected Sheet 19
- _HG_
-
- Replies
- 19
- Views
- 8.4k
19
-
-
-
-
Delete Excel Rows Using Auto Filtering .SpecialCells(xlCellTypeVisible).EntireRow.Del 7
- _donald
-
- Replies
- 7
- Views
- 19k
7
-
-
-
-
Importing AS400 Reports and Appending Header Data 3
- _donald
-
- Replies
- 3
- Views
- 1.8k
3
-
-
-
-
Insert Pictures with varying naming convention from a list of a specific length VBA 3
- _donald
-
- Replies
- 3
- Views
- 2.4k
3
-
-
-
-
PLEASE HELP ME OUT Parent-Child hierarchy construction 14
- _disha_
-
- Replies
- 14
- Views
- 7.1k
14
-
-
-
-
Convert Jd Edwards Julian Dates 8
- _channelx_
-
- Replies
- 8
- Views
- 31k
8
-
-
-
-
Lock Unlock Cells Based On Format 3
- _channelx_
-
- Replies
- 3
- Views
- 5.3k
3
-