$$Excel-Macros$$ Paste excel data into webform

2016-03-03 Thread N .williams
Hello I wonder if anyone can help an (overworked) teacher? I am trying to paste 150 class grades from an excel spreadsheet into a webform (I think the webform uses javascript) Attached are screenshot of the webform and the excel grades Is it possible run a macro that loops through each cell of th

$$Excel-Macros$$ How to replace "0"s with column header values

2015-09-19 Thread N .williams
Hello I would like to know if its possible to use a macro or forumula to replace every "0" with the header 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*

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

2015-09-19 Thread N .williams
Hello I would like to know if its possible to use a macro or forumula to replace every "0" with the header 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*

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

2015-09-02 Thread N .williams
Hello I've searched the forums and I can't find exactly what I need. I would like to know how to create new sheets based on a summary sheet. Copy students names: from columns A and B in data sheet to columns A and B in destination sheet1 Copy teacher's name: from column F in data sheet to cel