comparing & copying data over from another workbook

T

Twain

I need to compare A's CompanyID to Z's Company ID and if there is
match copy all the data from Z's sheet for the Company ID row over t
A's sheet where the CompanyID row is. Sheet Z has 25 columns, includin
CompanyID.

I have two workbooks - One with all my VBA (I will call it Sheet A) an
another read only workbook out on the network with 40,000 rows (I wil
call it Sheet Z). The first column in both workbooks is a unique
digit number (I will call this CompanyID). Thanks.

If it's possible I'd like it so if a record exists in sheet A and no
in sheet Z then have that row's background color = light yellow.

FYI: The VBA I currently have (attached) is spitting A's row info to
new sheet on A if CompanyID doesn't exist in sheet Z. I am poor at VB
(just started learning) so please be gentle

+-------------------------------------------------------------------
|Filename: FINAL6.zip
|Download: http://www.excelforum.com/attachment.php?postid=3660
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create if partial match then copy and paste data from one cell to another 1
Copy cell value from one worksheet to matching worksheet in another workbook 4
Copy and paste from WB to another WB 1
Pulling data from one workbook to another one using VBA 0
Class versus Another Way, Wbk and Sheet Custom Data Needs 1
Advanced copying of range from one workbook to another 9
Macro to copy specific data from master workbook to another workbook 13
Multi Workbook Data Extraction 5

Top