Need macro/function to compare values in columns and then cut/paste row to new sheet

Hrstyhskr

New Member
Joined
Nov 30, 2012
Messages
21
Here is more detail of what i need to do.

Look at a column in sheet1 and find the match in a column of sheet2. if it matches, then cut and paste the row in sheet1 to sheet3. i need the macro to continue down the column of sheet1 until it reaches the end of the table. when it is finished i should have a new table on sheet3. I would really appreciate the help! Thanks!!
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Hrstyhskr,

Welcome to the MrExcel forum.

What version of Excel are you using?


Can you post screenshots of the worksheets, and, post the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker
Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data scrubbed/removed/changed
mark the workbook for sharing
and provide us with a link to your workbook.
 
Upvote 0
Excel 2007
ABCDEFGHIJKLMNOP
1Salesperson ID from Sales TransactionDocument DateState from Sales TransactionCustomer NameAddress 1 from Sales TransactionSOP TypeItem DescriptionItem NumberExtended PriceQTYCustomer NumberSOP NumberGL Posting DateVoid StatusBatch NumberCustomer PO Number
2228009/14/2012VALiberty UCASASInvoiceTriple R Speed, 4EBA09031$0.00 139953457349509/14/2012NormalPST12091406A017NC REVIEW COPY
3228009/07/2012TXLULAC NESC, Houston3522 Polk StInvoiceTriple R Speed, 4EBA09031$8.97 1372644457120609/07/2012NormalPST12090706A003DEBRACARRIZAL83012
4228009/28/2012ARCAVE CITY HIGH SCHOOL711 north mainInvoiceTriple R Speed, 4EBA09031$12.71 1373399457872009/28/2012NormalPST12092806A035541772717005019
5228008/11/2012TXSt Mary's UUPWARD BOUNDInvoiceTriple R Speed, 4EBA09031$12.71 141245456503908/11/2012NormalPST12081110A007P0019036
6228009/28/2012ARCAVE CITY HIGH SCHOOL711 north mainInvoicePanic Plan for the SAT 7th EditionBA15341$8.46 1373399457872009/28/2012NormalPST12092806A035541772717005019
7228009/08/2012NJBridgeton Sch DistrictBridgeton High SchInvoicePanic Plan for the SAT 7th EditionBA15341$8.46 192699457152909/08/2012NormalPST12090808A01213-1867
8228007/25/2012NYBath Central Sch DistHaverling Jr-Sr HSInvoicePanic Plan for the SAT 7th EditionBA15341$99.50 1098836456139407/25/2012NormalPST12072508A010130196
9228009/27/2012NJPinelands Reg Sch DistPinelands Regional H SInvoiceMaster the AP English Literature & Composition, 1st editionBA22305$450.00 2592694457833809/27/2012NormalEG092712MANANTHONYLUPO092712
10228008/11/2012TXSt Mary's UUPWARD BOUNDInvoiceWinning the College Admission Game: Stratgies for Parents & Students, 1st edBA2491X$12.75 141245456503908/11/2012NormalPST12081110A007P0019036

<COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
</TBODY>
Sales eligible for commission
 
Upvote 0
above is data from sheet1. i need a macro to look at column h and compare to column a in the table below which is located on a different sheet. if there is a match then i need the entire row from sheet1 where the "match" exists cut and pasted to a new sheet.

