Consolidating 3 spread sheets into one master spread sheet

**uday1969** · 06-13-2012, 04:59 PM

Hi Guru's
I have 3 separate spread sheets
First Spread sheet contains information of columns 6
1.Background job 2.Start Date 3.Start Time 4.End Date 5.End time 6.Duration in Seconds
Second Spread sheet contains
1.Background job 2. Steps (1 to 13) for job. 3.variant 4.user
Third Spread Sheet contains
1.Background job. 2. Module name 3. sender name 4. receiver name.

There are around 2500 background job names.

I need to consolidate these spread sheets into one spreads

**FDibbins** · 06-13-2012, 05:46 PM

ok this is probably way too simplistic, or i dont get what you are trying to do, but cant you just copy them all to a new workbook? or at least, copy 2 of them into 1?
or are you after something more than that? maybe if you could upload a sample of what you have, showing what you atre trying to do, it would help?

**uday1969** · 06-13-2012, 06:51 PM

Hi

I am looking for sample file data collection template consisting of 44 jobs for sheet one.
Similar way I need to work on 2591 jobs in sheet 2.
TBTCP file consists duplicates of steps - how do I eradicate duplicate by step number.

I need merge into one file.

Regards
Uday