Search results for query: *

Hi I have a spreadsheet (in office 7) which contains columns for:- names of students, yr, tutor group, various units. The units are coloured green, amber or red. I need to create a macro button that will look at the information on sheet 1 and copy the row onto sheet 3 if it meets the following...

Thanks Skip That works beautifully. Obviously when I copy down the formulas I get #N/A errors as there is no information in B:B (forename) or C:C (surname)yet. I would like these cells to appear blank until I add a name. I have tried to use conditional formatting, eg selecting all the cells and...

Can anyone help with the following problem please? I have created an excel worksheet from data exported from our management system which contains the following columns Name Surname Gender Year Reg etc I then have another blank worksheet in the same workbook that contains similar...

Works like a dream Skip - thanks so much I would never have been able to work it out. Regards Alison

Hi The reason I am trying to get the info like this is as follows:- In school we have a VLE. The people that run this VLE have instructions to enable us to take our students and classes out of SIMS (our student management system, along with our staff and classes and also a third .csv containing...

I have exported a report from our school management system which produces an excel spreadsheet of each child (UPN) and all the classes they attend. Unfortunately, I can only get this info out in the format below UPN Class N382212098028 10x/En2 10x/Ma1 10x/Pe2...

Hi Tony I'm not quite sure what has happened here. I have come back to this after the weekend and it is now working ok. The problem I had was that the form tick boxes needed protection to be filled in but the text fields needed to be unprotected to be filled in. Now when I protect the form...

Hi Tony I need this button as it runs the macro before any fields are filled in so that the check boxes are protected but the text boxes aren't. This is so staff do not have to keep protecting and unprotecting the form depending on which part of the form they are filling in.

Hi My form fields are still all there when the merge takes place it is just the button I have created and placed on the toolbar to run the macro which disappears. The merged report document can be used by enabling the forms toolbar and protecting the form then unprotecting it when the comment...

Thanks Tony I will give this a go. Skip - If you create a frame in Word and put in a check box form field - highlight it and click properties - the properties box that appears has the heading 'Check box form field options' - therefore I thought I was using the correct terminology - sorry if...

Hi Sorry I didn't explain myself very well. The 'Edit Individual Letter' is what appears down the right hand side of the screen when you do a mail merge in Word - I haven't written any code (in fact don't know anything really about vb)

I have created a template for a school report in Word (2003) which takes names, form, etc from an excel spreadsheet. The template then has form option boxes (excellent, good, etc) and below this comment and target boxes. I have found a macro which when pressed enables me to protect the option...

Sorry to be ungrateful but as these reports will be printed and sent out to pupils I didn't really want any buttons appearing on the form. Is there any way of doing this so that when they have typed a comment into one of the boxes and moved onto the next record the information in the memo box...

I have created a database for school reports. A form opens with records of students based on an underlying query. At the bottom of the form are memo fields (Attendance, Targets, etc). I would like to be able to type something into one of these memo boxes and the same information to appear in...