Prev: Simplest Question
Next: code to automating digital sign
From: unknown on 18 Jul 2008 01:24
I have 1200 excel 2003 worksheets in the following configuration

Town1 Town2 Town3 Town4
Date Date Date Date
Salesperson sales
n1 sales#
n2 sales#
n3 sales#
n4 sales#

I would like to put data in following. I have been doing manually, but it
is going to take months.

There are 500 salespersons. Towns about 200 are repeated in other charts
but on different dates over 50 years.

Salesperson Sales Date Town

From: unknown on 18 Jul 2008 01:29
Post did not format correctly. Columns town1 etc with row of date underneath
are columns to right of salesperson and sales columns and a row above row
with salesperson and sales.

"unknown" wrote:

> I have 1200 excel 2003 worksheets in the following configuration
>
> Town1 Town2 Town3 Town4
> Date Date Date Date
> Salesperson sales
> n1 sales#
> n2 sales#
> n3 sales#
> n4 sales#
>
> I would like to put data in following. I have been doing manually, but it
> is going to take months.
>
> There are 500 salespersons. Towns about 200 are repeated in other charts
> but on different dates over 50 years.
>
> Salesperson Sales Date Town
>
 | 
Pages: 1
Prev: Simplest Question
Next: code to automating digital sign