Spreadsheet Q&A

Recent Answers

2009-11-23 Excel - Macro to enter and fix date:

Tony, You would need a macro to do this Right click on the sheet tab where you want this behavior. Select view code. In the resulting sheet module, paste in code like this Private Sub Worksheet_Change(ByVal

2009-11-23 Excel - Macro to move rows between worksheets:

Claudia, If Resolved is found in column M as your code seems to indicate, then this worked for me: Sub move_to_archive() Dim sh_from As Worksheet, sh_to As Worksheet Dim r As Range, col As Long

2009-11-23 Excel - Looping in Macro:

Khaled I am definatly not a expert in macros--but I do believe you can do what you want--I suggest you reask the question of another allexperts person and check the resumes for one with macro expertise

2009-11-22 Excel - Excel Spreadsheet:

Hopefully that's a different question - the original question seemed to relate to how to put the same names on the axis - it won't handle the 0 value, though I'd go with conditional formatting to set the

2009-11-22 Excel - Excel Spreadsheet:

if you are doing this as a one off, then you can copy the results and use edit, paste special to transpose - which will do it automatically. Otherwise you can use a formula to handle this =offset($A$1