How can i use a Macro Button to help transfer and sort data from one open workbook to another?

M

mDgo0d4mE

New Member
Joined
Oct 9, 2017
Messages
9
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

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]
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Sort by date Sort by votes
Would this be even possible to complete, Ive been perusing though the forums and google and cant match what im trying to accomplish?
ive been batting my head at this for the past week now.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
How can I transfer values from a column with blanks to a column with no blanks with a prompt using VBA?
Replies
2
Views
715
mcarlyle
M
T
  • Question Question
how can I pull data from one sheet into another using a macro
Replies
0
Views
475
techcurious
T
M
  • Question Question
VBA Code Populate Certain Column Data into Rows in another sheet
2
Replies
12
Views
3K
Zack Barresse
Zack Barresse

Forum statistics

Threads
1,223,954
Messages
6,175,603
Members
452,660
Latest member
Zatman

Share this page

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