Naresh Patel
asked on
Row Valus In Different Sheet
Hi Experts,
Need a help to create excel formula which populate row values of particular name in different sheet.
See attached, in sheet 1 column A is name column and values in subsequent columns & in sheet result cell A1 is matching criteria i.e. populate row values which have name Cell A1 in sheet 1. I know how to use filters but is there any way to achieve this by formula or worst case VBA.
Thanks
EE-Sample.xlsx
Need a help to create excel formula which populate row values of particular name in different sheet.
See attached, in sheet 1 column A is name column and values in subsequent columns & in sheet result cell A1 is matching criteria i.e. populate row values which have name Cell A1 in sheet 1. I know how to use filters but is there any way to achieve this by formula or worst case VBA.
Thanks
EE-Sample.xlsx
ASKER
1St statement is correct, I will manually put value in sheet result cell A1 and formula will display all data concerning to that cell.
Thanks
Thanks
Hi,
you could use MS Query
see example
to refresh Goto Data / Connections / Refresh All
Regards
Copy-of-EE-Sample.xlsx
you could use MS Query
see example
to refresh Goto Data / Connections / Refresh All
Regards
Copy-of-EE-Sample.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
ASKER
May I ask new question?
You are free to ask for sure
gowflow
gowflow
Did you want to ask something ?
gowflow
gowflow
ASKER
1) You want to be able to input manually Cell A1 and for the formulas to display all the data concerning this cell ?
2) If 1 not correct please state what you want exactly as far as input and what is required as formulas.
gowflow