Possible to cut & paste in a formula?

  • Thread starter Thread starter Gene Holmes
  • Start date Start date
G

Gene Holmes

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?
 
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
 
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
 
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
 
Back
Top