template wizard

  1. M

    Lookup/Template for automating weekly stats

    Hi, I have a spreadsheet full of information which I update on a weekly basis. What I am looking to do is to have a seperate sheet with the same column headers as my weekly summary but have just one row which lets me choose a date i.e. Week commencing x/x/xxxx then displays all of the input...
  2. T

    Template Wizard w/ Data Tracking

    I am currently using MS 2003 and downloaded the 2002 version of the Template Wizard with data Tracking for Excel. After download, I copy and pasted the TMPLWIZ.EXE file into C:\ProgramFiles\MicrosoftOffice\Office11\Library, but the add-in still is not showing up in the Add-In dialogue box in...
  3. B

    Transfer data from template

    Hello, I have a template which calculates in a certain column the averages of marks that students get on assignments. I have a macro which opens a number of sheets which are named according to the various tools for assessment that a teacher uses in class. All of the sheets use the same template...
  4. V

    Retrieve data from excel database

    Using the Template Wizard Add-in, I have created a form/template and have successfully sent inputs to an excel database. Is it possible to retrieve data from the database back into the template? The purpose of this would be to provide a copy of the details to each client.

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...