Excel 2007
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
1
ITEMNMBR
ITEMDESC
LISTPRCE
CURRCOST
Item Short Name
PTR ISBN
PTR ISBN No Hyphen
PTR WMS Short Desc
PTR Authors
PTR Product Edition
PTR Copyright Year
PTR Release Date
PTR On Sale Date
PTR To Printer Date
PTR Prior ISBN
PTR ISBN13
PTR Cyberedit ID
PTR Bisac Code
PTR Royalty Code
PTR Item Status
PTR Standing Order Code
PTR Business Owner
PTR Deferred Item
PTR Binding
PTR Trimsize
PTR Pages
PTR Product Division
PTR Content Area
PTR Product Series
PTR Research Database
PTR Product Role
PTR Product Type
PTR Annual Series
PTR Product Project
PTR Sales Account
PTR Cogs Account
PTR Markdown Account
PTR Returns Account
PTR Damaged Account
PTR Inventory Account
PTR Inventory Offset Account
PTR Variances Account
CREATDDT
2
BA34338
The Real ACT w/CD Spanish edition, 1st edition
$34.95
$0.00
0-7689-3433-8
0768934338
The Real ACT w/CD Spanish edition, 1/e
ACT, Inc
01
2012
08/29/2012
09/18/2012
01/01/1900
978-0-7689-3433-5
STU001000
Qtrly Royalties
HLD
Pub
No
SOFTCOVER
81
P
T
REALACT
NA
BK-1-NTL
B
00A4338
35-93000-3595-611-00000-00A4338
35-93000-6259-611-00000-00A4338
35-93000-3595-611-00000-00A4338
35-93000-3595-621-00000-00A4338
35-93000-6259-627-00000-00A4338
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-93000-6259-628-00000-00A4338
########
3
BA34397
Cool Colleges 101 National Edition, 2/e
$21.95
$10.23
0-7689-3439-7
0768934397
Cool Colleges 101 National Edition, 2/e
Peterson's
02
2012
09/12/2012
09/25/2012
08/02/2012
0-7689-3397-8
978-0-7689-3439-7
EDU024000
Work For Hire
ACT
Pub
No
SOFTCOVER
77
456
P
E
COOLCOL
NA
BK-1-NTL
B
2012
00A4397
35-93000-3595-611-00000-00A4397
35-93000-6259-611-00000-00A4397
35-93000-3595-611-00000-00A4397
35-95350-3595-621-00000-00A4397
35-93000-6259-627-00000-00A4397
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-93000-6259-628-00000-00A4397
########
4
BA3477X
Master the GMAT 2013
$36.95
$2.23
0-7689-3477-X
076893477X
Master the GMAT 2013 (wCD)
Stewart, Mark A.
19
2012
09/05/2012
09/25/2012
07/31/2012
0-7689-3143-6
978-0-7689-3477-9
STU013000
Work For Hire
ACT
No
SOFTCOVER
81
816
P
ATP
AMGMATCD
NA
BK-4-BKL
B
2012
00A477X
35-93000-3595-611-00000-00A477X
35-93000-6259-611-00000-00A477X
35-93000-3595-611-00000-00A477X
35-95350-3595-621-00000-00A477X
35-93000-6259-627-00000-00A477X
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-93000-6259-628-00000-00A477X
########
5
BA36071
Master the SAT 2013
$24.95
$2.12
0-7689-3607-1
0768936071
Master SAT 2013
Peterson's
13
2012
07/11/2012
07/17/2012
06/01/2012
0-7689-3294-7
978-0-7689-3607-0
STU024000
No Royalties
ACT
Pub
No
SOFTCOVER
81
848
P
T
AMSATCD
NA
BK-4-BKL
B
2013
00A6071
35-93000-3595-611-00000-00A6071
35-93000-6259-611-00000-00A6071
35-93000-3595-611-00000-00A6071
35-95350-3595-621-00000-00A6071
35-93000-6259-627-00000-00A6071
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-93000-6259-628-00000-00A6071
########
6
BA3608X
Scholarships, Grants & Prizes 2013
$33.95
$2.27
0-7689-3608-X
076893608X
S, G & P 2013
Peterson's
17
2012
07/18/2012
07/24/2012
06/08/2012
0-7689-3293-9
978-0-7689-3608-7
STU031000
No Royalties
ACT
GSO-SGP
Pub
No
SOFTCOVER
81
960
P
E
SGP
33
BK-2-SRV
B
2013
00A608X
35-93000-3595-611-00000-00A608X
35-93000-6259-611-00000-00A608X
35-93000-3595-611-00000-00A608X
35-95350-3595-621-00000-00A608X
35-93000-6259-627-00000-00A608X
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-93000-6259-628-00000-00A608X
########
7
BA36101
Two-Year Colleges 2013
$29.95
$1.33
0-7689-3610-1
0768936101
Two-Year Colleges 2013
Peterson's
43
2012
08/08/2012
08/21/2012
06/27/2012
0-7689-3278-5
978-0-7689-3610-0
EDU024000
No Royalties
ACT
GSO-U2
Pub
No
SOFTCOVER
81
496
P
E
U2
12
BK-2-SRV
B
2013
00A6101
35-93000-3595-611-00000-00A6101
35-93000-6259-611-00000-00A6101
35-93000-3595-611-00000-00A6101
35-95350-3595-621-00000-00A6101
35-93000-6259-627-00000-00A6101
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-93000-6259-628-00000-00A6101
########
8
BA3611X
How to Get Money for College: Financing Your Future Beyond Federal Aid 2013
$29.95
$2.44
0-7689-3611-X
076893611X
Money for College 2013
Peterson's
30
2012
08/08/2012
08/28/2012
07/05/2012
0-7689-3295-5
978-0-7689-3611-7
STU031000
No Royalties
ACT
GSO-CMH
Pub
No
SOFTCOVER
81
928
P
E
CMH
13
BK-2-SRV
B
2013
00A611X
35-93000-3595-611-00000-00A611X
35-93000-6259-611-00000-00A611X
35-93000-3595-611-00000-00A611X
35-95350-3595-621-00000-00A611X
35-93000-6259-627-00000-00A611X
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-93000-6259-628-00000-00A611X
########
9
BA36128
Undergraduate Guidance Set 2013
$62.90
$6.78
0-7689-3612-8
0768936128
Undergrad Set 2013
Peterson's
43
2012
08/08/2012
08/28/2012
07/27/2012
0-7689-3287-4
978-0-7689-3612-4
EDU024000
No Royalties
ACT
GSO-UGS
Pub
No
SET
P
E
UGS
12
BK-2-SRV
B
2013
00A6128
35-93000-3595-611-00000-00A6128
35-93000-6259-611-00000-00A6128
35-93000-3595-611-00000-00A6128
35-95350-3595-621-00000-00A6128
35-93000-6259-627-00000-00A6128
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-93000-6259-628-00000-00A6128
########
10
BA36136
Basic Guidance Set 2013
$126.80
$11.50
0-7689-3613-6
0768936136
Basic Set 2013
Peterson's
25
2012
08/08/2012
08/28/2012
08/03/2012
0-7689-3288-2
978-0-7689-3613-1
EDU024000
No Royalties
ACT
GSO-GS
Pub
No
SET
P
E
GS
12
BK-2-SRV
B
2013
00A6136
35-93000-3595-611-00000-00A6136
35-93000-6259-611-00000-00A6136
35-93000-3595-611-00000-00A6136
35-95350-3595-621-00000-00A6136
35-93000-6259-627-00000-00A6136
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-93000-6259-628-00000-00A6136
########
11
BA36144
Financial Aid Guidance Set 2013
$63.90
$4.72
0-7689-3614-4
0768936144
FinAid Set 2013
Peterson's
09
2012
08/08/2012
08/28/2012
08/03/2012
0-7689-3289-0
978-0-7689-3614-8
STU031000
No Royalties
ACT
Pub
No
SET
P
E
FINAIDSET
NA
BK-4-BKL
B
2013
00A6144
35-93000-3595-611-00000-00A6144
35-93000-6259-611-00000-00A6144
35-93000-3595-611-00000-00A6144
35-95350-3595-621-00000-00A6144
35-93000-6259-627-00000-00A6144
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-93000-6259-628-00000-00A6144
########
12
BA36152
The "C" Students guide to Scholarships
$16.95
$0.75
0-7689-3615-2
0768936152
C Students Gde to Scholarships
Hatcher, Felecia
02
2013
09/19/2012
10/09/2012
08/10/2012
0-6154-1598-9
978-0-7689-3615-5
STU031000
Royalties
ACT
Pub
No
SOFTCOVER
60
216
P
E
CSTUD
NA
BK-1-NTL
B
00A6152
35-93000-3595-611-00000-00A6152
35-93000-6259-611-00000-00A6152
35-93000-3595-611-00000-00A6152
35-95350-3595-621-00000-00A6152
35-93000-6259-627-00000-00A6152
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-93000-6259-628-00000-00A6152
########
13
BA36160
Master the Physician Assisant National Recertifying Exam (PANRE)
$21.95
$1.30
0-7689-3616-0
0768936160
Master PANRE
Cantarella, Cara
01
2012
07/11/2012
08/07/2012
06/01/2012
978-0-7689-3616-2
MED086000
Royalties
ACT
Pub
No
SOFTCOVER
80
256
P
E
MSTRPHYA
NA
BK-1-NTL
B
00A6160
35-93000-3595-611-00000-00A6160
35-93000-6259-611-00000-00A6160
35-93000-3595-611-00000-00A6160
35-95350-3595-621-00000-00A6160
35-93000-6259-627-00000-00A6160
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-93000-6259-628-00000-00A6160
########
14
BA37639
2013 Spring/Summer Trade Catalog
$0.00
$0.00
0-7689-3763-9
0768937639
2013 SprgSum Catalog
Peterson's
2012
09/24/2012
09/21/2012
08/22/2012
0-7689-3568-7
978-0-7689-3763-3
ACT
Pub
No
SOFTCOVER
70
21
P
O
NA
NA
B
00A7639
35-93000-3595-611-00000-00A7639
35-95002-6259-699-00000-0000000
35-93000-3595-611-00000-00A7639
35-93000-3595-611-00000-00A7639
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
15
BE37167
Scholarships, Grants & Prizes 2013
$14.99
$0.00
0-7689-3716-7
0768937167
SGP 2013
Peterson's
17
2012
07/05/2012
08/07/2012
01/01/1900
0-7689-3581-4
978-0-7689-3716-9
STU031000
No Royalties
ACT
Pub
No
E-Book
81
P
E
SGP
33
EBOOKFC
B
2013
00A608X
35-93000-3595-622-00000-00A608X
35-93000-6259-622-00000-0000000
35-93000-3595-622-00000-00A608X
35-93000-3595-622-00000-00A608X
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
16
BE37175
Two-Year Colleges 2013
$12.99
$0.00
0-7689-3717-5
0768937175
UG2 2013
Peterson's
43
2012
08/01/2012
09/04/2012
01/01/1900
0-7689-3631-4
978-0-7689-3717-6
EDU024000
No Royalties
ACT
Pub
No
E-Book
81
P
E
U2
12
EBOOKFC
B
2013
00A6101
35-93000-3595-622-00000-00A6101
35-93000-6259-622-00000-0000000
35-93000-3595-622-00000-00A6101
35-93000-3595-622-00000-00A6101
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
17
BE37183
How to Get Money for College 2013
$14.99
$0.00
0-7689-3718-3
0768937183
Get Money for College 2013
Peterson's
30
2012
08/08/2012
09/11/2012
01/01/1900
0-7689-3632-2
978-0-7689-3718-3
STU031000
No Royalties
ACT
Pub
No
E-Book
81
P
E
CMH
13
EBOOKFC
B
2013
00A611X
35-93000-3595-622-00000-00A611X
35-93000-6259-622-00000-0000000
35-93000-3595-622-00000-00A611X
35-93000-3595-622-00000-00A611X
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
18
BE37191
Cool Colleges 101, 2nd Ed.
$9.99
$0.00
0-7689-3719-1
0768937191
Cool Colleges
Peterson's
02
2012
08/22/2012
09/25/2012
01/01/1900
0-7689-3398-6
978-0-7689-3719-0
STU024000
No Royalties
ACT
Pub
No
E-Book
77
P
E
COOLCOL
NA
EBOOKFC
B
2012
00A4397
35-93000-3595-622-00000-00A4397
35-93000-6259-622-00000-0000000
35-93000-3595-622-00000-00A4397
35-93000-3595-622-00000-00A4397
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
19
BE37205
Master the GMAT 2013
$17.99
$0.00
0-7689-3720-5
0768937205
Master GMAT 2013
Stewart, Mark A.
19
2012
09/05/2012
10/16/2012
01/01/1900
0-7689-3557-1
978-0-7689-3720-6
STU013000
No Royalties
ACT
Pub
No
E-Book
81
P
ATP
AMGMATCD
NA
EBOOKFC
B
2012
00A477X
35-93000-3595-622-00000-00A477X
35-93000-6259-622-00000-0000000
35-93000-3595-622-00000-00A477X
35-93000-3595-622-00000-00A477X
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
20
BE37213
Master the GMAT 2013: GMAT Basics
$2.99
$0.00
Part I of V
0-7689-3721-3
0768937213
Master GMAT Basics
Stewart, Mark A.
19
2012
09/05/2012
11/30/2012
01/01/1900
0-7689-3558-X
978-0-7689-3721-3
STU013000
No Royalties
NYP
Pub
No
E-Book
81
P
ATP
AMGMATCD
NA
EBOOKSC
B
2012
00A477X
35-93000-3595-622-00000-00A477X
35-93000-6259-622-00000-0000000
35-93000-3595-622-00000-00A477X
35-93000-3595-622-00000-00A477X
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
21
BE37264
Master the GMAT 2013: Practice Test 2
$2.99
$0.00
Prac Tes 2 of 6
0-7689-3726-4
0768937264
Master GMAT Prac Test 2
Stewart, Mark A.
19
2012
09/05/2012
11/30/2012
01/01/1900
0-7689-3563-6
978-0-7689-3726-8
STU013000
No Royalties
NYP
Pub
No
E-Book
81
P
ATP
AMGMATCD
NA
EBOOKSC
B
2012
00A477X
35-93000-3595-622-00000-00A477X
35-93000-6259-622-00000-0000000
35-93000-3595-622-00000-00A477X
35-93000-3595-622-00000-00A477X
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
22
BE37272
Master the GMAT 2013: Practice Test 3
$2.99
$0.00
Prac Tes 3 of 6
0-7689-3727-2
0768937272
Master GMAT Prac Test 3
Stewart, Mark A.
19
2012
09/05/2012
11/30/2012
01/01/1900
0-7689-3564-4
978-0-7689-3727-5
STU013000
No Royalties
NYP
Pub
No
E-Book
81
P
ATP
AMGMATCD
NA
EBOOKSC
B
2012
00A477X
35-93000-3595-622-00000-00A477X
35-93000-6259-622-00000-0000000
35-93000-3595-622-00000-00A477X
35-93000-3595-622-00000-00A477X
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
23
BE37280
Master the GMAT 2013: Practice Test 4
$2.99
$0.00
Prac Tes 4 of 6
0-7689-3728-0
0768937280
Master GMAT Prac Test 4
Stewart, Mark A.
19
2012
09/05/2012
11/30/2012
01/01/1900
0-7689-3565-2
978-0-7689-3728-2
STU013000
No Royalties
NYP
Pub
No
E-Book
81
P
ATP
AMGMATCD
NA
EBOOKSC
B
2012
00A477X
35-93000-3595-622-00000-00A477X
35-93000-6259-622-00000-0000000
35-93000-3595-622-00000-00A477X
35-93000-3595-622-00000-00A477X
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
24
BE37299
Master the GMAT 2013: Practice Test 5
$2.99
$0.00
Prac Tes 5 of 6
0-7689-3729-9
0768937299
Master GMAT Prac Test 5
Stewart, Mark A.
19
2012
09/05/2012
11/30/2012
01/01/1900
0-7689-3566-0
978-0-7689-3729-9
STU013000
No Royalties
NYP
Pub
No
E-Book
81
P
ATP
AMGMATCD
NA
EBOOKSC
B
2012
00A477X
35-93000-3595-622-00000-00A477X
35-93000-6259-622-00000-0000000
35-93000-3595-622-00000-00A477X
35-93000-3595-622-00000-00A477X
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
25
BE37302
Master the GMAT 2013: Practice Test 6
$2.99
$0.00
Prac Tes 6 of 6
0-7689-3730-2
0768937302
Master GMAT Prac Test 6
Stewart, Mark A.
19
2012
09/05/2012
11/30/2012
01/01/1900
0-7689-3567-9
978-0-7689-3730-5
STU013000
No Royalties
NYP
Pub
No
E-Book
81
P
ATP
AMGMATCD
NA
EBOOKSC
B
2012
00A477X
35-93000-3595-622-00000-00A477X
35-93000-6259-622-00000-0000000
35-93000-3595-622-00000-00A477X
35-93000-3595-622-00000-00A477X
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
26
BE37310
The "C" Students Guide to Scholarships
$6.99
$0.00
0-7689-3731-0
0768937310
"C" Students Guide to Scholarships
Hatcher, Felecia
02
2013
09/19/2012
10/23/2012
01/01/1900
978-0-7689-3731-2
STU031000
Royalties
ACT
Pub
No
E-Book
60
P
E
CSTUD
NA
EBOOKFC
B
00A6152
35-93000-3595-622-00000-00A6152
35-93000-6259-622-00000-0000000
35-93000-3595-622-00000-00A6152
35-93000-3595-622-00000-00A6152
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
27
I2013U2BCOV
INSIDE FULL PAGE BACK COVER COLOR ADVERTISEMENT 2-Year Colleges (2013 edition)
$5,000.00
$0.00
Inside Full Pg Back Cvr Color Ad in 2013 2Yr Coll
Peterson's
2013
2012
08/01/2012
01/01/1900
01/01/1900
ACT
HE
Yes
HE-PR
E
U2
12
IFBCR
I
2013
00A6101
35-93000-3595-671-00000-00A6101
35-93000-6259-671-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-671-00000-00A6101
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
28
I2013U2D
UG 2 Print Publication-2013
$1,260.00
$0.00
UG 2 Print Publication-2013
Peterson's
2013
2012
08/01/2012
01/01/1900
01/01/1900
ACT
Pub
Yes
P
E
U2
12
UGBUNDLE
I
2013
00A6101
35-93000-3595-671-00000-00A6101
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-671-00000-00A6101
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
29
I2013U2FCOV
INSIDE FULL PAGE FRONT COVER COLOR ADVERTISEMENT 2-Year Colleges (2013 edition)
$6,000.00
$0.00
Inside Full Pg Front Cvr Color Ad in 2013 2Yr Coll
Peterson's
2013
2012
08/01/2012
01/01/1900
01/01/1900
ACT
HE
Yes
HE-PR
E
U2
12
IFCVR
I
2013
00A6101
35-93000-3595-671-00000-00A6101
35-93000-6259-671-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-671-00000-00A6101
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
30
I2013U2POD
UG 2 Print Publication On-Demand Package-2013
$2,750.00
$0.00
2013 UG 2 Premium Package
Peterson's
2013
2012
08/01/2012
01/01/1900
01/01/1900
ACT
Pub
Yes
P
E
U2
12
UGBUNDLE
I
2013
00A6101
35-93000-3595-671-00000-00A6101
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-671-00000-00A6101
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
31
OEEAO100AWCOLL
EssayEdge Add-On 100 Additional Words - College
$260.00
$0.00
EssayEdge Add-On 100 Additional Words - College
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7605
No Royalties Edge
ACT
DTC
No
C
OLE
EECO
NA
CEADDWD
O
EEADDWD
35-93000-3595-668-00000-EEADDWD
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-668-00000-EEADDWD
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
32
OEEAO100AWGRAD
EssayEdge Add-On 100 Additional Words - Graduate
$260.00
$0.00
EssayEdge Add-On 100 Additional Words - Graduate
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7581
No Royalties Edge
ACT
DTC
No
C
OLE
EEGD
NA
CEADDWD
O
EEADDWD
35-93000-3595-661-00000-EEADDWD
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-661-00000-EEADDWD
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
33
OEEAO100AWLAW
EssayEdge Add-On 100 Additional Words - Law
$260.00
$0.00
EssayEdge Add-On 100 Additional Words - Law
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7599
No Royalties Edge
ACT
DTC
No
C
OLE
EELW
NA
CEADDWD
O
EEADDWD
35-93000-3595-667-00000-EEADDWD
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-667-00000-EEADDWD
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
34
OEEAO100AWMBA
EssayEdge Add-On 100 Additional Words - MBA
$260.00
$0.00
EssayEdge Add-On 100 Additional Words - MBA
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7593
No Royalties Edge
ACT
DTC
No
C
OLE
EEBS
NA
CEADDWD
O
EEADDWD
35-93000-3595-665-00000-EEADDWD
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-665-00000-EEADDWD
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
35
OEEAO100AWMED
EssayEdge Add-On 100 Additional Words - Medical
$260.00
$0.00
EssayEdge Add-On 100 Additional Words - Medical
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7587
No Royalties Edge
ACT
DTC
No
C
OLE
EEMD
NA
CEADDWD
O
EEADDWD
35-93000-3595-664-00000-EEADDWD
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-664-00000-EEADDWD
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
36
OEEAO100AWWLE
EssayEdge Add-On 100 Additional Words - WLE
$260.00
$0.00
EssayEdge Add-On 100 Additional Words - WLE
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7625
No Royalties Edge
ACT
DTC
No
C
OLE
EEWLE
NA
CEADDWD
O
EEADDWD
35-93000-3595-663-00000-EEADDWD
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-663-00000-EEADDWD
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
37
OEEPRRSCOLL
EssayEdge Proofreading Rush Service - College
$560.00
$0.00
EssayEdge Proofreading Rush Service - College
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7618
No Royalties Edge
ACT
DTC
No
C
OLE
EECO
NA
CERUSH
O
EEPROOF
35-93000-3595-668-00000-EEPROOF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-668-00000-EEPROOF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
38
OEEPRRSGRAD
EssayEdge Proofreading Rush Service - Graduate
$560.00
$0.00
EssayEdge Proofreading Rush Service - Graduate
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7606
No Royalties Edge
ACT
DTC
No
C
OLE
EEGD
NA
CERUSH
O
EEPROOF
35-93000-3595-661-00000-EEPROOF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-661-00000-EEPROOF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
39
OEEPRRSLAW
EssayEdge Proofreading Rush Service - Law
$560.00
$0.00
EssayEdge Proofreading Rush Service - Law
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7615
No Royalties Edge
ACT
DTC
No
C
OLE
EELW
NA
CERUSH
O
EEPROOF
35-93000-3595-667-00000-EEPROOF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-667-00000-EEPROOF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
40
OEEPRRSMBA
EssayEdge Proofreading Rush Service - MBA
$560.00
$0.00
EssayEdge Proofreading Rush Service - MBA
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7612
No Royalties Edge
ACT
DTC
No
C
OLE
EEBS
NA
CERUSH
O
EEPROOF
35-93000-3595-665-00000-EEPROOF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-665-00000-EEPROOF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
41
OEEPRRSMED
EssayEdge Proofreading Rush Service - Medical
$560.00
$0.00
EssayEdge Proofreading Rush Service - Medical
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7609
No Royalties Edge
ACT
DTC
No
C
OLE
EEMD
NA
CERUSH
O
EEPROOF
35-93000-3595-664-00000-EEPROOF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-664-00000-EEPROOF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
42
OEEPRRSWLE
EssayEdge Proofreading Rush Service - WLE
$560.00
$0.00
EssayEdge Proofreading Rush Service - WLE
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7626
No Royalties Edge
ACT
DTC
No
C
OLE
EEWLE
NA
CEPROOFRD
O
EEPROOF
35-93000-3595-663-00000-EEPROOF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-663-00000-EEPROOF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
43
OEEPRSCOLL
EssayEdge Proofreading Service - College
$499.00
$0.00
EssayEdge Proofreading Service - College
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7600
No Royalties Edge
ACT
DTC
No
C
OLE
EECO
NA
CEPROOFRD
O
EEPROOF
35-93000-3595-668-00000-EEPROOF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-668-00000-EEPROOF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
44
OEEPRSGRAD
EssayEdge Proofreading Service - Graduate
$499.00
$0.00
EssayEdge Proofreading Service - Graduate
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7576
No Royalties Edge
ACT
DTC
No
C
OLE
EEGD
NA
CEPROOFRD
O
EEPROOF
35-93000-3595-661-00000-EEPROOF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-661-00000-EEPROOF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
45
OEEPRSLAW
EssayEdge Proofreading Service - Law
$499.00
$0.00
EssayEdge Proofreading Service - Law
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7594
No Royalties Edge
ACT
DTC
No
C
OLE
EELW
NA
CEPROOFRD
O
EEPROOF
35-93000-3595-667-00000-EEPROOF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-667-00000-EEPROOF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
46
OEEPRSMBA
EssayEdge Proofreading Service - MBA
$499.00
$0.00
EssayEdge Proofreading Service - MBA
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7588
No Royalties Edge
ACT
DTC
No
C
OLE
EEBS
NA
CEPROOFRD
O
EEPROOF
35-93000-3595-665-00000-EEPROOF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-665-00000-EEPROOF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
47
OEEPRSMED
EssayEdge Proofreading Service - Medical
$499.00
$0.00
EssayEdge Proofreading Service - Medical
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7582
No Royalties Edge
ACT
DTC
No
C
OLE
EEMD
NA
CEPROOFRD
O
EEPROOF
35-93000-3595-664-00000-EEPROOF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-664-00000-EEPROOF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
48
OEEPRSWLE
EssayEdge Proofreading Service - WLE
$499.00
$0.00
EssayEdge Proofreading Service - WLE
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7621
No Royalties Edge
ACT
DTC
No
C
OLE
EEWLE
NA
CEPROOFRD
O
EEPROOF
35-93000-3595-663-00000-EEPROOF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-663-00000-EEPROOF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
49
OEEPSCOLL
EssayEdge Premier Service - College
$789.00
$0.00
EssayEdge Premier Service - College
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7602
No Royalties Edge
ACT
DTC
No
C
OLE
EECO
NA
CEPREMIUM
O
EEPREMR
35-93000-3595-668-00000-EEPREMR
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-668-00000-EEPREMR
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
50
OEEPSGRAD
EssayEdge Premier Service - Graduate
$789.00
$0.00
EssayEdge Premier Service - Graduate
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7578
No Royalties Edge
ACT
DTC
No
C
OLE
EEGD
NA
CEPREMIUM
O
EEPREMR
35-93000-3595-661-00000-EEPREMR
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-661-00000-EEPREMR
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
51
OEEPSLAW
EssayEdge Premier Service - Law
$789.00
$0.00
EssayEdge Premier Service - Law
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7596
No Royalties Edge
ACT
DTC
No
C
OLE
EELW
NA
CEPREMIUM
O
EEPREMR
35-93000-3595-667-00000-EEPREMR
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-667-00000-EEPREMR
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
52
OEEPSMBA
EssayEdge Premier Service - MBA
$789.00
$0.00
EssayEdge Premier Service - MBA
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7590
No Royalties Edge
ACT
DTC
No
C
OLE
EEBS
NA
CEPREMIUM
O
EEPREMR
35-93000-3595-665-00000-EEPREMR
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-665-00000-EEPREMR
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
53
OEEPSMED
EssayEdge Premier Service - Medical
$789.00
$0.00
EssayEdge Premier Service - Medical
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7584
No Royalties Edge
ACT
DTC
No
C
OLE
EEMD
NA
CEPREMIUM
O
EEPREMR
35-93000-3595-664-00000-EEPREMR
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-664-00000-EEPREMR
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
54
OEERFCOLL
EssayEdge Rush Fee - College
$59.00
$0.00
EssayEdge Rush Fee - College
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7603
No Royalties Edge
ACT
DTC
No
C
OLE
EECO
NA
CERUSH
O
EERUSHF
35-93000-3595-668-00000-EERUSHF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-668-00000-EERUSHF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
55
OEERFGRAD
EssayEdge Rush Fee - Graduate
$59.00
$0.00
EssayEdge Rush Fee - Graduate
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7579
No Royalties Edge
ACT
DTC
No
C
OLE
EEGD
NA
CERUSH
O
EERUSHF
35-93000-3595-661-00000-EERUSHF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-661-00000-EERUSHF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
56
OEERFLAW
EssayEdge Rush Fee - Law
$59.00
$0.00
EssayEdge Rush Fee - Law
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7597
No Royalties Edge
ACT
DTC
No
C
OLE
EELW
NA
CERUSH
O
EERUSHF
35-93000-3595-667-00000-EERUSHF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-667-00000-EERUSHF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
57
OEERFMBA
EssayEdge Rush Fee - MBA
$59.00
$0.00
EssayEdge Rush Fee - MBA
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7591
No Royalties Edge
ACT
DTC
No
C
OLE
EEBS
NA
CERUSH
O
EERUSHF
35-93000-3595-665-00000-EERUSHF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-665-00000-EERUSHF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
58
OEERFMED
EssayEdge Rush Fee - Medical
$59.00
$0.00
EssayEdge Rush Fee - Medical
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7585
No Royalties Edge
ACT
DTC
No
C
OLE
EEMD
NA
CERUSH
O
EERUSHF
35-93000-3595-664-00000-EERUSHF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-664-00000-EERUSHF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
59
OEERFWLE
EssayEdge Rush Fee - WLE
$59.00
$0.00
EssayEdge Rush Fee - WLE
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7623
No Royalties Edge
ACT
DTC
No
C
OLE
EEWLE
NA
CERUSH
O
EERUSHF
35-93000-3595-663-00000-EERUSHF
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-663-00000-EERUSHF
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
60
OEESERSCOLL
EssayEdge Second Edit Rush Service - College
$500.00
$0.00
EssayEdge Second Edit Rush Service - College
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7619
No Royalties Edge
ACT
DTC
No
C
OLE
EECO
NA
CERUSH
O
EESEDIT
35-93000-3595-668-00000-EESEDIT
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-668-00000-EESEDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
61
OEESERSGRAD
EssayEdge Second Edit Rush Service - Graduate
$500.00
$0.00
EssayEdge Second Edit Rush Service - Graduate
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7607
No Royalties Edge
ACT
DTC
No
C
OLE
EEGD
NA
CERUSH
O
EESEDIT
35-93000-3595-661-00000-EESEDIT
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-661-00000-EESEDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
62
OEESERSLAW
EssayEdge Second Edit Rush Service - Law
$500.00
$0.00
EssayEdge Second Edit Rush Service - Law
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7616
No Royalties Edge
ACT
DTC
No
C
OLE
EELW
NA
CERUSH
O
EESEDIT
35-93000-3595-667-00000-EESEDIT
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-667-00000-EESEDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
63
OEESERSMBA
EssayEdge Second Edit Rush Service - MBA
$500.00
$0.00
EssayEdge Second Edit Rush Service - MBA
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7613
No Royalties Edge
ACT
DTC
No
C
OLE
EEBS
NA
CERUSH
O
EESEDIT
35-93000-3595-665-00000-EESEDIT
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-665-00000-EESEDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
64
OEESERSMED
EssayEdge Second Edit Rush Service - Medical
$500.00
$0.00
EssayEdge Second Edit Rush Service - Medical
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7610
No Royalties Edge
ACT
DTC
No
C
OLE
EEMD
NA
CERUSH
O
EESEDIT
35-93000-3595-664-00000-EESEDIT
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-664-00000-EESEDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
65
OEESERSWLE
EssayEdge Second Edit Rush Service - WLE
$500.00
$0.00
EssayEdge Second Edit Rush Service - WLE
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7627
No Royalties Edge
ACT
DTC
No
C
OLE
EEWLE
NA
CESECREAD
O
EESEDIT
35-93000-3595-663-00000-EESEDIT
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-663-00000-EESEDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
66
OEESESCOLL
EssayEdge Second Edit Service - College
$270.00
$0.00
EssayEdge Second Edit Service - College
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7604
No Royalties Edge
ACT
DTC
No
C
OLE
EECO
NA
CESECREAD
O
EESEDIT
35-93000-3595-668-00000-EESEDIT
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-668-00000-EESEDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
67
OEESESGRAD
EssayEdge Second Edit Service - Graduate
$270.00
$0.00
EssayEdge Second Edit Service - Graduate
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7580
No Royalties Edge
ACT
DTC
No
C
OLE
EEGD
NA
CESECREAD
O
EESEDIT
35-93000-3595-661-00000-EESEDIT
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-661-00000-EESEDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
68
OEESESLAW
EssayEdge Second Edit Service - Law
$270.00
$0.00
EssayEdge Second Edit Service - Law
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7598
No Royalties Edge
ACT
DTC
No
C
OLE
EELW
NA
CESECREAD
O
EESEDIT
35-93000-3595-667-00000-EESEDIT
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-667-00000-EESEDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
69
OEESESMBA
EssayEdge Second Edit Service - MBA
$270.00
$0.00
EssayEdge Second Edit Service - MBA
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7592
No Royalties Edge
ACT
DTC
No
C
OLE
EEBS
NA
CESECREAD
O
EESEDIT
35-93000-3595-665-00000-EESEDIT
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-665-00000-EESEDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
70
OEESESMED
EssayEdge Second Edit Service - Medical
$270.00
$0.00
EssayEdge Second Edit Service - Medical
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7586
No Royalties Edge
ACT
DTC
No
C
OLE
EEMD
NA
CESECREAD
O
EESEDIT
35-93000-3595-664-00000-EESEDIT
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-664-00000-EESEDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
71
OEESESWLE
EssayEdge Second Edit Service - WLE
$420.00
$0.00
EssayEdge Second Edit Service - WLE
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7624
No Royalties Edge
ACT
DTC
No
C
OLE
EEWLE
NA
CESECREAD
O
EESEDIT
35-93000-3595-663-00000-EESEDIT
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-663-00000-EESEDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
72
OEESRSCOLL
EssayEdge Standard Rush Service - College
$600.00
$0.00
EssayEdge Standard Rush Service - College
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7620
No Royalties Edge
ACT
DTC
No
C
OLE
EECO
NA
CERUSH
O
EESTAND
35-93000-3595-668-00000-EESTAND
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-668-00000-EESTAND
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
73
OEESRSGRAD
EssayEdge Standard Rush Service - Graduate
$600.00
$0.00
EssayEdge Standard Rush Service - Graduate
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7608
No Royalties Edge
ACT
DTC
No
C
OLE
EEGD
NA
CERUSH
O
EESTAND
35-93000-3595-661-00000-EESTAND
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-661-00000-EESTAND
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
74
OEESRSLAW
EssayEdge Standard Rush Service - Law
$600.00
$0.00
EssayEdge Standard Rush Service - Law
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7617
No Royalties Edge
ACT
DTC
No
C
OLE
EELW
NA
CERUSH
O
EESTAND
35-93000-3595-667-00000-EESTAND
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-667-00000-EESTAND
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
75
OEESRSMBA
EssayEdge Standard Rush Service - MBA
$600.00
$0.00
EssayEdge Standard Rush Service - MBA
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7614
No Royalties Edge
ACT
DTC
No
C
OLE
EEBS
NA
CERUSH
O
EESTAND
35-93000-3595-665-00000-EESTAND
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-665-00000-EESTAND
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
76
OEESRSMED
EssayEdge Standard Rush Service - Medical
$600.00
$0.00
EssayEdge Standard Rush Service - Medical
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7611
No Royalties Edge
ACT
DTC
No
C
OLE
EEMD
NA
CERUSH
O
EESTAND
35-93000-3595-664-00000-EESTAND
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-664-00000-EESTAND
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
77
OEESRSWLE
EssayEdge Standard Rush Service - WLE
$600.00
$0.00
EssayEdge Standard Rush Service - WLE
Cyber Edit
01
2012
08/01/2012
01/01/1900
01/01/1900
7628
No Royalties Edge
ACT
DTC
No
C
OLE
EEWLE
NA
CESTAND
O
EESTAND
35-93000-3595-663-00000-EESTAND
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-663-00000-EESTAND
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
78
OEESSCOLL
EssayEdge Standard Service - College
$539.00
$0.00
EssayEdge Standard Service - College
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7601
No Royalties Edge
ACT
DTC
No
C
OLE
EECO
NA
CESTAND
O
EESTAND
35-93000-3595-668-00000-EESTAND
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-668-00000-EESTAND
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
79
OEESSGRAD
EssayEdge Standard Service - Graduate
$539.00
$0.00
EssayEdge Standard Service - Graduate
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7577
No Royalties Edge
ACT
DTC
No
C
OLE
EEGD
NA
CESTAND
O
EESTAND
35-93000-3595-661-00000-EESTAND
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-661-00000-EESTAND
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
80
OEESSLAW
EssayEdge Standard Service - Law
$539.00
$0.00
EssayEdge Standard Service - Law
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7595
No Royalties Edge
ACT
DTC
No
C
OLE
EELW
NA
CESTAND
O
EESTAND
35-93000-3595-667-00000-EESTAND
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-667-00000-EESTAND
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
81
OEESSMBA
EssayEdge Standard Service - MBA
$539.00
$0.00
EssayEdge Standard Service - MBA
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7589
No Royalties Edge
ACT
DTC
No
C
OLE
EEBS
NA
CESTAND
O
EESTAND
35-93000-3595-665-00000-EESTAND
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-665-00000-EESTAND
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
82
OEESSMED
EssayEdge Standard Service - Medical
$539.00
$0.00
EssayEdge Standard Service - Medical
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7583
No Royalties Edge
ACT
DTC
No
C
OLE
EEMD
NA
CESTAND
O
EESTAND
35-93000-3595-664-00000-EESTAND
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-664-00000-EESTAND
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
83
OEESSWLE
EssayEdge Standard Service - WLE
$539.00
$0.00
EssayEdge Standard Service - WLE
Cyber Edit
01
2012
07/16/2012
01/01/1900
01/01/1900
7622
No Royalties Edge
ACT
DTC
No
C
OLE
EEWLE
NA
CESTAND
O
EESTAND
35-93000-3595-663-00000-EESTAND
35-95002-6259-699-00000-0000000
35-95002-6259-699-00000-0000000
35-93000-3595-663-00000-EESTAND
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
84
OREADCLTR
ResumeEdge Add-On Cover Letter
$70.00
$0.00
ResumeEdge Add-On Cover Letter
Cyber Edit
01
2012
09/27/2012
01/01/1900
01/01/1900
A101
No Royalties Edge
ACT
NCS
No
C
OLR
READDON
NA
READDON
O
REACLTR
35-93000-3595-662-00000-REACLTR
35-93000-6259-662-00000-0000000
35-93000-3595-662-00000-REACLTR
35-93000-3595-662-00000-REACLTR
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
85
OREADLNKPRO
ResumeEdge Add-On LinkedIn Profile
$50.00
$0.00
ResumeEdge Add-On LinkedIn Profile
Cyber Edit
01
2012
09/27/2012
01/01/1900
01/01/1900
A102
No Royalties Edge
ACT
NCS
No
C
OLR
READDON
NA
READDON
O
REALKPR
35-93000-3595-662-00000-REALKPR
35-93000-6259-662-00000-0000000
35-93000-3595-662-00000-REALKPR
35-93000-3595-662-00000-REALKPR
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
86
OREREEDIT
ResumeEdge Resume Editing
$149.00
$0.00
ResumeEdge Resume Editing
Cyber Edit
01
2012
09/27/2012
01/01/1900
01/01/1900
501
No Royalties Edge
ACT
NCS
No
C
OLR
REREEDIT
NA
CEREEDIT
O
REREDIT
35-93000-3595-662-00000-REREDIT
35-93000-6259-662-00000-0000000
35-93000-3595-662-00000-REREDIT
35-93000-3595-662-00000-REREDIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########
87
OREREWRIT
ResumeEdge Resume Writing
$299.00
$0.00
ResumeEdge Resume Writing
Cyber Edit
01
2012
09/27/2012
01/01/1900
01/01/1900
502
No Royalties Edge
ACT
NCS
No
C
OLR
REREWRIT
NA
CEREWRIT
O
RERWRIT
35-93000-3595-662-00000-RERWRIT
35-93000-6259-662-00000-0000000
35-93000-3595-662-00000-RERWRIT
35-93000-3595-662-00000-RERWRIT
35-95002-6259-699-00000-0000000
00-93999-1810-000-00000-0000000
00-93999-1810-000-00000-0000000
35-95002-6259-699-00000-0000000
########

