Hi
I want to be able to select a row in sheet one with existing data and have that row show in sheet two. Or I select a different row in sheet one then that row will be shown in sheet two. Possible?
Here is the kicker and I don’t think it’s possible.. to have the selected row from sheet one displayed vertically in sheet two.
Eg
Row in sheet one is first name, surname, address1, address2.. and so on.
On sheet two that row would be displayed as per a label..
First name and surname
Address1
Address2
And so on
Many thanks
Tony
I am trying to create a more user friendly and readable display from a large spreadsheet that is difficult to follow and remember cells that disappear when scrolling across. Hiding columns every time to do this is not an option.
—–
Tony
Lots of ways to do this. How do you want to select the row to display? Do you want to have a checkbox in a column in the table, and the row checked will be displayed in the second table? Since you don't seem to have an easy unique identifier for a row, like an ID number, then that may be best.
So you would have a checkbox in column A and check one row to be displayed in the other.
Then in the cells in table 2, you'd use LOOKUP to grab the values you want. So if cell A1 in table 2 is to be the first name, which is column B of table 1, you'd have:
=LOOKUP(TRUE,Table 1::A,Table 1::B)
So it looks for the value TRUE in column A, and then gives you the value from column B in that row.
Then do the same for A2, but grabbing a value column C of table 1 for the surname, etc.
Get the values of the columns you want, in any order you want them, in any cells at all in table 2.
Many thanks for such a swift reply. I will give it a go and let you know how I got on. I am pretty much a spreadsheet novice!
Success and many thanks, just what I needed! Keep up the good work.