software

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:
gt; Hi, please help! On sheet 1 i have various info, some of which is fed
gt; through
gt; to sheet 2.
gt;
gt; Sheet 1) Sheet 2)
gt; | Data from sheet1 |
gt; A1 A2 A3 A1 A2
gt; A3
gt; A4
gt; Name Ref Date Name Ref Date
gt; Y/N
gt;
gt; I have used the unique values formula to pull the names etc from sheet
gt; 1 to
gt; sheet 2, this automatically puts them in alphabetical order (which is
gt; great).
gt; On sheet 2 i also add data in other columns, which is relevent to each
gt; person. When a new name is added on sheet 1, obviously the names move
gt; order
gt; on sheet 2, but the additional data added in other cells doesn't! Is
gt; it
gt; possible to make the whole row move? Please tell me it's easy!
gt;
gt; Thanks
gt;
gt; Becks
gt;
gt; P.s. I posted this question some time ago, but only got one reply,
gt; that
gt; didn't help, sorry for re-posting but i'm desperate!--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=538774Sorry, 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

quot;Bryan Hesseyquot; wrote:

gt;
gt; I guess I'm confused.
gt;
gt; When you say 'unique values formula to pull the names from sheet 1 to
gt; sheet 2', - if you are on sheet 1 isn't that an intended push?
gt;
gt; Do you Copy and Paste the 'unique' data from sheet 1 to sheet 2? - if
gt; not what means are you using to transfer from sheet 1 to sheet 2?
gt;
gt; If you are using Copy/Paste, are you pasting over the previous values
gt; in columns A to C ? - thereby removing the identifuer for the data in
gt; column D ?
gt;
gt; The display of sheet 1 sheet 2)
gt; A1 A2 A3 A1 A2 A3
gt; and on the next line A4
gt; with
gt; Name Ref Date Name Ref Date
gt; and on the next line
gt; Y/N
gt; is further confusing.
gt;
gt; In examples (and in the way most people use Excel)
gt; columns A1 B1 C1 D1 go across the page and
gt; Rows
gt; A1
gt; A2
gt; A3
gt; A4
gt; go down the page.
gt;
gt; Thus, I wonder if you could re-explain what you are trying to achieve.
gt;
gt; Cheers
gt;
gt; --
gt;
gt; Becks Wrote:
gt; gt; Hi, please help! On sheet 1 i have various info, some of which is fed
gt; gt; through
gt; gt; to sheet 2.
gt; gt;
gt; gt; Sheet 1) Sheet 2)
gt; gt; | Data from sheet1 |
gt; gt; A1 A2 A3 A1 A2
gt; gt; A3
gt; gt; A4
gt; gt; Name Ref Date Name Ref Date
gt; gt; Y/N
gt; gt;
gt; gt; I have used the unique values formula to pull the names etc from sheet
gt; gt; 1 to
gt; gt; sheet 2, this automatically puts them in alphabetical order (which is
gt; gt; great).
gt; gt; On sheet 2 i also add data in other columns, which is relevent to each
gt; gt; person. When a new name is added on sheet 1, obviously the names move
gt; gt; order
gt; gt; on sheet 2, but the additional data added in other cells doesn't! Is
gt; gt; it
gt; gt; possible to make the whole row move? Please tell me it's easy!
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Becks
gt; gt;
gt; gt; P.s. I posted this question some time ago, but only got one reply,
gt; gt; that
gt; gt; didn't help, sorry for re-posting but i'm desperate!
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=538774
gt;
gt;


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:
gt; Sorry, my brains are scrambled at mo trying to solve this! On sheet1 i
gt; have:
gt;
gt; A1 B1 C1
gt; Name Ref Date
gt;
gt; This is then picked up on sheet2, and i have used the Uniquevalues
gt; formula
gt; to bring the names through. The other info is picked using a look up
gt; formula. Also on sheet2, in columns D:O i have blank cells where i
gt; enter
gt; other details for each person. However, when a new name is entered on
gt; sheet1
gt; it alters the row position of the names on sheet2, but the data entered
gt; in
gt; D:O doesn't move. Is there any way to make the entire row move?
gt;
gt; Thanks
gt;
gt; Becks
gt;
gt; quot;Bryan Hesseyquot; wrote:
gt;
gt; gt;
gt; gt; I guess I'm confused.
gt; gt;
gt; gt; When you say 'unique values formula to pull the names from sheet 1
gt; to
gt; gt; sheet 2', - if you are on sheet 1 isn't that an intended push?
gt; gt;
gt; gt; Do you Copy and Paste the 'unique' data from sheet 1 to sheet 2? -
gt; if
gt; gt; not what means are you using to transfer from sheet 1 to sheet 2?
gt; gt;
gt; gt; If you are using Copy/Paste, are you pasting over the previous
gt; values
gt; gt; in columns A to C ? - thereby removing the identifuer for the data
gt; in
gt; gt; column D ?
gt; gt;
gt; gt; The display of sheet 1 sheet 2)
gt; gt; A1 A2 A3 A1 A2 A3
gt; gt; and on the next line A4
gt; gt; with
gt; gt; Name Ref Date Name Ref
gt; Date
gt; gt; and on the next line
gt; gt; Y/N
gt; gt; is further confusing.
gt; gt;
gt; gt; In examples (and in the way most people use Excel)
gt; gt; columns A1 B1 C1 D1 go across the page and
gt; gt; Rows
gt; gt; A1
gt; gt; A2
gt; gt; A3
gt; gt; A4
gt; gt; go down the page.
gt; gt;
gt; gt; Thus, I wonder if you could re-explain what you are trying to
gt; achieve.
gt; gt;
gt; gt; Cheers
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Becks Wrote:
gt; gt; gt; Hi, please help! On sheet 1 i have various info, some of which is
gt; fed
gt; gt; gt; through
gt; gt; gt; to sheet 2.
gt; gt; gt;
gt; gt; gt; Sheet 1) Sheet 2)
gt; gt; gt; | Data from sheet1 |
gt; gt; gt; A1 A2 A3 A1 A2
gt; gt; gt; A3
gt; gt; gt; A4
gt; gt; gt; Name Ref Date Name Ref
gt; Date
gt; gt; gt; Y/N
gt; gt; gt;
gt; gt; gt; I have used the unique values formula to pull the names etc from
gt; sheet
gt; gt; gt; 1 to
gt; gt; gt; sheet 2, this automatically puts them in alphabetical order (which
gt; is
gt; gt; gt; great).
gt; gt; gt; On sheet 2 i also add data in other columns, which is relevent to
gt; each
gt; gt; gt; person. When a new name is added on sheet 1, obviously the names
gt; move
gt; gt; gt; order
gt; gt; gt; on sheet 2, but the additional data added in other cells doesn't!
gt; Is
gt; gt; gt; it
gt; gt; gt; possible to make the whole row move? Please tell me it's easy!
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt; Becks
gt; gt; gt;
gt; gt; gt; P.s. I posted this question some time ago, but only got one
gt; reply,
gt; gt; gt; that
gt; gt; gt; didn't help, sorry for re-posting but i'm desperate!
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Bryan Hessey
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Bryan Hessey's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=538774
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=538774To 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 amp; C. Then in the blank cells i simply enter a quot;Yquot; when a bank
statement is received from that person. But as you say, data in the first
three columns change rows, so the quot;Yquot; entered, stays in the same row, against
a different name?

