<div>
That worked perfect. &nbsp;Thank you very much
</div>


That worked perfect.  Thank you very much

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
How can I compare to columns (on different spreadsheets in the same workbook) that may have the same data (string value) and then enter in another value from a column that contain data.<br />
<br />
For Example<br />
<br />
Sheet 1<br />
Column a<br />
Accounting<br />
<br />
Sheet2<br />
Column A &nbsp; &nbsp; Column b<br />
Accounting &nbsp; &nbsp;AA-Accounting<br />
<br />
What I need to do is compare the sheets and move column b to sheet 1 column b<br />
The sheets may not be in the same order or one sheet may have more than the other<br />
<br />
Is there a formula that can do this or is there a quick macro that can accomplish this<br />
<br />
Thank you for all of your help in advance
</div>
</div>


Hi

How can I compare to columns (on different spreadsheets in the same workbook) that may have the same data (string value) and then enter in another value from a column that contain data.

For Example

Sheet 1
Column a
Accounting

Sheet2
Column A     Column b
Accounting    AA-Accounting

What I need to do is compare the sheets and move column b to sheet 1 column b
The sheets may not be in the same order or one sheet may have more than the other

Is there a formula that can do this or is there a quick macro that can accomplish this

Thank you for all of your help in advance

Excel Foruma to compare to excel sheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.