|
-
Jun 19th, 2011, 11:31 PM
#1
Thread Starter
Hyperactive Member
[RESOLVED] Compare Data Between worksheets
Thanks in adv for help.
I have 2 worksheets. The primary worksheet (Sheet1) only has data in the first 50 Rows.
The 2nd worksheet has a lot of Data down to 200 at least.
The Macro has to look for my Name in (Sheet2) Column F (F3:F200), and then the Project Number in Column B (B3:B200) (I guess I need an Offset command on this.)
It has to compare the Proj Number in Culumn B (Sheet2) B3:B200) (Only if it has my name in Column F) with the projects in Column E (E6:E50) of (Sheet1), and if there is no match before it reaches the end of the Data it places it in the next (empty) Row of Sheet1.
Thanks for the help.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|