Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA
Resolved · Medium Priority · Version 2003
Reply Thu 16 Oct 2008, 17:00Delegate Vinay said...
Vinay has attended:
Access Intermediate course
Access Advanced course
Excel Intermediate course
Excel Advanced course
VBA
I would like to type in a field in (eg) cell A3, and i would like it to appear on another sheet under a differnce cell reference. How can this be done.
For upcoming training course dates see: Pricing & availability
RE: VBA
Hi Vinay
As you have already assumed this needs some VBA code.
If its a straight forward copy of one cell in "Sheet1" to another cell in "Sheet2" then only a simple recorded macro is required.
1. Select the "Tools" menu, click "Macros" and the click "Record New Macro"
2. Name the macro "Copy_Data"
3. In "Sheet1" select cell "A3" and click "Copy"
4. Go to "Sheet2" select the destination cell "B7" and paste
5. Stop recording the macro
Every time you run the macro it will take whatever value in A3 and copy it to B7 in "Sheet2"
Now if every time you run this macro you want to paste in the next empty cell (B8, B9, etc) you will require some written VBA code that will search for the next empty cell in the required range before pasting the data.
We do run VBA courses if you are interested in learning VBA.
Hope this helps
Carlos
|