Re: $$Excel-Macros$$ Re: Replace cell value "0" to header cell

2015-10-04 Thread nyree
cell value and list each one by student eg Student B: Q107, Q108, Q110 Many thanks for your help Nyree English_Group *Q101* *Q102* *Q103* *Q104* *Q105* *Q106* *Q107* *Q108* *Q109* *Q110* *Student A * 1 1 1 1 1 1

Re: $$Excel-Macros$$ Re: Replace cell value "0" to header cell

2015-10-02 Thread nyree
r your time and help. Best wishes Nyree On 01-Oct-15 12:33 PM, Paul Schreiner wrote: absolutely! several ways. where do you want the output? This macro does what you SAY, but not necessarily what you WANT: Option Explicit Sub List_Student() Dim msg As String, R As Integer, C As Integer

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

2015-09-19 Thread nyree
Hello Abhishek That's pefect! Thank you so much for your quick response Regards Nyree On 19-Sep-15 2:20 PM, Abhishek Jain wrote: Please see attached HTH, Abhishek On Sat, Sep 19, 2015 at 5:31 PM, N .williams <mailto:nyree.willi...@gmail.com>> wrote: Hello I would l

Re: $$Excel-Macros$$ macro to loop through data sheet , fetch 8 rows at a time and put in new sheet

2015-09-03 Thread nyree
Hello Paul What can I say? Its perfect - exactly what I needed - THANK YOU SO MUCH ps it may seem easy for you! Thanks again for your help, I'm so grateful. Best regards Nyree On 03-Sep-15 2:34 PM, Paul Schreiner wrote: That's simple enough to do. (I know, if it's so simpl