Sorry that this Query was already posted but no one is able to give me the formula.. is it possible or not ?

[tv9_rohith]

In the Spreadsheet I have 2 Sheets.

1sheett for the Complete information about the Employee - Name, Location, Sex, Job Role, Salary.
2sheet only the required fields are - Name, Location, Job Role.

My query is :
If I enter data in the sheet 1 and I click the Command Button in Sheet 1 ( i.e., Generate Report Button ) then automatically the required column information should display in Sheet 2.
For example I have enterd 6 rows of data in sheet1 then all the 6 rows information should display in Sheet 2.

Previous Thread : Need help in writing formula for the query????

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=576047

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).