View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fluffypluisje fluffypluisje is offline
external usenet poster
 
Posts: 2
Default 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