Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: alip43
  • Content: Threads
  • Order by date
  1. alip43

    Excel - Copy row based on a coloured cell

    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...
  2. alip43

    Lookup?

    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...
  3. alip43

    Alternative copy and paste transpose

    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...
  4. alip43

    Mail Merge and Macro Button

    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...
  5. alip43

    Auto fill 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...

Part and Inventory Search

Back
Top