Sample VLookup Solution for Mercury Renovations

David Badilotti — Mon, 10 Mar 2008 13:16:37 GMT

This file was created to demonstrate a way to consolidate multiple inventory tables into a single table on which a VLookup can be performed.

Method of Creating Workbooks with Daily Sheets

Roger Govier — Sun, 13 Jan 2008 15:59:00 GMT

This Macro will create a series of 12 files in the same Directory as this file is stored

It is recommended that you create a new empty folder, save a copy of this file in that folder, and then run the macro.

Each new file will be named Jan.xls through to Dec.xls

Within each file, there will be an individual sheet for eaach day of the Month, corresponding to the month of the filename.

The user will be prompted to enter the Year number, 2007, 2008 2009 tetc. At the begiining of the macro to ensure that

the correct number of sheets is created for Februray of that year.

Enter 0 in response to Year prompt if you want to cancel running the macro.

If files of the same name exists in the folder, you will be asked if you want to overwrite. YES will cause you to LOSE
your EXISTING file, No will skip that month and proceed to next month.

Excel 2003 Workbooks

Sample VLookup Solution for Mercury Renovations

Method of Creating Workbooks with Daily Sheets