Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help creating a simple macro
I need to make a macro that will go through a column of data and looks for a
specific word, when it finds that word it should copy the data from the cell directly to the right of it and make a list. Example (2 columns the word "employee" is in one and the name is in another) Start with this: Employee Name1 random stuff taking up lots of columns along the row random stuff taking up lots of columns along the row random stuff taking up lots of columns along the row Employee Name2 random stuff taking up lots of columns along the row Employee Name3 random stuff taking up lots of columns along the row random stuff taking up lots of columns along the row Employee Name4 random stuff taking up lots of columns along the row Employee Name5 Employee Name6 and I want just this: Name1 Name2 Name3 Name4 Name5 Name6 There is a varying number of rows between each employee so I don't think a formula would work. I want the macro to look for every instance of the word "employee" and give me just a list of names on a new sheet. Is this possible? Could this be done with a formula instead? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help creating a simple macro
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help creating a simple macro
this assumes the word employee is in column a and the name is in column b
and you want the results listed in column c Option Explicit Sub find_employee() Dim rng As Range Dim lastrow As Long Dim firstrow As Integer Dim cell As Range lastrow = Cells(Rows.Count, "A").End(xlUp).Row Set rng = Range("a1:a" & lastrow) firstrow = 1 For Each cell In rng.Cells If UCase(cell.Value) = "EMPLOYEE" Then Range("c" & firstrow).Value = cell.Offset(0, 1).Value firstrow = firstrow + 1 End If Next cell End Sub -- Gary "Dorn" wrote in message ... I need to make a macro that will go through a column of data and looks for a specific word, when it finds that word it should copy the data from the cell directly to the right of it and make a list. Example (2 columns the word "employee" is in one and the name is in another) Start with this: Employee Name1 random stuff taking up lots of columns along the row random stuff taking up lots of columns along the row random stuff taking up lots of columns along the row Employee Name2 random stuff taking up lots of columns along the row Employee Name3 random stuff taking up lots of columns along the row random stuff taking up lots of columns along the row Employee Name4 random stuff taking up lots of columns along the row Employee Name5 Employee Name6 and I want just this: Name1 Name2 Name3 Name4 Name5 Name6 There is a varying number of rows between each employee so I don't think a formula would work. I want the macro to look for every instance of the word "employee" and give me just a list of names on a new sheet. Is this possible? Could this be done with a formula instead? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a simple drawing using Excel | Excel Discussion (Misc queries) | |||
Need help creating a simple (?) SUM formula! | Excel Discussion (Misc queries) | |||
Creating a Simple macro | Excel Discussion (Misc queries) | |||
Creating a simple chart | Charts and Charting in Excel | |||
Creating what should be a simple macro | Excel Discussion (Misc queries) |