Solved: auto data entry based on a cell value

[vdeen]

hi,

could someone give me a code, to fill column b based on column C

I have got 4 active columns in a spread sheet

columnA: contains hyperlinks
Columnb: require code to auto data entry
columnc: cell address of text in column D which is obtained from another sheet

Column d: text

[anandbohra]

pl attach small workbook with the example of what u want to do

like if someone put say x in column c the value should be so & so in column b & other likewise.

better give it with example for clarity

[vdeen]

hi,

the file is attached.

My formula for column b in search results worksheet is

if range (E3:e6000) contains "C" then b3 value =ANZSIC Description else Primary Activities.

thanks

[anandbohra]

hi,

the file is attached.

My formula for column b in search results worksheet is

if range (E3:e6000) contains "C" then b3 value =ANZSIC Description else Primary Activities.

thanks

where is Search result worksheet

pl give one clear example :dunno as
what u want to search ?
if found what should be paster & where ?

which field be treated as primary field ??