Possible to cut & paste in a formula?

Hi
one way: try the following: Enter the following formula in D14
=OFFSET($H$34,'Material'!F2-1,COLUMN()-4)
copy this to the right

--
Regards
Frank Kabel
Frankfurt, Germany

Gene Holmes wrote:
I am trying to do something that I can find no reference to!

1. I created a section on a sheet (reference area/list/table) with
prefilled data. Say 10 c wide x 10 r high .
2. Each row is numbered ascending.
3. Each row is "named" as a range.
4. I have another section of the workbook where I wish to "copy a
range" into. This section will be the same 10 x 10.

I wish to input a number into a cell, (1-10) this # would reference a
row of the data section. I need the program to "copy" the cell range
to the new location.

over simplified formula:

=IF('Material'!F2=1,"copy(H34:M34), paste 'Part Info'!D14:J14",
=IF('Material'!F2=2,"copy(H35:M35), paste 'Part Info'!D14:J14",
=IF('Material'!F2=3,"copy(H36:M36), paste 'Part Info'!D14:J14",
=IF('Material'!F2=4,"copy(H37:M37), paste 'Part Info'!D14:J14",

Am I missing something here?

I am not explaining my problem well.
Let's try again, lets say that in cell (A1) I choose to input the number 1,
by putting #1 in this cell I want the range contents of (H34:M34) to be
copied to 'Part Info'!D14:I14", or lets say that in cell (A1) I choose to
put the number 2, by putting #2 in this cell I want the range contents of
(H35:M35) to be copied to 'Part Info'!D14:I14. Basically I need a different
cell range copied to a specific range location based on which number I enter
into cell A1.

=IF A1= #1, "copy(H34:M34) cell content, and paste into
'Part Info'!D14:I14",
=IF A1= #2, "copy(H35:M35) cell content, and paste into
'Part Info'!D14:I14",
=IF A1= #3, "copy(H36:M36) cell content, and paste into
'Part Info'!D14:I14",
=IF A1= #4, "copy(H37:M37) cell content, and paste into
'Part Info'!D14:I14",

Thanks
Gene

"Frank Kabel" wrote in message
...
Hi
one way: try the following: Enter the following formula in D14
=OFFSET($H$34,'Material'!F2-1,COLUMN()-4)
copy this to the right

--
Regards
Frank Kabel
Frankfurt, Germany

Gene Holmes wrote:
I am trying to do something that I can find no reference to!

1. I created a section on a sheet (reference area/list/table) with
prefilled data. Say 10 c wide x 10 r high .
2. Each row is numbered ascending.
3. Each row is "named" as a range.
4. I have another section of the workbook where I wish to "copy a
range" into. This section will be the same 10 x 10.

I wish to input a number into a cell, (1-10) this # would reference a
row of the data section. I need the program to "copy" the cell range
to the new location.

over simplified formula:

=IF('Material'!A1=1,"copy(H34:M34), paste 'Part Info'!D14:J14",
=IF('Material'!A1=2,"copy(H35:M35), paste 'Part Info'!D14:J14",
=IF('Material'!A1=3,"copy(H36:M36), paste 'Part Info'!D14:J14",
=IF('Material'!A1=4,"copy(H37:M37), paste 'Part Info'!D14:J14",

Am I missing something here?

Hi Gene
this is what the formula achieves. Though it's not a copy but a dynamic
link based on your cell entry in A1 (or F2 in my previous example). If
you want a real copy (and not formulas) this would require VBA. But
depending on what you want to do with the date the previous formula
should work

--
Regards
Frank Kabel
Frankfurt, Germany

G Holmes wrote:
I am not explaining my problem well.
Let's try again, lets say that in cell (A1) I choose to input the
number 1, by putting #1 in this cell I want the range contents of
(H34:M34) to be copied to 'Part Info'!D14:I14", or lets say that in
cell (A1) I choose to put the number 2, by putting #2 in this cell I
want the range contents of (H35:M35) to be copied to 'Part
Info'!D14:I14. Basically I need a different cell range copied to a
specific range location based on which number I enter into cell A1.

=IF A1= #1, "copy(H34:M34) cell content, and paste
into 'Part Info'!D14:I14",
=IF A1= #2, "copy(H35:M35) cell content, and paste
into 'Part Info'!D14:I14",
=IF A1= #3, "copy(H36:M36) cell content, and paste
into 'Part Info'!D14:I14",
=IF A1= #4, "copy(H37:M37) cell content, and paste
into 'Part Info'!D14:I14",

Thanks
Gene

"Frank Kabel" wrote in message
...
Hi
one way: try the following: Enter the following formula in D14
=OFFSET($H$34,'Material'!F2-1,COLUMN()-4)
copy this to the right

--
Regards
Frank Kabel
Frankfurt, Germany

Gene Holmes wrote:
I am trying to do something that I can find no reference to!

1. I created a section on a sheet (reference area/list/table)
with prefilled data. Say 10 c wide x 10 r high .
2. Each row is numbered ascending.
3. Each row is "named" as a range.
4. I have another section of the workbook where I wish to "copy
a
range" into. This section will be the same 10 x 10.

I wish to input a number into a cell, (1-10) this # would reference
a row of the data section. I need the program to "copy" the cell
range to the new location.

over simplified formula:

=IF('Material'!A1=1,"copy(H34:M34), paste 'Part Info'!D14:J14",
=IF('Material'!A1=2,"copy(H35:M35), paste 'Part Info'!D14:J14",
=IF('Material'!A1=3,"copy(H36:M36), paste 'Part Info'!D14:J14",
=IF('Material'!A1=4,"copy(H37:M37), paste 'Part Info'!D14:J14",

Am I missing something here?