Marcro for asigining the value

A

amithkumar

Joined
Mar 16, 2007
Messages
5
Reaction score
0
Hi All,

Pls help me out with this i want a macro someting like this...

For example....there are two colums "A" and "B"

1) In "A1" column if the value is " suppliesQ2data" it should return "Q2" in the column "B1"

2) In "A2" column if the value is " suppliesQ3america" it should return "Q3" in the column "B2"

3) In "A3" column if the value is " suppliesQ4german" it should return "Q4" in the column "B3"

Pls help me with this
Thanks in advance.
Have a nice day....
Or u can mail me at (e-mail address removed)
 
Hi All,

Pls help me out with this i want a macro someting like this...

For example....there are two colums "A" and "B"

1) In "A1" column if the value is " suppliesQ2data" it should return "Q2" in the column "B1"

2) In "A2" column if the value is " suppliesQ3america" it should return "Q3" in the column "B2"

3) In "A3" column if the value is " suppliesQ4german" it should return "Q4" in the column "B3"

Pls help me with this
Thanks in advance.
Have a nice day....
Or u can mail me at (e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for Creating Word Document!! 5
Formula IF 1
Fn = Cn * En 2
get the sum of the value by filtering 3 columns 2
Concatenate the lookup values from all occurences 4
rearranging the data 1
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Re. Conditional formating of adjacent cells but down a column 0

Back
Top