You are here:
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
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
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
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
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

©2009 About.com, a part of The New York Times Company. All rights reserved.