Stuart Resnick - Excel - Business Software - Computing/Technology

About > AllExperts
	Search for

Main Menu

Login (Experts Only)

About Us · FAQ · Tell Friends About Us · Link To Us · Free Encyclopedia · Disclaimer · Tech Support

You are here: AllExperts > Computing/Technology > Business Software > Excel

Expert Profile: Stuart Resnick

Expertise: I can answer any question relating to MS Excel formulas, or to programming with vba (Visual Basic for Applications) in the Excel environment

Experience in the area
As a consultant, I've designed Excel tools since the 90s, working for the Federal Reserve Bank, AT&T, and (currently) Gap Inc.

	View Past Answers	View Detailed Ratings

Average Ratings
Prestige Points: 12050
Knowledge	9.92 Best of the best
Clarity of Response	9.83 Best of the best
Timeliness	9.94 Best of the best
Politeness	9.94 Best of the best
Number Of Questions (in Past 24 Hours)		3
Max Questions to be Asked (in 24 Hour period)		3
Total Questions (since joining AllExperts)		1481

Recent Reviews from Users

Knowl	Clarity	Time	Politeness	Date
10	10	9	10	07/19/08
10	10	10	10	07/17/08
10	10	10	10	07/16/08
10	10	10	10	07/15/08
10	10	10	10	07/14/08

User Comments

Many thanks. Works perfectly.
(Talib on 07/19/08)

Thanks, Stuart! It worked perfectly!
(Amanda on 07/17/08)

That was great, it worked.
(Divakar on 07/16/08)

Awesome!!!
(chilundu on 07/15/08)

Hi Stuart. Thank you so much. Your suggestions were clear and concise, and I've successfully integrated one of the formulas you sent. It's doin
(Al on 07/14/08)

View All Comments

	View Past Answers	View Detailed Ratings

Recent Answers from Stuart Resnick

2008-07-18 Cross checking two lists: Example: the lists on Sheet1 and Sheet2 both begin in cell A1. Any value in the Sheet1 list that's not on the Sheet2 list gets added to bottom of Sheet2 list: Sub copyFromColA() Dim copyFrom As...

2008-07-17 Adding vba code that checks user identity: For "identity," we'll use the Excel user name (the name that was entered by this user when the Excel application was installed on the computer). On a hidden page named UsersAllowed, create a list in...

2008-07-15 Disabling the Macro: Attach this VBA code to the ThisWorkbook object: Private Sub Workbook_BeforeClose(Cancel As Boolean) Cancel = True End Sub This disables any attempt to close the workbook. Then, in the VBA...

2008-07-14 hide rows using auto filter: Example: the column header for col G is in cell G26, with the data beginning in G27. You want to hide all rows for which the data in col G is zero. the code is: Sub hideZeros() Dim rngHeader As...

2008-07-13 Finding the only non-blank value in a range of cells: There are several options; here are a couple: 1) =AE34&AF34&AG34&AH34&AI34&AJ34&AK34&AL34&AM34&AN34&AO34&AP34&AQ34 2) Enter in cell AE35: =AD35&AE34 then copy that formula through AE35:AQ35...