Sorting problem

[Guest]

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]

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

--

 

[Guest]

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]

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

If so, then the Paste is overwriting the A cell that identified the
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 colum
A then column D will also change.

Does this help?

--

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

A1 B1 C1
Name Ref Date

This is then picked up on sheet2, and i have used the Uniquevalue
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
enter
other details for each person. However, when a new name is entered o
sheet1
it alters the row position of the names on sheet2, but the data entere
in
D:O doesn't move. Is there any way to make the entire row move?

Thanks

Becks

 

[Guest]

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]

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

Hope this helps

--

 

[Guest]

The layout of the sheets is spot on, so i don't really want to change that,
just wish i could somehow link the cells together. Looks like it's back to
the drawing board!

Thanks