<div>
Thanx mate that was perfect. If you would not mind also having a look at another question that i have posted in this lounge today for excel<br />
<br />
<br />
thanx <br />
<br />
Craig
</div>


Thanx mate that was perfect. If you would not mind also having a look at another question that i have posted in this lounge today for excel


thanx

Craig

<div>
<div class="content wysiwyg-content">
Hi<br />
I need help with excel spreadsheet<br />
there are 2 worksheets in a excel file. The first has a section with an Account number<br />
and then a corresponding Account name.<br />
In the second sheet in need to be able to do the following.<br />
If the user types in the acount number in column a, then automatically populate column 2 with the <br />
Account name from the first sheet.<br />
<br />
thanx<br />
<br />
:)<br />
<br />
Craig
</div>
</div>


Hi
I need help with excel spreadsheet
there are 2 worksheets in a excel file. The first has a section with an Account number
and then a corresponding Account name.
In the second sheet in need to be able to do the following.
If the user types in the acount number in column a, then automatically populate column 2 with the 
Account name from the first sheet.

thanx

:)

Craig

Excel and VBA

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.