Sorry, my brains are scrambled at mo trying to solve this! On sheet1 i have:

A1 B1 C1
Name Ref Date

This is then picked up on sheet2, and i have used the Uniquevalues formula
to bring the names through. The other info is picked using a look up
formula. Also on sheet2, in columns D:O i have blank cells where i enter
other details for each person. However, when a new name is entered on sheet1
it alters the row position of the names on sheet2, but the data entered in
D:O doesn't move. Is there any way to make the entire row move?

Thanks

Becks

"Bryan Hessey" wrote:


I guess I'm confused.

When you say 'unique values formula to pull the names from sheet 1 to
sheet 2', - if you are on sheet 1 isn't that an intended push?

Do you Copy and Paste the 'unique' data from sheet 1 to sheet 2? - if
not what means are you using to transfer from sheet 1 to sheet 2?

If you are using Copy/Paste, are you pasting over the previous values
in columns A to C ? - thereby removing the identifuer for the data in
column D ?

The display of sheet 1 sheet 2)
A1 A2 A3 A1 A2 A3
and on the next line A4
with
Name Ref Date Name Ref Date
and on the next line
Y/N
is further confusing.

In examples (and in the way most people use Excel)
columns A1 B1 C1 D1 go across the page and
Rows
A1
A2
A3
A4
go down the page.

Thus, I wonder if you could re-explain what you are trying to achieve.

Cheers

--

Becks Wrote:
Hi, please help! On sheet 1 i have various info, some of which is fed
through
to sheet 2.

Sheet 1) Sheet 2)
| Data from sheet1 |
A1 A2 A3 A1 A2
A3
A4
Name Ref Date Name Ref Date
Y/N

I have used the unique values formula to pull the names etc from sheet
1 to
sheet 2, this automatically puts them in alphabetical order (which is
great).
On sheet 2 i also add data in other columns, which is relevent to each
person. When a new name is added on sheet 1, obviously the names move
order
on sheet 2, but the additional data added in other cells doesn't! Is
it
possible to make the whole row move? Please tell me it's easy!

Thanks

Becks

P.s. I posted this question some time ago, but only got one reply,
that
didn't help, sorry for re-posting but i'm desperate!


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=538774