• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

if cell value match get tha cell row copy into new sheet with header row

J

jitendra6872

New Member
hi,

i have a file attached here
when i will click on the name from column A i get that all row data in new sheet with headers.or put a name on the top name cell respective cell automatically get data of row into new sheet .
plz look into this matter
this is the first sheet

NAME
name class chapter group
raju 2 care nomance
RAM 3 NON CLARE

what i am hoping for
in sheet 2

name class chapter group
RAM 3 NON CLARE
When i write ram instead of value
Row copy of ram into new sheet
 

Attachments

I believe you could accomplish your goal with the VLOOKUP formula. XL has a multitude of lookup formulas which work by giving a reference value, and then pull back corresponding information.
http://chandoo.org/excel-formulas/vlookup.shtml

You could type a value on Sheet2, and then have data pulled back via:
=VLOOKUP($A2,Sheet1!$A$1:$C$C100,COLUMN(),FALSE)
 
thank you luke,
but i want something different
when i write name in desired cell or make a separate cell automatically macro run which will search in the sheet 1 column A and when matched copy row into another sheet
 
Hi Jitendra,

Basically, say your data is on Sheet1 (Column A , B & C). You want you will type Name on Sheet2, say in column A, column B & column C should automatically filled with data. Is this so?

If YES, than follow the advise of @Luke M. You can also use INDEX formula to counter duplicate names.

If this is what you not want than please explain a bit more.

Regards,
 
hi Somendra,
thank u
i have many columns in sheet A not only A,B,C just for example i wrote 3 columns,
that is why i want complete row instead of column
 
tahnks Somendra and azumi,
but how do i copy the same formulae upto last column suppose i have 30 column ,if i copy paste this formula upto 30 column it changes its (lookup_value)
=VLOOKUP(A3,Table1,COLUMN(),0) when i copy to 6th column =VLOOKUP(F3,Table1,COLUMN(),0)
 
Please make some note regarding my suggestions:

1. The value you are bringing on the second sheets should be in same order as in your source table.
2. The formula is an array formula, so while entering select say 30 cells like B2:B31, press F2, enter the formula and press Ctrl+Shift+Enter.
3. Change the formula as below:
=VLOOKUP($A3,Table1,COLUMN(),0)

Regards,
 
thank you so much somendra you are rock.
somendra i have a another problem if u can do anything it would be so helpfull for me.
I have 4-5 workbooks in which a id is given in all the files with their technical database upto 25 columns ,I want to make a consolidated master file when i put id in master file column A and click any button ,column A of master file check id in one by one in 2-3 workbooks when id found get respective column data.

getting problem in description if possible we can chat personal
 
thans somendra,
but i have some creteria which matched then copy similar column details and further i want to print out the id which i want .I want to make a file which have my id and with my single id having other ids max 5 id's
and take my id data from my file and take other id data from other id files adn so on
when consolidate file made .in second sheet i want to print out in desired format where i put my id automatically respective id with my id comes and their select columns .

In the rd merge software ,it can do merge only
plz i Need if possible
thank you
 
You must log in or register to reply here.
Back
Top