Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find, Offset, Enter Number
I need some code that will go through an entire column and
find either of two names (Bob or Joe), go two columns over (same row), and enter the number 9. It would be nice if it could do this for all the worksheets as the name appears in the same column in each sheet. TIA! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find, Offset, Enter Number
something like this for the your range
for each ws in worksheets ws.select ' test without this line first for each c in range("b2:b200") if ucase(c)="BOB" or ucase(c)="JOE" then c.offset(,2)=9 next next -- Don Guillett SalesAid Software "BUBBA" wrote in message ... I need some code that will go through an entire column and find either of two names (Bob or Joe), go two columns over (same row), and enter the number 9. It would be nice if it could do this for all the worksheets as the name appears in the same column in each sheet. TIA! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find, Offset, Enter Number
This might get you started:
Range("A:A").Find("Joe", , , xlWhole).Offset(0, 2).Value = 9 Alan Beban BUBBA wrote: I need some code that will go through an entire column and find either of two names (Bob or Joe), go two columns over (same row), and enter the number 9. It would be nice if it could do this for all the worksheets as the name appears in the same column in each sheet. TIA! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why am I getting ### when I enter an accting number and hit enter | New Users to Excel | |||
Use of OFFSET and LOOKUP to find a value in a table | Excel Discussion (Misc queries) | |||
find max value in column and return offset of that value | Excel Discussion (Misc queries) | |||
Find then offset. | Excel Worksheet Functions | |||
Formula to find last value in a range & then offset | Excel Worksheet Functions |