Simple database

[Tomos]

Blurgh! Excel is so annoying.

Right, I have 5 people working on an identical template document with 3 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 5 people's data under the columns for me to see with another column for 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

"Tomos" <[email protected]> wrote in
message news:[email protected]...
>
> Blurgh! Excel is so annoying.
>
> Right, I have 5 people working on an identical template document with 3
> 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 5
> people's data under the columns for me to see with another column for
> 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.!
>
>
> --
> Tomos
> ------------------------------------------------------------------------
> Tomos's Profile:
> http://www.excelforum.com/member.php...o&userid=26581
> View this thread: http://www.excelforum.com/showthread...hreadid=398610
>

[Tomos]

LEGEND LEGEND LEGEND!

Thank you SO much . Spot on! Amazing!
Those are some damn spunky Macros.

Endless thanks!