Find and Paste (re-stated)

[gary]

Is there a way to search for a particular value in a cell
then paste a certain "block" of formulas in adjoining
cells?

For example:

if A1 contains '16', formulas get pasted in B1 thru G17.
if A19 contains '4', formulas get pasted in B19 thru G23.

The "paste" must be done automatically; it would be great
if the 'search' can also be done automatically (but
manually would be OK).

Mucho tacos,

Gary

(If you'd like an example of my actual worksheet, let me
now how I can attach it my posting)

 

[Frank Kabel]

Hi
I already asked you in your previous post for some example formulas.
Some additional questions:
- what do you mean with automatic: Do you want the formulas to change
if you change the values in column A?
- what do you mean with 'search'

On workaround would be to use formulas for example in B1:G17 like the
following:
=IF($A$1=16,your_formula,"")

 

[Bernie Deitrick]

Gary,

In cell B1, you could use a formula like
=IF(COLUMN()<=$A1+1, formula you want,"")

where you replace formula you want with your formula (without an equal sign)

Then copy that formula as far to the right and down as you ever expect to
need.

HTH,
Bernie
MS Excel MVP

 

[GARY]

See my original posting for example.


Yes, the formulas will vary depending on the value in the
cell in column A.

"AUTOMATIC" means without doing EDIT/FIND and PASTE
manually.

"Search" means "FIND".