Thread: Copying a cell value to another sheet by using If statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
naga rajan naga rajan is offline
external usenet poster
  
Posts: 14
Default Copying a cell value to another sheet by using If statement
Hello everyone,

Am having the following example.

A1=john or james or raja
B1= salary

If A1="john" then B1 should be copied to B1 of sheet 2
If A1="james" then B1 should be copied to C1 of sheet 2

How to achieve this?
Please help

Thanks,
Naga
Reply With QuoteReply With Quote