Hello,
Im new to the Macro scene and i enjoy learning with VBA lately
I've been having some trouble with moving raw data from one work book to another, i was able to move a few items but im stuck with using IF/than statements. ive gone through some threads to try and recreate some but i keep getting errors or i cant think logically. i created a test to run to see if someone might have some better experience/advice. (sorry for caps, coming from home computer)
I WOULD LIKE TO BE ABLE TO CREATE A MACRO THAT COPYS ALL THE DATA FROM AN OPEN SOURCE WORKBOOK TO A NEW TARGET WORKBOOK THAT IS A PRE-MADE TEMPLATE THAT HAS THE MACRO BUTTON ALREADY SAVED AND ALL I WOULD NEED TO DO IS HAVE OPEN THE TEMPLATE FILE AND THE SOURCE WORKBOOK RUN IT AND THEN SAVE AS A NEW FILE NAME.
[TABLE="width: 500"]
<tbody>[TR]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 0"]
<tbody>[TR]
[TD]HOLDER
[/TD]
[TD]ID
[/TD]
[TD]NAME
[/TD]
[TD]DATA1[/TD]
[TD]DATA2[/TD]
[TD]DATA3[/TD]
[TD]DATA4[/TD]
[TD]OLD[/TD]
[TD]NEW[/TD]
[TD]Y OR N[/TD]
[TD]TYPE[/TD]
[TD]INFO1
[/TD]
[TD]INFO2[/TD]
[TD]INFO3[/TD]
[TD]INFO4[/TD]
[TD]INFO5[/TD]
[TD]INFO6[/TD]
[TD]INFO7[/TD]
[TD]COUNT
[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD]Beaver
[/TD]
[TD]AA[/TD]
[TD]AAIRPLANE[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]123[/TD]
[TD]BEAN[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]UMBER[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD]Beaver[/TD]
[TD]AA[/TD]
[TD]AAIRPLANE[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]123[/TD]
[TD]CORN[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]APRICOT[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD]Beaver[/TD]
[TD]AA[/TD]
[TD]AAIRPLANE
[/TD]
[TD="align: right"]10
[/TD]
[TD="align: right"]123
[/TD]
[TD]NONE[/TD]
[TD]CORN[/TD]
[TD]N[/TD]
[TD]ORANGE[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD]Bear[/TD]
[TD]AB[/TD]
[TD]ABOY[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]456[/TD]
[TD]BEAN[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]CHOCOLATE[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD]Bear[/TD]
[TD]AB[/TD]
[TD]ABOY[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]456[/TD]
[TD]CARROT[/TD]
[TD]BEATS
[/TD]
[TD]Y[/TD]
[TD]ORANGE[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD]Bear[/TD]
[TD]AB[/TD]
[TD]ABOY[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]456[/TD]
[TD]CORN[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]APRICOT[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD]Bear[/TD]
[TD]AB[/TD]
[TD]ABOY[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]456[/TD]
[TD]NONE[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]UMBER[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD="align: right"]35[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD]Bear[/TD]
[TD]AB[/TD]
[TD]ABOY[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]456[/TD]
[TD]POTATO[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]
[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD]Bear[/TD]
[TD]AB[/TD]
[TD]ABOY[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]456[/TD]
[TD]TOMATO[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]APRICOT[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]BEAN[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]UMBER[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]CARROT[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]APRICOT[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]CELERY[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]CHOCOLATE[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]80[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]CORN[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]UMBER[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]55[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]NONE[/TD]
[TD]POTATO[/TD]
[TD]N[/TD]
[TD]ORANGE[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]65[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]POTATO[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]APRICOT[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]TOMATO[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]
[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]60[/TD]
[/TR]
</tbody>[/TABLE]
Columns C:G and L:R are all linked to "ID" number.
I would like it to turn out eventually like this below to separate out the "NEW" column and organize the counts but im having trouble splitting it up.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<tbody>[TR]
[TD="align: center"]ID
[/TD]
[TD="align: center"]NAME[/TD]
[TD="align: center"]DATA1
[/TD]
[TD="align: center"]DATA2[/TD]
[TD="align: center"]DATA3[/TD]
[TD="align: center"]DATA4[/TD]
[TD="align: center"]INFO1[/TD]
[TD="align: center"]INFO2[/TD]
[TD="align: center"]INFO3[/TD]
[TD="align: center"]INFO4[/TD]
[TD="align: center"]INFO5[/TD]
[TD="align: center"]INFO6[/TD]
[TD="align: center"]INFO7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]TOTALCOUNT (ALL OF NEW)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]TOTALCOUNT (BEATS ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]TOTALCOUNT (CORN ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]TOTALCOUNT (POTATO ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]TOTALCOUNT (CELERY ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]TOTALCOUNT (TOMATO ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]TOTALCOUNT (CARROT ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]TOTALCOUNT (BEAN ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Beaver[/TD]
[TD="align: center"]AA[/TD]
[TD="align: center"]AAIRPLANE[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]123[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Bear[/TD]
[TD="align: center"]AB[/TD]
[TD="align: center"]ABOY[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]456[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: right"]195[/TD]
[TD="align: right"]195[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]195[/TD]
[TD="align: right"]195[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Bunny[/TD]
[TD="align: center"]AC[/TD]
[TD="align: center"]ACAT[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]789[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]C[/TD]
[TD="align: right"]455[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]205[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
ALL OF THE TOTALCOUNT (ALL OF NEW) GROUP(N:Y) WILL INCLUDE THE ENTIRE "NEW" LIST. [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] ]BEATS, CORN, POTATO, CELERY, TOMATO, CARROT AND BEAN, THEN AFTER IT BREAKS IT UP INTO SEPERATE GROUPS.[/COLOR]
N: ONLY "COUNT" FOR THAT 'ID'
O: ONLY "COUNT" WHEN THE CELL VALUE IS "Y"
P: ONLY "COUNT" WHEN THE CELL VALUE IS "N"
Q: ONLY "COUNT" WHEN THE CELL VALUE IS "APRICOT"
R: ONLY "COUNT" WHEN THE CELL VALUE IS "UMBER"
S: ONLY "COUNT" WHEN THE CELL VALUE IS "ORANGE", "CHOCOLATE" AND "BLANK"
T: ONLY "COUNT" WHEN THE CELL VALUE IS "Y" AND "APRICOT"
U: ONLY "COUNT" WHEN THE CELL VALUE IS "N" AND "APRICOT"
V: ONLY "COUNT" WHEN THE CELL VALUE IS "Y" AND "UMBER"
W: ONLY "COUNT" WHEN THE CELL VALUE IS "N" AND "UMBER"
X: ONLY "COUNT" WHEN THE CELL VALUE IS "Y" AND "ORANGE", "CHOCOLATE" AND "BLANK"
Y: ONLY "COUNT" WHEN THE CELL VALUE IS "N" AND "ORANGE", "CHOCOLATE" AND "BLANK"
Z: BLANK COLOMN TO HELP SEPERATE
Below is the code i have to remove the duplicates and combine some data.
Any help or tips would be greatly appreciated.
Thanks
Im new to the Macro scene and i enjoy learning with VBA lately
I've been having some trouble with moving raw data from one work book to another, i was able to move a few items but im stuck with using IF/than statements. ive gone through some threads to try and recreate some but i keep getting errors or i cant think logically. i created a test to run to see if someone might have some better experience/advice. (sorry for caps, coming from home computer)
I WOULD LIKE TO BE ABLE TO CREATE A MACRO THAT COPYS ALL THE DATA FROM AN OPEN SOURCE WORKBOOK TO A NEW TARGET WORKBOOK THAT IS A PRE-MADE TEMPLATE THAT HAS THE MACRO BUTTON ALREADY SAVED AND ALL I WOULD NEED TO DO IS HAVE OPEN THE TEMPLATE FILE AND THE SOURCE WORKBOOK RUN IT AND THEN SAVE AS A NEW FILE NAME.
[TABLE="width: 500"]
<tbody>[TR]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 0"]
<tbody>[TR]
[TD]HOLDER
[/TD]
[TD]ID
[/TD]
[TD]NAME
[/TD]
[TD]DATA1[/TD]
[TD]DATA2[/TD]
[TD]DATA3[/TD]
[TD]DATA4[/TD]
[TD]OLD[/TD]
[TD]NEW[/TD]
[TD]Y OR N[/TD]
[TD]TYPE[/TD]
[TD]INFO1
[/TD]
[TD]INFO2[/TD]
[TD]INFO3[/TD]
[TD]INFO4[/TD]
[TD]INFO5[/TD]
[TD]INFO6[/TD]
[TD]INFO7[/TD]
[TD]COUNT
[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD]Beaver
[/TD]
[TD]AA[/TD]
[TD]AAIRPLANE[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]123[/TD]
[TD]BEAN[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]UMBER[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD]Beaver[/TD]
[TD]AA[/TD]
[TD]AAIRPLANE[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]123[/TD]
[TD]CORN[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]APRICOT[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD]Beaver[/TD]
[TD]AA[/TD]
[TD]AAIRPLANE
[/TD]
[TD="align: right"]10
[/TD]
[TD="align: right"]123
[/TD]
[TD]NONE[/TD]
[TD]CORN[/TD]
[TD]N[/TD]
[TD]ORANGE[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD]Bear[/TD]
[TD]AB[/TD]
[TD]ABOY[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]456[/TD]
[TD]BEAN[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]CHOCOLATE[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD]Bear[/TD]
[TD]AB[/TD]
[TD]ABOY[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]456[/TD]
[TD]CARROT[/TD]
[TD]BEATS
[/TD]
[TD]Y[/TD]
[TD]ORANGE[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD]Bear[/TD]
[TD]AB[/TD]
[TD]ABOY[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]456[/TD]
[TD]CORN[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]APRICOT[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD]Bear[/TD]
[TD]AB[/TD]
[TD]ABOY[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]456[/TD]
[TD]NONE[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]UMBER[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD="align: right"]35[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD]Bear[/TD]
[TD]AB[/TD]
[TD]ABOY[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]456[/TD]
[TD]POTATO[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]
[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD]Bear[/TD]
[TD]AB[/TD]
[TD]ABOY[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]456[/TD]
[TD]TOMATO[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]APRICOT[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]BEAN[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]UMBER[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]CARROT[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]APRICOT[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]CELERY[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]CHOCOLATE[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]80[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]CORN[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]UMBER[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]55[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]NONE[/TD]
[TD]POTATO[/TD]
[TD]N[/TD]
[TD]ORANGE[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]65[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]POTATO[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]APRICOT[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD]Bunny[/TD]
[TD]AC[/TD]
[TD]ACAT[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]789[/TD]
[TD]TOMATO[/TD]
[TD]BEATS[/TD]
[TD]Y[/TD]
[TD]
[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD="align: right"]60[/TD]
[/TR]
</tbody>[/TABLE]
Columns C:G and L:R are all linked to "ID" number.
I would like it to turn out eventually like this below to separate out the "NEW" column and organize the counts but im having trouble splitting it up.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<tbody>[TR]
[TD="align: center"]ID
[/TD]
[TD="align: center"]NAME[/TD]
[TD="align: center"]DATA1
[/TD]
[TD="align: center"]DATA2[/TD]
[TD="align: center"]DATA3[/TD]
[TD="align: center"]DATA4[/TD]
[TD="align: center"]INFO1[/TD]
[TD="align: center"]INFO2[/TD]
[TD="align: center"]INFO3[/TD]
[TD="align: center"]INFO4[/TD]
[TD="align: center"]INFO5[/TD]
[TD="align: center"]INFO6[/TD]
[TD="align: center"]INFO7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]TOTALCOUNT (ALL OF NEW)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00b050]#00b050[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]TOTALCOUNT (BEATS ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=7030a0]#7030a0[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]TOTALCOUNT (CORN ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]TOTALCOUNT (POTATO ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c55a11]#c55a11[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]TOTALCOUNT (CELERY ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=92d050]#92d050[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]TOTALCOUNT (TOMATO ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]TOTALCOUNT (CARROT ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffc000]#ffc000[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[TD="align: center"]
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]TOTALCOUNT (BEAN ONLY)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]Y[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]N[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]Y + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]N + APRICOT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]Y + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]N + UMBER[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]Y + ORANGE+CHOCOLATE+BLANK[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c5e0b3]#c5e0b3[/URL] , align: center"]N+ORANGE+CHOCOLATE+BLANK[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Beaver[/TD]
[TD="align: center"]AA[/TD]
[TD="align: center"]AAIRPLANE[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]123[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Bear[/TD]
[TD="align: center"]AB[/TD]
[TD="align: center"]ABOY[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]456[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: right"]195[/TD]
[TD="align: right"]195[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]195[/TD]
[TD="align: right"]195[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Bunny[/TD]
[TD="align: center"]AC[/TD]
[TD="align: center"]ACAT[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]789[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]C[/TD]
[TD="align: right"]455[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]205[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
ALL OF THE TOTALCOUNT (ALL OF NEW) GROUP(N:Y) WILL INCLUDE THE ENTIRE "NEW" LIST. [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ff0000]#ff0000[/URL] ]BEATS, CORN, POTATO, CELERY, TOMATO, CARROT AND BEAN, THEN AFTER IT BREAKS IT UP INTO SEPERATE GROUPS.[/COLOR]
N: ONLY "COUNT" FOR THAT 'ID'
O: ONLY "COUNT" WHEN THE CELL VALUE IS "Y"
P: ONLY "COUNT" WHEN THE CELL VALUE IS "N"
Q: ONLY "COUNT" WHEN THE CELL VALUE IS "APRICOT"
R: ONLY "COUNT" WHEN THE CELL VALUE IS "UMBER"
S: ONLY "COUNT" WHEN THE CELL VALUE IS "ORANGE", "CHOCOLATE" AND "BLANK"
T: ONLY "COUNT" WHEN THE CELL VALUE IS "Y" AND "APRICOT"
U: ONLY "COUNT" WHEN THE CELL VALUE IS "N" AND "APRICOT"
V: ONLY "COUNT" WHEN THE CELL VALUE IS "Y" AND "UMBER"
W: ONLY "COUNT" WHEN THE CELL VALUE IS "N" AND "UMBER"
X: ONLY "COUNT" WHEN THE CELL VALUE IS "Y" AND "ORANGE", "CHOCOLATE" AND "BLANK"
Y: ONLY "COUNT" WHEN THE CELL VALUE IS "N" AND "ORANGE", "CHOCOLATE" AND "BLANK"
Z: BLANK COLOMN TO HELP SEPERATE
Below is the code i have to remove the duplicates and combine some data.
Any help or tips would be greatly appreciated.
Thanks
Code:
[FONT=Calibri]Sub CopyColumnToWorkbook()[/FONT]
[FONT=Calibri]Dim sourceColumn As Range, targetcolumn As Range[/FONT]
[FONT=Calibri]Set sourceColumn = Workbooks("dirtydata.csv").Worksheets(1).Columns("B:G")[/FONT]
[FONT=Calibri]Set targetcolumn = Workbooks("cleandata.xlsm").Worksheets(1).Columns("A:F")[/FONT]
[FONT=Calibri]sourceColumn.Copy Destination:=targetcolumn[/FONT]
[FONT=Calibri]ActiveSheet.Range("A1:F10000").RemoveDuplicates Columns:=Array(1, 2, 3, 4, 5, 6), Header:=xlYes[/FONT]
[FONT=Calibri]Dim rng As Range, cell As Range[/FONT]
[FONT=Calibri]Set rng = ActiveSheet.UsedRange[/FONT]
[FONT=Calibri]For Each cell In rng.Cells[/FONT]
[FONT=Calibri]cell.Value = UCase(cell.Value)[/FONT]
[FONT=Calibri]Next[/FONT]
[FONT=Calibri]End Sub[/FONT]