You are here:

Business Software

Recent Answers

2017-01-22 Excel - Delete rows if not a number:

Alan,    Sub DeleteNonNumberRows()  Dim r As Range  With ActiveSheet.UsedRange    Set r = .Rows(.Rows.Count).Resize(1, 1)  End With  Set r = Range("A2", r)  On Error Resume Next  r.SpecialCells(xlConstants

2017-01-22 Excel - Delete rows if not a number:

Alan,    Since you didn't say this was a vba request, then I won't suggest a vba approach.    One way would be to apply a Filter to your data from the right side of the home tab, second to last option

2017-01-19 Excel - Secondary drop down lists:

Bill,    If I was going to give you an answer, it would be the one you describe.     This approach is documented at Debra Dalgleish's site      http://www.contextures.com/tiptech.html    go to data validation

2017-01-19 Excel - Excel - Print 1 copy different:

Martin Cadwallader,    If you want all the copies to be identical except one copy to have additional information in one of the cells, you would need to print out twice.  One with 10 copies and no additional

2017-01-17 Excel - Copying CSV file into Excel sheet:

RICHARD    To copy the entire sheet instead of painting the cells you want to copy, and then copying them,  Just click on the box at the intersection of row 1 and column  A and then perform the copy paste

Categories

Browse Alphabetically

©2017 About.com. All rights reserved.