CastingDirector
New Member
- Joined
- Jun 10, 2014
- Messages
- 46
Hello,
I am holding out hope that you can help me. My workbook has several sheets (up to 25). Many (not all) of the sheets have dates as part of their tab name(s) ie. "Schedule on DATE" & Call "Sheet for DATE". The date is formatted (MM-DD-YYYY). I would like to insert text information in cell "E5" on the sheet that corresponds to the same dated sheet. Seems remarkably easy yet I really have done my research and cannot find the right configuration. I've tried the following with no luck:
My fear is that I will always be a newbee! This is going on years of trying to figure Excel out! Can you help?
I am holding out hope that you can help me. My workbook has several sheets (up to 25). Many (not all) of the sheets have dates as part of their tab name(s) ie. "Schedule on DATE" & Call "Sheet for DATE". The date is formatted (MM-DD-YYYY). I would like to insert text information in cell "E5" on the sheet that corresponds to the same dated sheet. Seems remarkably easy yet I really have done my research and cannot find the right configuration. I've tried the following with no luck:
Code:
Dim nDate As Date
Dim N As String
nDate = (Format(nDate, "MM-DD-YYYY"))
ActiveSheet.Name.value = ("*" & nDate)
For Each Sh In Worksheets
If Sh.Name Like "*" & nDate Then
Sheets(Sh.Name)("E5").value = TextBox5.value
End If
Next Sh
My fear is that I will always be a newbee! This is going on years of trying to figure Excel out! Can you help?