sending data from one sheet to another sheet

[ramminani]

New Microsoft Office Excel Worksheet.xlsx

the actual thing is like this..

in sheet 1 there a table containing the drop down list with few options. and in second sheet there a fields related to this field names.

now if i select the first option in dropdown list and enter the values then those values must sit in second sheet in first table.

second option i choose means it shout sit in second table of second sheet, like that


can anyone help me please

[Doc.AElstein]

...Hi again ramminani !!
. This requirement looks extremely similar to this one in your other Thread!!
http://www.excelforum.com/excel-form...ck-button.html
. Even the problem with the Drop Box I told you about is the same. Just The sheet has been very slightly changed. In the other Thread the sheet 2 does not tie up with that requirement but ties up better with this requirement!!
. You have muddled yourself up I expect with posting two threads with basically the same requiremnt!
. I suggest you reconsider exactly what you want, give the asked for required info, and stop posting duplicate Threads.
Alan