• 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.

Drop down list with specific row

Naveen N

Member
Dear Reader,


I need a help. I have sheet “Name”, where I have team member names.

Also I have different sheet names with team member names like Naveen, ram and others.

If I am in Naveen sheet, I need column A to have Naveen in the drop down and similarly in other sheet Ram sheet should have RAM in the drop down.

Please suggest the possible way to do this.

Please find enclosed sample sheet.


Regards,

Naveen N
 

Attachments

  • Name_Dropdown.xlsx
    14.3 KB · Views: 5
I'm bit confused. Why do you need dropdown?

From your description, each sheet will have cell filled with single name only, which equals sheet name.

Just use formula below in cell A1 of each sheet.

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
 
I need the drop down since it used to fill timesheets.
we need the users to have there own name in the drop down.
 
Thanks Chihiro for the formula.
The formula works and extracts the sheet names.Do we have any way to the names from "Name sheet" to individual sheets.
 
For that, you'd need vba.
Something like below. It adds sheets with name from list and puts sheet name into cell A1 of each.

Code:
Sub AddSheetsName()
Dim lRow As Integer, i As Integer
Dim x As Variant

lRow = Sheets("Names").Cells(Rows.Count, 1).End(xlUp).Row
x = Sheets("Names").Range("A2:A" & lRow).Value

For i = LBound(x, 1) To UBound(x, 1)
    Sheets.Add(After:=Worksheets(Worksheets.Count)).Name = x(i, 1)
    Sheets(x(i, 1)).Cells(1, 1).Value = x(i, 1)
Next i

End Sub

See attached (click "Create Sheets" button).

Normally I'd recommend storing template for timesheet and using that sheet to create each named sheet.
 

Attachments

  • Name_Dropdown.xlsm
    20.7 KB · Views: 7
If you build template and upload, I can write you code. Time sheet template structure will largely depend on your HR/payroll needs.
 
Back
Top