Paste Formula that skips a cell.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DeanH - 18 Mar 2008 15:57 GMT

I have a user that has received a file from a client that must not be altered
apart from the required edits.
The user has already discounted VLookup.
The list from the client has two rows per "site".
I need to paste a formula which looks to another file, this source file has
only one row per "site".
How can I paste the formula down the Client's site list but not have to edit
the thousands of pasted formula to align the cells. eg. the paste into say
client H4 is ok but client H6 should look to source H5, and client H5 will be
blank, Client H8 will look to source H6. How can we have the formula paste
"skip" the blank row?
Does this make sense?
Unfortuately

Reply to this Message

DeanH - 18 Mar 2008 16:00 GMT

Sorry for the premature cut-off.
Unfortunately I cannot get this work with any paste special option or
extracting the necessary column and work externally and patse back.
Any ideas?
DeanH

> I have a user that has received a file from a client that must not be altered
> apart from the required edits.
[quoted text clipped - 9 lines]
> Does this make sense?
> Unfortuately

Reply to this Message

GerryGerry - 18 Mar 2008 16:49 GMT

Try using the following. it will need adjusting so that the indirect part
starts at the right address. Use Excel help to see what parameters are
required.

=IF(MOD(ROW(),2)=0,INDIRECT(ADDRESS(ROW()/2,1,,,"sheet2")),"")

>I have a user that has received a file from a client that must not be
>altered
[quoted text clipped - 13 lines]
> Does this make sense?
> Unfortuately

Reply to this Message

Rate this thread: