Filling an array from one sheet to another
Hi,
Maybe somebody can help me with the following:
In the main sheet I've made an totall array which has to be filled from
other arrays standing on different sheets. Normaly that is not so difficult
by using (V)lookup-formulas but now I've to check 2 parameters from the
totall array and check this into an array standing on a different sheet with
the same lay-out but normally without all the amounts of check parameters.
For example:
Totall sheet:
after one hour after two hours
249WH 273L10
273L11
273R10
273R11
250RD 165L00
165R00
273L10
273L11
347PB 165L00
165R00
273L10
273L11
Example of an array on a different sheet named "after one hour" (made by
pivot table)
249WH 273L10 2
373R11 1
347PB 165L00 3
273L11 1
Example of an array on a different sheet named "after two hours" (made by
pivot table)
250RD 165L00 1
165R00 2
The values standing in the sheets "after one and 2 hours" has to be placed
in the totall sheet on the right spot.
Does anybody have a clue and can help me?
Thanks in advance.
Greet
|