Copy and Paste problem needs help

**codepin** · 03-16-2009, 05:30 AM

I have a worksheet that contains many arrays and below is one array example. The array is A1:B5.
A1:A4 = percentage to split (eg: 0.1, 0.25 etc).
A5 = total of A1:A4 which is always 1 (=SUM(A1:A4)).
B5 = a number that the user need to input (eg: 50, 42, just any number).
B1:B4 = a formula that based on the percentage in A1:A4 to split the value in B5 (eg: formula in B1 is = A1*B5, in B2 is =A2*A5

Now I have hundreds of these arrays and they can have different array sizes. All I need is to copy only the number being input (those in B5) and paste them in another work sheet at exactly the same row reference, but different column reference (ie: I need to copy the cell in B5, B10, B14, B18, B33, D6, D11, D28 and paste into L5, L10, L14, L18, L33, M6, M11, M28).

How can I do it without copy and paste by each and every necessary cell, nor using macro / VB? My thanks in advance.

**Steve R** · 03-16-2009, 10:58 AM

Maybe i am not following you but why not type in cell
L5: =B5
L10: =B10
L14: =B14
L18: =B18
L33: =B33
M6: =D6
M11: =D11
M28: =D28

If they are on another sheet:
L5: ='Sheet1'!B5
and so on...

**codepin** · 03-17-2009, 10:21 PM

Originally Posted by Steve R

Maybe i am not following you but why not type in cell
L5: =B5
L10: =B10
L14: =B14
L18: =B18
L33: =B33
M6: =D6
M11: =D11
M28: =D28

If they are on another sheet:
L5: ='Sheet1'!B5
and so on...

Hi Steve R,

The sheet being copied and the sheet being pasted are in different files. And due to the nature of the info, there cannot be any link between these files. That's why I cannot put the formula you've listed into the target file, and have to use copy and paste instead.

Other than that, this copy and paste action will be done every week. If this month is copying the cell in B5, B10, B14, B18, B33, D6, D11, D28 and paste into L5, L10, L14, L18, L33, M6, M11, M28. Next month is likely to be coping the cell in C5, C10, C14, C18, C33, C6, C11, C28 and paste into M5, M10, M14, M18, M33, N6, N11, N28.

Any suggestions? Thanks in advance.