quot;Bryan Hesseyquot; wrote:

gt;
gt; The question still remains, how is the data transferred from sheet 1 to
gt; sheet 2? - are you using the Unique Values in Advanced Filter to select
gt; what you Copy and Paste?
gt;
gt; If so, then the Paste is overwriting the A cell that identified the D
gt; cell.
gt;
gt; ie in A19 was Smith W and you entered Y in D19
gt; when you re-paste into column A there is no way to know where the 'Y'
gt; in column D belongs (you have overwritten its owner-Name).
gt;
gt; The easy solution is to enter the column D data into a table somewhere,
gt; and do the vLookup into column D based on column A. If you change column
gt; A then column D will also change.
gt;
gt; Does this help?
gt;
gt; --
gt;
gt; Becks Wrote:
gt; gt; Sorry, my brains are scrambled at mo trying to solve this! On sheet1 i
gt; gt; have:
gt; gt;
gt; gt; A1 B1 C1
gt; gt; Name Ref Date
gt; gt;
gt; gt; This is then picked up on sheet2, and i have used the Uniquevalues
gt; gt; formula
gt; gt; to bring the names through. The other info is picked using a look up
gt; gt; formula. Also on sheet2, in columns D:O i have blank cells where i
gt; gt; enter
gt; gt; other details for each person. However, when a new name is entered on
gt; gt; sheet1
gt; gt; it alters the row position of the names on sheet2, but the data entered
gt; gt; in
gt; gt; D:O doesn't move. Is there any way to make the entire row move?
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Becks
gt; gt;
gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; I guess I'm confused.
gt; gt; gt;
gt; gt; gt; When you say 'unique values formula to pull the names from sheet 1
gt; gt; to
gt; gt; gt; sheet 2', - if you are on sheet 1 isn't that an intended push?
gt; gt; gt;
gt; gt; gt; Do you Copy and Paste the 'unique' data from sheet 1 to sheet 2? -
gt; gt; if
gt; gt; gt; not what means are you using to transfer from sheet 1 to sheet 2?
gt; gt; gt;
gt; gt; gt; If you are using Copy/Paste, are you pasting over the previous
gt; gt; values
gt; gt; gt; in columns A to C ? - thereby removing the identifuer for the data
gt; gt; in
gt; gt; gt; column D ?
gt; gt; gt;
gt; gt; gt; The display of sheet 1 sheet 2)
gt; gt; gt; A1 A2 A3 A1 A2 A3
gt; gt; gt; and on the next line A4
gt; gt; gt; with
gt; gt; gt; Name Ref Date Name Ref
gt; gt; Date
gt; gt; gt; and on the next line
gt; gt; gt; Y/N
gt; gt; gt; is further confusing.
gt; gt; gt;
gt; gt; gt; In examples (and in the way most people use Excel)
gt; gt; gt; columns A1 B1 C1 D1 go across the page and
gt; gt; gt; Rows
gt; gt; gt; A1
gt; gt; gt; A2
gt; gt; gt; A3
gt; gt; gt; A4
gt; gt; gt; go down the page.
gt; gt; gt;
gt; gt; gt; Thus, I wonder if you could re-explain what you are trying to
gt; gt; achieve.
gt; gt; gt;
gt; gt; gt; Cheers
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Becks Wrote:
gt; gt; gt; gt; Hi, please help! On sheet 1 i have various info, some of which is
gt; gt; fed
gt; gt; gt; gt; through
gt; gt; gt; gt; to sheet 2.
gt; gt; gt; gt;
gt; gt; gt; gt; Sheet 1) Sheet 2)
gt; gt; gt; gt; | Data from sheet1 |
gt; gt; gt; gt; A1 A2 A3 A1 A2
gt; gt; gt; gt; A3
gt; gt; gt; gt; A4
gt; gt; gt; gt; Name Ref Date Name Ref
gt; gt; Date
gt; gt; gt; gt; Y/N
gt; gt; gt; gt;
gt; gt; gt; gt; I have used the unique values formula to pull the names etc from
gt; gt; sheet
gt; gt; gt; gt; 1 to
gt; gt; gt; gt; sheet 2, this automatically puts them in alphabetical order (which
gt; gt; is
gt; gt; gt; gt; great).
gt; gt; gt; gt; On sheet 2 i also add data in other columns, which is relevent to
gt; gt; each
gt; gt; gt; gt; person. When a new name is added on sheet 1, obviously the names
gt; gt; move
gt; gt; gt; gt; order
gt; gt; gt; gt; on sheet 2, but the additional data added in other cells doesn't!
gt; gt; Is
gt; gt; gt; gt; it
gt; gt; gt; gt; possible to make the whole row move? Please tell me it's easy!
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks
gt; gt; gt; gt;
gt; gt; gt; gt; Becks
gt; gt; gt; gt;
gt; gt; gt; gt; P.s. I posted this question some time ago, but only got one
gt; gt; reply,
gt; gt; gt; gt; that
gt; gt; gt; gt; didn't help, sorry for re-posting but i'm desperate!
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Bryan Hessey
gt; gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; gt; Bryan Hessey's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; gt; View this thread:
gt; gt; www.excelforum.com/showthread...hreadid=538774
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=538774
gt;
gt;


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:
gt; To transfer the data i am using the formula:
gt; =INDEX(UNIQUEVALUES(SHEET1!$A$2:$A$100,1),ROWS($1: 1)) in column A and
gt; then
gt; VLOOKUP IN B amp; C. Then in the blank cells i simply enter a quot;Yquot; when a
gt; bank
gt; statement is received from that person. But as you say, data in the
gt; first
gt; three columns change rows, so the quot;Yquot; entered, stays in the same row,
gt; against
gt; a different name?
gt;
gt; quot;Bryan Hesseyquot; wrote:
gt;
gt; gt;
gt; gt; The question still remains, how is the data transferred from sheet 1
gt; to
gt; gt; sheet 2? - are you using the Unique Values in Advanced Filter to
gt; select
gt; gt; what you Copy and Paste?
gt; gt;
gt; gt; If so, then the Paste is overwriting the A cell that identified the
gt; D
gt; gt; cell.
gt; gt;
gt; gt; ie in A19 was Smith W and you entered Y in D19
gt; gt; when you re-paste into column A there is no way to know where the
gt; 'Y'
gt; gt; in column D belongs (you have overwritten its owner-Name).
gt; gt;
gt; gt; The easy solution is to enter the column D data into a table
gt; somewhere,
gt; gt; and do the vLookup into column D based on column A. If you change
gt; column
gt; gt; A then column D will also change.
gt; gt;
gt; gt; Does this help?
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Becks Wrote:
gt; gt; gt; Sorry, my brains are scrambled at mo trying to solve this! On
gt; sheet1 i
gt; gt; gt; have:
gt; gt; gt;
gt; gt; gt; A1 B1 C1
gt; gt; gt; Name Ref Date
gt; gt; gt;
gt; gt; gt; This is then picked up on sheet2, and i have used the Uniquevalues
gt; gt; gt; formula
gt; gt; gt; to bring the names through. The other info is picked using a look
gt; up
gt; gt; gt; formula. Also on sheet2, in columns D:O i have blank cells where
gt; i
gt; gt; gt; enter
gt; gt; gt; other details for each person. However, when a new name is entered
gt; on
gt; gt; gt; sheet1
gt; gt; gt; it alters the row position of the names on sheet2, but the data
gt; entered
gt; gt; gt; in
gt; gt; gt; D:O doesn't move. Is there any way to make the entire row move?
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt; Becks
gt; gt; gt;
gt; gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; I guess I'm confused.
gt; gt; gt; gt;
gt; gt; gt; gt; When you say 'unique values formula to pull the names from sheet
gt; 1
gt; gt; gt; to
gt; gt; gt; gt; sheet 2', - if you are on sheet 1 isn't that an intended push?
gt; gt; gt; gt;
gt; gt; gt; gt; Do you Copy and Paste the 'unique' data from sheet 1 to sheet 2?
gt; -
gt; gt; gt; if
gt; gt; gt; gt; not what means are you using to transfer from sheet 1 to sheet
gt; 2?
gt; gt; gt; gt;
gt; gt; gt; gt; If you are using Copy/Paste, are you pasting over the previous
gt; gt; gt; values
gt; gt; gt; gt; in columns A to C ? - thereby removing the identifuer for the
gt; data
gt; gt; gt; in
gt; gt; gt; gt; column D ?
gt; gt; gt; gt;
gt; gt; gt; gt; The display of sheet 1 sheet 2)
gt; gt; gt; gt; A1 A2 A3 A1 A2 A3
gt; gt; gt; gt; and on the next line A4
gt; gt; gt; gt; with
gt; gt; gt; gt; Name Ref Date Name Ref
gt; gt; gt; Date
gt; gt; gt; gt; and on the next line
gt; gt; gt; gt; Y/N
gt; gt; gt; gt; is further confusing.
gt; gt; gt; gt;
gt; gt; gt; gt; In examples (and in the way most people use Excel)
gt; gt; gt; gt; columns A1 B1 C1 D1 go across the page and
gt; gt; gt; gt; Rows
gt; gt; gt; gt; A1
gt; gt; gt; gt; A2
gt; gt; gt; gt; A3
gt; gt; gt; gt; A4
gt; gt; gt; gt; go down the page.
gt; gt; gt; gt;
gt; gt; gt; gt; Thus, I wonder if you could re-explain what you are trying to
gt; gt; gt; achieve.
gt; gt; gt; gt;
gt; gt; gt; gt; Cheers
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Becks Wrote:
gt; gt; gt; gt; gt; Hi, please help! On sheet 1 i have various info, some of which
gt; is
gt; gt; gt; fed
gt; gt; gt; gt; gt; through
gt; gt; gt; gt; gt; to sheet 2.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Sheet 1) Sheet 2)
gt; gt; gt; gt; gt; | Data from sheet1 |
gt; gt; gt; gt; gt; A1 A2 A3 A1 A2
gt; gt; gt; gt; gt; A3
gt; gt; gt; gt; gt; A4
gt; gt; gt; gt; gt; Name Ref Date Name Ref
gt; gt; gt; Date
gt; gt; gt; gt; gt; Y/N
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I have used the unique values formula to pull the names etc
gt; from
gt; gt; gt; sheet
gt; gt; gt; gt; gt; 1 to
gt; gt; gt; gt; gt; sheet 2, this automatically puts them in alphabetical order
gt; (which
gt; gt; gt; is
gt; gt; gt; gt; gt; great).
gt; gt; gt; gt; gt; On sheet 2 i also add data in other columns, which is relevent
gt; to
gt; gt; gt; each
gt; gt; gt; gt; gt; person. When a new name is added on sheet 1, obviously the
gt; names
gt; gt; gt; move
gt; gt; gt; gt; gt; order
gt; gt; gt; gt; gt; on sheet 2, but the additional data added in other cells
gt; doesn't!
gt; gt; gt; Is
gt; gt; gt; gt; gt; it
gt; gt; gt; gt; gt; possible to make the whole row move? Please tell me it's
gt; easy!
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thanks
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Becks
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; P.s. I posted this question some time ago, but only got one
gt; gt; gt; reply,
gt; gt; gt; gt; gt; that
gt; gt; gt; gt; gt; didn't help, sorry for re-posting but i'm desperate!
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Bryan Hessey
gt; gt; gt; gt;
gt; gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; gt; gt; Bryan Hessey's Profile:
gt; gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; gt; gt; View this thread:
gt; gt; gt; www.excelforum.com/showthread...hreadid=538774
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Bryan Hessey
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Bryan Hessey's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=538774
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=538774The 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

