Simple database

[Tomos]

Blurgh! Excel is so annoying.

Right, I have 5 people working on an identical template document with
different columns.

eg:

Type Quantity Date
TR 4 Aug
TR 4 Sep
AD 3 Sep
TR 3 Sep

Simple stuff really.

Is there anyway of creating a master document that will pull all the
people's data under the columns for me to see with another column fo
which person the data has come from?

Type Quantity Date Person
TR 4 Aug 1
TR 4 Sep 1
AD 3 Sep 1
TR 3 Sep 2
TR 4 Aug 2
TR 4 Sep 2
AD 3 Sep 2
TR 3 Sep 5

'scuse the crappy layout.! :

 

[Anne Troy]

Perhaps these 2 macros will get you started:
http://vbaexpress.com/kb/getarticle.php?kb_id=221
http://vbaexpress.com/kb/getarticle.php?kb_id=151

************
Anne Troy
www.OfficeArticles.com