nutritiouspig
Well-known Member
- Joined
- Jan 8, 2003
- Messages
- 615
What I am trying to do is come up with a way to have my macro check the contents of my data set for a name match. So for example: I might have five different names (Name_1),(Name_2),etc... I would like to have the macro execute into a sheet that contains that same name, as the sheet name.
Below is what my macro looks like (portion), right now it just goes to a sheet called UM_Output -- which i wont even need if i can have the macro check for a name match (which is in A12, like the example below).
A12 Example: Selected by: Agent Data: TEAM MGR Agent Data Value: Lastname, Firstname
Please let me know if more detail is needed. (And thanks for the help you have all given already!!!)
Cheers
S.
Sheets("UM_Output").Range("A1:K250").Delete
Sheets("UM_Data_Sheet").Range("A:A").Copy
Sheets("UM_Output").Select
Range("A1").Select
ActiveSheet.Paste
Columns("A:A").TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(23, 1), Array(48, 1), Array(52, 1), Array(55, 1), _
Array(61, 1))
Columns("D:E").NumberFormat = "General"
Below is what my macro looks like (portion), right now it just goes to a sheet called UM_Output -- which i wont even need if i can have the macro check for a name match (which is in A12, like the example below).
A12 Example: Selected by: Agent Data: TEAM MGR Agent Data Value: Lastname, Firstname
Please let me know if more detail is needed. (And thanks for the help you have all given already!!!)
Cheers
S.
Sheets("UM_Output").Range("A1:K250").Delete
Sheets("UM_Data_Sheet").Range("A:A").Copy
Sheets("UM_Output").Select
Range("A1").Select
ActiveSheet.Paste
Columns("A:A").TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(23, 1), Array(48, 1), Array(52, 1), Array(55, 1), _
Array(61, 1))
Columns("D:E").NumberFormat = "General"