quot;Bryan Hesseyquot; wrote:

gt;
gt; Simple solution is to enter the Y's in a separate table, (or add them as
gt; another column where the B and C data comes from) and continue the
gt; vLookups.
gt;
gt; Hope this helps
gt;
gt; --
gt;
gt; Becks Wrote:
gt; gt; To transfer the data i am using the formula:
gt; gt; =INDEX(UNIQUEVALUES(SHEET1!$A$2:$A$100,1),ROWS($1: 1)) in column A and
gt; gt; then
gt; gt; VLOOKUP IN B amp; C. Then in the blank cells i simply enter a quot;Yquot; when a
gt; gt; bank
gt; gt; statement is received from that person. But as you say, data in the
gt; gt; first
gt; gt; three columns change rows, so the quot;Yquot; entered, stays in the same row,
gt; gt; against
gt; gt; a different name?
gt; gt;
gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; The question still remains, how is the data transferred from sheet 1
gt; gt; to
gt; gt; gt; sheet 2? - are you using the Unique Values in Advanced Filter to
gt; gt; select
gt; gt; gt; what you Copy and Paste?
gt; gt; gt;
gt; gt; gt; If so, then the Paste is overwriting the A cell that identified the
gt; gt; D
gt; gt; gt; cell.
gt; gt; gt;
gt; gt; gt; ie in A19 was Smith W and you entered Y in D19
gt; gt; gt; when you re-paste into column A there is no way to know where the
gt; gt; 'Y'
gt; gt; gt; in column D belongs (you have overwritten its owner-Name).
gt; gt; gt;
gt; gt; gt; The easy solution is to enter the column D data into a table
gt; gt; somewhere,
gt; gt; gt; and do the vLookup into column D based on column A. If you change
gt; gt; column
gt; gt; gt; A then column D will also change.
gt; gt; gt;
gt; gt; gt; Does this help?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Becks Wrote:
gt; gt; gt; gt; Sorry, my brains are scrambled at mo trying to solve this! On
gt; gt; sheet1 i
gt; gt; gt; gt; have:
gt; gt; gt; gt;
gt; gt; gt; gt; A1 B1 C1
gt; gt; gt; gt; Name Ref Date
gt; gt; gt; gt;
gt; gt; gt; gt; This is then picked up on sheet2, and i have used the Uniquevalues
gt; gt; gt; gt; formula
gt; gt; gt; gt; to bring the names through. The other info is picked using a look
gt; gt; up
gt; gt; gt; gt; formula. Also on sheet2, in columns D:O i have blank cells where
gt; gt; i
gt; gt; gt; gt; enter
gt; gt; gt; gt; other details for each person. However, when a new name is entered
gt; gt; on
gt; gt; gt; gt; sheet1
gt; gt; gt; gt; it alters the row position of the names on sheet2, but the data
gt; gt; entered
gt; gt; gt; gt; in
gt; gt; gt; gt; D:O doesn't move. Is there any way to make the entire row move?
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks
gt; gt; gt; gt;
gt; gt; gt; gt; Becks
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Bryan Hesseyquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I guess I'm confused.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; When you say 'unique values formula to pull the names from sheet
gt; gt; 1
gt; gt; gt; gt; to
gt; gt; gt; gt; gt; sheet 2', - if you are on sheet 1 isn't that an intended push?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Do you Copy and Paste the 'unique' data from sheet 1 to sheet 2?
gt; gt; -
gt; gt; gt; gt; if
gt; gt; gt; gt; gt; not what means are you using to transfer from sheet 1 to sheet
gt; gt; 2?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; If you are using Copy/Paste, are you pasting over the previous
gt; gt; gt; gt; values
gt; gt; gt; gt; gt; in columns A to C ? - thereby removing the identifuer for the
gt; gt; data
gt; gt; gt; gt; in
gt; gt; gt; gt; gt; column D ?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; The display of sheet 1 sheet 2)
gt; gt; gt; gt; gt; A1 A2 A3 A1 A2 A3
gt; gt; gt; gt; gt; and on the next line A4
gt; gt; gt; gt; gt; with
gt; gt; gt; gt; gt; Name Ref Date Name Ref
gt; gt; gt; gt; Date
gt; gt; gt; gt; gt; and on the next line
gt; gt; gt; gt; gt; Y/N
gt; gt; gt; gt; gt; is further confusing.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; In examples (and in the way most people use Excel)
gt; gt; gt; gt; gt; columns A1 B1 C1 D1 go across the page and
gt; gt; gt; gt; gt; Rows
gt; gt; gt; gt; gt; A1
gt; gt; gt; gt; gt; A2
gt; gt; gt; gt; gt; A3
gt; gt; gt; gt; gt; A4
gt; gt; gt; gt; gt; go down the page.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thus, I wonder if you could re-explain what you are trying to
gt; gt; gt; gt; achieve.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Cheers
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Becks Wrote:
gt; gt; gt; gt; gt; gt; Hi, please help! On sheet 1 i have various info, some of which
gt; gt; is
gt; gt; gt; gt; fed
gt; gt; gt; gt; gt; gt; through
gt; gt; gt; gt; gt; gt; to sheet 2.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Sheet 1) Sheet 2)
gt; gt; gt; gt; gt; gt; | Data from sheet1 |
gt; gt; gt; gt; gt; gt; A1 A2 A3 A1 A2
gt; gt; gt; gt; gt; gt; A3
gt; gt; gt; gt; gt; gt; A4
gt; gt; gt; gt; gt; gt; Name Ref Date Name Ref
gt; gt; gt; gt; Date
gt; gt; gt; gt; gt; gt; Y/N
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I have used the unique values formula to pull the names etc
gt; gt; from
gt; gt; gt; gt; sheet
gt; gt; gt; gt; gt; gt; 1 to
gt; gt; gt; gt; gt; gt; sheet 2, this automatically puts them in alphabetical order
gt; gt; (which
gt; gt; gt; gt; is
gt; gt; gt; gt; gt; gt; great).
gt; gt; gt; gt; gt; gt; On sheet 2 i also add data in other columns, which is relevent
gt; gt; to
gt; gt; gt; gt; each
gt; gt; gt; gt; gt; gt; person. When a new name is added on sheet 1, obviously the
gt; gt; names
gt; gt; gt; gt; move
gt; gt; gt; gt; gt; gt; order
gt; gt; gt; gt; gt; gt; on sheet 2, but the additional data added in other cells
gt; gt; doesn't!
gt; gt; gt; gt; Is
gt; gt; gt; gt; gt; gt; it
gt; gt; gt; gt; gt; gt; possible to make the whole row move? Please tell me it's
gt; gt; easy!
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Thanks
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Becks
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; P.s. I posted this question some time ago, but only got one
gt; gt; gt; gt; reply,
gt; gt; gt; gt; gt; gt; that
gt; gt; gt; gt; gt; gt; didn't help, sorry for re-posting but i'm desperate!
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; Bryan Hessey
gt; gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; gt; gt; gt; Bryan Hessey's Profile:
gt; gt; gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; gt; gt; gt; View this thread:
gt; gt; gt; gt; www.excelforum.com/showthread...hreadid=538774
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Bryan Hessey
gt; gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; gt; Bryan Hessey's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; gt; View this thread:
gt; gt; www.excelforum.com/showthread...hreadid=538774
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=538774
gt;
gt;