Populating column data in another sheet table

[laansesu]

One sheet is to enter the details of supplier, another is for challan printing where I'll have table where paticular supplier details should be populated when I select that supplier name

I'm just keep on asking my friends for about 2 days but couldnt able to get a solution

I've attached screenshots for your reference with sheet names sheet1, sheet2 where i'll keep on updating in sheet1 ex Karvy supplier has supplied 2 particulars and I also received one paricular from another supplier. So when I sleect karvy in sheet2, table in sheet2 has to be auto populated with karvy details.

[jaslake]

Hi laansesu

Welcome to the Forum!!!

Pictures are of little value.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

[laansesu]

Thanks for your reply. I dont have files with me right now. So if you can please prepare some columns, guess what could be the columns there for a fan stock supplier. If you have understood please do the needful else please go through the below requirements.

Generally, my stock executive will enter the stock received data in a sheet, will go to 2nd sheet just enter
the supplier name who has supplied their goods and just click enter button.

Technically, When supplier name is entered in sheet-2, it has to pick the column data of sheet-1 and has to paste it in the 2nd sheet (not all columns)

[laansesu]

Even I dont have any code, fed up wih using Functions

[jaslake]

Hi laansesu

You gotta be kidding...I should "guess" this???

you can please prepare some columns, guess what could be the columns there for a fan stock supplier

[laansesu]

Sorry bro!!! I dont have system with me and even dont have internet cafes at this place to prepare that data. Even you need columns to make a logic for me. This is the whole story behind using word "guess"

I just have only mobile to reply to your comments.

Really sorry for using that word.

[laansesu]

Hi,

Attached file which will be Crystal clear reg my requirement.

Step-1: I keep on enter the data that I get from a supplier (ex: Karvy, Spandana etc)

Step-2: I'll go to next sheet, If I select any of the supplier name (ex: Karvy as per the attached file), I should get the details (from 1st sheet)in the below table as per the column headers

Step-3: I'll click print button and just give it to the supplier who has brought the stock.

Technically, I need the data to display it in the table from the 1st sheet where I shouldn't have any duplicates (until unless I enter it) or none of the rows should be left blank, or if no of rows exceed table range, rows must be inserted dynamically.