<TBODY>
</TBODY>
New Book Releases
 
Last edited:
Upvote 0
Hrstyhskr,

I can not bring in all the information you posted into a worksheet/workbook.


You can upload your workbook to Box Net,
sensitive data scrubbed/removed/changed
mark the workbook for sharing
and provide us with a link to your workbook.
 
Upvote 0
Hrstyhskr,

Thanks for the workbook.

What do you want me to do to those rows in Sheet1 that are cut and moved to Sheet3?

Do you want me to remove the blank rows in Sheet1?
 
Upvote 0
Hrstyhskr,

I assume that all three worksheets, Sheet1, Sheet2, and Sheet3, exist in the workbook.

The below macro will cut/move the required rows from Sheet1 into Sheet3. Then the blank rows in Sheet1 will be removed.


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.


Code:
Option Explicit
Sub FindMatchingItemNumbers()
' hiker95, 11/30/2012
' http://www.mrexcel.com/forum/excel-questions/672322-need-macro-function-compare-values-columns-then-cut-paste-row-new-sheet.html
Dim w1 As Worksheet, w2 As Worksheet, w3 As Worksheet
Dim r As Long, lr As Long, fr As Long, nr As Long
Application.ScreenUpdating = False
Set w1 = Worksheets("Sheet1")
Set w2 = Worksheets("Sheet2")
Set w3 = Worksheets("Sheet3")
w3.UsedRange.Clear
w1.Rows(1).Copy w3.Rows(1)
lr = w1.Cells(Rows.Count, 1).End(xlUp).Row
For r = 2 To lr Step 1
  fr = 0
  On Error Resume Next
  fr = Application.Match(w1.Cells(r, "H").Value, w2.Columns(1), 0)
  On Error GoTo 0
  If fr > 0 Then
    nr = w3.Range("A" & Rows.Count).End(xlUp).Offset(1).Row
    w1.Rows(r).Cut w3.Rows(nr)
  End If
