Re: exporting from a template into a monthly excel list database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jonathan Rynd (pqaf4hm02_at_atsneakemail.com.invalid)
Date: 02/13/04 

Date: Fri, 13 Feb 2004 15:59:12 GMT

"jake" <anonymous@discussions.microsoft.com> wrote in news:f6a001c3f1d3
$c15766f0$a001280a@phx.gbl:

> The difficulty I'm having is how to make the
> figures auto update into a seperate worksheet, with the
> same departments, but a weekly, monthly, a year-to-date
> and previous year columns.

It sounds like you really want a database program, rather than Excel.
Databases are much better at keeping historical records and choosing a
subset of the records to make a report on.

If you want do it in Excel you will have to mimic the functionality of a
database. You'll have to store your information like this:

Date Department Register Proceeds
2/13/04 Mens 1 $1097.68
2/13/04 Shoes 1 $898.21

etc.

If you want to enter the information on a template, you'll have to run a
macro to copy the information from the template into the table format I
mentioned above.

Then it is easy to use the database functions (Dfunctions) to get the
totals for weekly, monthly, and year-to-date. 

-- 
My email address has an extra @ (spell it out) and an extra invalid. 
Please remove them if you are not a spammer or list broker and want to 
reply.

Relevant Pages

  • Re: Mail merge data base problems
    ... I opened the .dot file, located the database. ... >> I can technically do anything to the template as long ... >See if that opens without problems. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Installer and Security
    ... you have to import the template into a security database before you ... I think SECEDIT will also import the template to a database too, ... unless you find and run the ADMINPAK.MSI file to install the extra MMCs]. ...
    (microsoft.public.win2000.security)
  • RE: Removing Blank Lines
    ... I have a setup for data clean up that you might find interesting. ... template database with a template table named tblCleanUp. ... and then import a template make-table query from ...
    (microsoft.public.access.formscoding)
  • Re: Control Word userform from Access
    ... The userform is controlled by a document registration database that uses ... linked to any replys or reports to keep them all together electronically. ... The registration is controlled from Word using the normal.dot template to ...
    (microsoft.public.word.vba.userforms)
  • Re: Control Word userform from Access
    ... > Word to supply custom templates of reports, letters, faxes etc for our ... As you can imagine this is a massive database. ... > create four charts, then on to a custom Word template ... >>before you called the userform and then, in the Initializeevent for the ...
    (microsoft.public.word.vba.userforms)