Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

MSExcel-copying data in a cell

Avinasheswar (Business Consultant) (117 Points)

10 May 2007

How to copy data in one cell to 1000 other cells without selecting those cells but using a single function or command?Does anyone know that?

Reply
Follow
Share

8 Replies

Sanjay Aggarwal (117 Points)
Replied 10 May 2007

HI
TRY LOOKUP OR VLOOKUP OR HLOOKUP

SANJAY
SIMPLYSANJAY @ REDIFFMAIL.COM

Upgrade to CAclubindia Pro. Subscribe Now!

Avinasheswar (Business Consultant) (117 Points)
Replied 10 May 2007

Hey what are all those stuff?
LOOKUP VLOOKUP etc?

The One (379 Points)
Replied 10 May 2007

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.

Kamaraj Mani. N (Chartered Accountant - Product Manager) (553 Points)
Replied 20 November 2007

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...

Kamaraj Mani. N (Chartered Accountant - Product Manager) (553 Points)
Replied 05 December 2007

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

Upgrade to CAclubindia Pro. Subscribe Now!

Manu Kris (Market Risk Analyst) (185 Points)
Replied 13 December 2007

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

Kamaraj Mani. N (Chartered Accountant - Product Manager) (553 Points)
Replied 17 December 2007

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...