Next r
On Error Resume Next
w1.Range("H2", w1.Range("H" & Rows.Count).End(xlUp)).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
On Error GoTo 0
w3.Activate
Application.ScreenUpdating = True
End Sub


Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm


Then run the FindMatchingItemNumbers macro.
 
Upvote 0
Your the man! Thank you!!

Hrstyhskr,

I assume that all three worksheets, Sheet1, Sheet2, and Sheet3, exist in the workbook.

The below macro will cut/move the required rows from Sheet1 into Sheet3. Then the blank rows in Sheet1 will be removed.


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.


Code:
Option Explicit
Sub FindMatchingItemNumbers()
' hiker95, 11/30/2012
' http://www.mrexcel.com/forum/excel-questions/672322-need-macro-function-compare-values-columns-then-cut-paste-row-new-sheet.html
Dim w1 As Worksheet, w2 As Worksheet, w3 As Worksheet
Dim r As Long, lr As Long, fr As Long, nr As Long
Application.ScreenUpdating = False
Set w1 = Worksheets("Sheet1")
Set w2 = Worksheets("Sheet2")
Set w3 = Worksheets("Sheet3")
w3.UsedRange.Clear
w1.Rows(1).Copy w3.Rows(1)
lr = w1.Cells(Rows.Count, 1).End(xlUp).Row
For r = 2 To lr Step 1
  fr = 0
  On Error Resume Next
  fr = Application.Match(w1.Cells(r, "H").Value, w2.Columns(1), 0)
  On Error GoTo 0
  If fr > 0 Then
    nr = w3.Range("A" & Rows.Count).End(xlUp).Offset(1).Row
    w1.Rows(r).Cut w3.Rows(nr)
  End If
Next r
On Error Resume Next
w1.Range("H2", w1.Range("H" & Rows.Count).End(xlUp)).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
On Error GoTo 0
w3.Activate
Application.ScreenUpdating = True
End Sub


Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm


Then run the FindMatchingItemNumbers macro.
 
Upvote 0
Hrstyhskr,

Thanks for the feedback.

You are very welcome. Glad I could help.

Come back anytime.
 
Upvote 0

Forum statistics

Threads
1,216,076
Messages
6,128,670
Members
449,463
Latest member
Jojomen56

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top