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!

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

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

The question still remains, how is the data transferred from sheet 1 to
sheet 2? - are you using the Unique Values in Advanced Filter to select
what you Copy and Paste?

If so, then the Paste is overwriting the A cell that identified the D
cell.

ie in A19 was Smith W and you entered Y in D19
when you re-paste into column A there is no way to know where the 'Y'
in column D belongs (you have overwritten its owner-Name).

The easy solution is to enter the column D data into a table somewhere,
and do the vLookup into column D based on column A. If you change column
A then column D will also change.

Does this help?

--

Becks Wrote:
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




--
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

To transfer the data i am using the formula:
=INDEX(UNIQUEVALUES(SHEET1!$A$2:$A$100,1),ROWS($1: 1)) in column A and then
VLOOKUP IN B & C. Then in the blank cells i simply enter a "Y" when a bank
statement is received from that person. But as you say, data in the first
three columns change rows, so the "Y" entered, stays in the same row, against
a different name?

"Bryan Hessey" wrote:


The question still remains, how is the data transferred from sheet 1 to
sheet 2? - are you using the Unique Values in Advanced Filter to select
what you Copy and Paste?

If so, then the Paste is overwriting the A cell that identified the D
cell.

ie in A19 was Smith W and you entered Y in D19
when you re-paste into column A there is no way to know where the 'Y'
in column D belongs (you have overwritten its owner-Name).

The easy solution is to enter the column D data into a table somewhere,
and do the vLookup into column D based on column A. If you change column
A then column D will also change.

Does this help?

--

Becks Wrote:
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




--
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

Simple solution is to enter the Y's in a separate table, (or add them as
another column where the B and C data comes from) and continue the
vLookups.

Hope this helps

--

Becks Wrote:
To transfer the data i am using the formula:
=INDEX(UNIQUEVALUES(SHEET1!$A$2:$A$100,1),ROWS($1: 1)) in column A and
then
VLOOKUP IN B & C. Then in the blank cells i simply enter a "Y" when a
bank
statement is received from that person. But as you say, data in the
first
three columns change rows, so the "Y" entered, stays in the same row,
against
a different name?

"Bryan Hessey" wrote:


The question still remains, how is the data transferred from sheet 1
to
sheet 2? - are you using the Unique Values in Advanced Filter to
select
what you Copy and Paste?

If so, then the Paste is overwriting the A cell that identified the
D
cell.

ie in A19 was Smith W and you entered Y in D19
when you re-paste into column A there is no way to know where the
'Y'
in column D belongs (you have overwritten its owner-Name).

The easy solution is to enter the column D data into a table
somewhere,
and do the vLookup into column D based on column A. If you change
column
A then column D will also change.

Does this help?

--

Becks Wrote:
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




--
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




--
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