Hi ya,

I'm half way through trying to get Excel to behave a little like Access, as i don't have that package at work.

I need to assign a Sheet to each individual record (copying a master sheet as a blank).
Each time i add a Sheet (for a new record) i want it to auto-generate the sheetname with something like 001, 002...040, etc in sequence
the new sheet will have to be a copy of a master layout already created in the workbook, but with the sequential number it will effectively be allocating a reference number to that record (like access would in a database)

from there i then want it to auto-populate a row of information into the newly-created-and-correctly-referenced sheet from Sheet1, to give the new sheet a header of basic, specific information. this i can write a macro to do it, but i can't work out how to auto-generate a sheet reference.

after that i would then like to be able to filter a preview of ALL the sheets(records) depending on certain information within each sheet i.e Show all ACTIVE records

I've looked at a load of codes, but like other people, i'm struggling to get it to work.... should i be in Sheetcode, VBA, Module ....?

please help!