MSExcel-copying data in a cell

HI
TRY LOOKUP OR VLOOKUP OR HLOOKUP

SANJAY
SIMPLYSANJAY @ REDIFFMAIL.COM

Hey what are all those stuff?
LOOKUP VLOOKUP etc?

The One Says:

It is only restricted by your imagination. Mr. Sanjay Aggarwal provides - lookup functions are a good idea you can also use if function to create a loop and an iteration or create a macro. The list is endless.

Dear Mr. Avinashewar,

1. Go to TOOLS>MACRO>VISUAL BASIC EDITOR
2. in this window, Go to VIEW>IMMEDIATE WINDOW
3. in this window, type RANGE("A1:A1000").VALUE="Avinasheswar"
or
Cell B2 is having CHARTERED ACCOUNTANT as value.
then use this commend RANGE("A1:A1000").VALUE=RANGE("B2").VALUE

It will give you the result...

Dear Mr. Avinashewar, Have you checked that...?? Please inform me as it is works or not..??

Hi Kamraj, Is it necessary to master VB to write macros?

Dear Manu,

I can say, no need.

First we have to understand how the Excel works when we give inputs thru Keyboard or mouse.

If we can understand the same, we can write 'n' number of macros with out the help of VB.

I accept that we have to use VB Code in Macro, but Concepts are important than the codes.

U can follow the given steps to get a clear idea:
Step 1: record a new macro
Step 2: Select A10, type "CACLUBINDIA"
Step 3: Stop the macro
Step 4: Go to visual basic editor.
Step 5: Read how System has written codes in your macro.

You can understand the codes what system has written in macro. Just try the same with some other Functions. (like set print area, delete sheet....etc)

You can be an expert in macro, if you understand the concept with out having Coding Knowledge in VB.

I think i will help you... please reply...

YES I AM TRY AND SUCCESS 

CAN SUGGEST MORE  VB CODE