Summarized View of a Large Data - HELP (Row by Row)

[keychain]

Hi,

I have a large set of data in a sheet. Now, I wanted to view all the data in a particular row in a summarized manner in another sheet.

For example:
Let's say this is the data (I have data till column 'BF' in real)
1.JPG

In another sheet, I want the data to be summarized as:
2.JPG

And upon clicking the arrow, it should display the data in the next row and subsequently:
3.JPG

Seeking help on this
Thanks!

[FDibbins]

If the data is unique, try using vlookup() or Index/Match. If that doesnt work for you, upload a small sample wb, showing what you have and what you want.

[keychain]

Hi, thanks for the reply.
I have attached a WB FYR. have a loot at it.

Ideally, I want a "Next Button" sort of thing in the summary sheet, which at each click will give me details of each row (from the data sheet) in a summarized view as shown in the WB.

[FDibbins]

So what will your summary/extract be based on? what will be the key criteria for the search?

[keychain]

It's basically to have an overview of customer details before making a call to them.

[FDibbins]

OK but what will you enter to decide which data to pull?

[keychain]

That's why I need a button or something in the summary sheet which will go/give details of next row when clicked.
OR
We can use the serial number (1,2,3) as reference to pull details of that particular row.

[FDibbins]

OK thats what I needed - the serial number. Give me a few minutes

[keychain]

Sure Glad to wait!

[FDibbins]

Put this in C4...
=INDEX(Data!$A$2:$X$3,MATCH(Summary!$B$4,Data!$A$2:$A$3,0),MATCH(Summary!C3,Data!$A$1:$X$1,0))

Then copy across and down as needed.
(It may mess up your formatting)

[keychain]

You mean B4? or C4?
In summary sheet?

[FDibbins]

C4. The extract is based off whatever you enter in B4

[keychain]

Ok it changes only the "old partner no"
So I should work on and formulate all required cells..

[FDibbins]

If you copy that formula to all the cells you need to extract data for, it will pull in the required info

[keychain]

Yeah thanks a lot!
Now, I will have to refine it to my requirement.

[FDibbins]

To adjust for your range, change the BOLDED parts...
=INDEX(Data!$A$2:$X$3,MATCH(Summary!$B$4,Data!$A$2:$A$3,0),MATCH(Summary!C3,Data!$A$1:$X$1,0))
=INDEX(range-with-ALL-your-data-excluding-headings,MATCH(Summary!$B$4,range-with-S.No-in,0),MATCH(Summary!C3,Range-with-headings,0))

[keychain]

Okay got it, much helpful!

[FDibbins]

Happy to help and thanks for the feedback

[keychain]

Need further help on this..

I have added Remarks field in "Summary" sheet and have added data validation to it.
Now, the entered remarks should be reflected to that corresponding row in column Y of the data sheet. This should happen for all the data.

Is that possible?

[FDibbins]

seeing as the Remarks in Summary only pertain to that specific S.No that was selected in B4...and that will (probably?) change for the next S.No, there is no formula way pull the values into Data and have it stay there after the next number is selected.

In other words...
you select 1 in Summary
Summary table populates
you add a Remark to Summary (for 1)
that remark will be pulled to Data for SN 1, referencing what you selected in Summary D14

you then select 2 in Summary
Summary table populates
you add a Remark to Summary (for 2...remarks for 1 are replaced by remarks for 2)
that remark will be pulled to Data for SN 2, referencing what you selected in Summary D14...
BUT because there is now no longer a remarks for 1, SN 1 in Data will lose it's Remarks.

[keychain]

Okay so that is not possible I understand. Thanks again!

[AliGW]

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

[keychain]

Ok now I have a new query in this..

We take serial number as reference in summary sheet. Now, is there any possibility that the entire row gets highlighted?

Meaning... If I input 1 in 'serial no' cell of 'summary' sheet, that corresponding row in 'data' sheet has to be highlighted in some sorts.
Any hope on that?

[AliGW]

Please start a new thread with a suitable title and sample workbook attached for this new query. Thanks.