Could I send you the worksheet? I think it wold be easier that way.

"Niek Otten" wrote:

> Hi Mike,
>
> In general, you should be able to get your formula to work "the other way
> around".
> Second option is to record a macro while you goal seek the first line and
> then change that to do the same for each line.
> If you can write your formula in VBA, I could post a Function which iterates
> that formula so you can enter a "goal seek" on each row.
>
> But first of all, what are your formulas and how do they relate to each
> other (IOW how did you Goal seek?)
>
> --
> Kind regards,
>
> Niek Otten
>
>
> "Mike" <Mike@discussions.microsoft.com> wrote in message
> news:0AD3CC50-BC21-4A4A-B1B7-E2A969C9F089@microsoft.com...
> > Is there a way to "copy" Goal Seek acroos multiple rows?
> >
> > Hourly Current New New
> > Rate Comp Rate Compensation
> > 16.00 727.27 15.55675 727.27
> > 16.00 727.27 15.55 727.00
> > 17.00 772.73 105.00
> > 15.26 693.75 105.00
> > 16.00 727.27 105.00
> > 16.50 750.00 105.00
> >
> > The cells under the column labled New Compensation has a different formula
> > than the cells under the column labled Current Comp. I want to calculate a
> > new rate so that the New Compensation would be equal to the Current Comp
> > by
> > changing the cells under the column labled New Rate.
> >
> > I have used Goal Seek in the first row. However this spreadsheet is
> > several
> > hundred lines long and useing Goal Seek is not practical. Is there a way
> > to
> > copy the goal seek funtion across multiple rows or is these a formula
> > which
> > could be written?
> >
> > Thanks.
> >
>
>
>