I have a problem which needs immed solution else I will be thrown out of the company ...
workbook, there are three sheets ..
First sheet has 2 sections.. row no. 1 to 10 contains data like .. Name, emp
id, team name, manager name , date of entry etc..
Section 2 of sheet 1, that is row no. 13 onwards contains
something like this --
Request Type (choose from 1-4)
Sheet 2 contains entries like this..
Request Type 1
Request Type 2
Request Type 3
Request Type 4
What I want is this --
When a user wants to create a new entry, he will enter his data in
section 1 of sheet 1, then he selects a type of request from section 2 of sheet 1, ( I have a dropdown for this, so that part
is set).. based on his selection, only the fields specific to that request type should be soon .. ( I dont know how this can
be done , but may be by hiding specific rows based on a dropdown selection ?? ) ..
When the user is finished
putting the data in respective fields of sheet 1, he clicks on a command button and that adds that records (along with data
from the section 1) as a record under that request type heading in sheet 2... if there are records already there, the rows
should be pushed down and the new record should be added on the top..
Hope I have made this as clear as
possible.. please help ASAP !!!
- If you cant get it right in the first time.. Sky-Diving is not for you !!