View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steved Steved is offline
external usenet poster
 
Posts: 519
Default Find And Replace

Hello from Steved

Find in column C and enter Data in Column B

Highlited Col C and then using the find dialog box I type in say 748, it
finds it on row 247, now I would like to type in Col B 5478, but I need to
close the dialog box then goto the left type in Col B 5478, then start the
whole process again. How anyone out their work out a nice formula or
application that will allow to find in Col C and then Type in Data to the
left in Col B. An example would be Col C 247 and Data to be typed in Col B
247 ie 5478.

Thankyou.