Need help with simple macro

H

hamilj03

Board Regular
Joined
Mar 16, 2009
Messages
55
I have a worksheet every week of varying lengths. I need a macro that will search the P column. If it finds the entry "Barrett,Courtney" in that column, I need it to change the A column of that same row to "SB/Resi". I imagine this can be simply done through Autofilter. I cannot figure out how to change the A column though. Thanks for your help.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
see if this works

Code: 
Sub test()
    For Each cell In Range(Cells(2, "P"), Cells(Cells(Rows.Count, "P").End(xlUp).Row, "P"))
        If cell.Value = "Barrett,Courtney" Then Cells(cell.Row, "A").Value = "SB/Resi"
    Next cell
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
VBA find non-matching value in a column
Replies
6
Views
747
Akuini
Akuini
D
  • Solved
Allowing ClearContents macro to run with error
Replies
5
Views
341
JackDanIce
JackDanIce
G
  • Solved
Macro Needed for Pivot Data Info.
Replies
6
Views
307
Fluff
Fluff
T
  • Solved
macro for formatting columns if values are greater than or equal to reference cells
Replies
7
Views
435
Peter_SSs
Peter_SSs
Y
  • Question
Macro needs to ignore unique tab name
Replies
7
Views
339
kevin9999
K

Forum statistics

Threads
1,215,341
Messages
6,124,391
Members
449,155
Latest member
ravioli44

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top