View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default Need a different find and replace?

I am working on a VERY LONG spreadsheet. The only problem is when i populate
data (living document), it is all done manually.
Is there a way to Find something in column A if TRUE type "x" in column G.

Much like find and replace but not for ONE cell at a time. I need to look
for varialble in column 'A' and if it matches input goes in column G.
thanks for any help. I am starting to think Excel can't do this.
Thanks again.