So basically at the start of the day I will print a list of numbers and place them in column A on tab "MASTER". Now the list will update automatically in column A in tab "MSINDOOR" . Now I would like the code to match my column A in "MSINDOOR" with column A in "MASTER" and place the unique ones in the first available column in A on tab "For Door Completion".
You could probably use the filter the vba
Range("A1:A8").AdvancedFilter Action:=xlFilterInPlace, Unique:=True to select the unique items and they just copy and paste into a new cell.
Please Login or Register to view this content.
Oh one thing I forgot to add. After it puts the unique numbers in the column "A" on "For Door Completion" can it also put those numbers on the MASTER list so it doesn't print those numbers again?
Add the new line below the existing line:
Please Login or Register to view this content.
it is erroring right therePlease Login or Register to view this content.
Last edited by vitt4300; 01-19-2015 at 01:46 PM.
it says Type mismatch
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
I can't do that, my company will not allow me to upload files.
I could email it but thats about it.
Last edited by vitt4300; 01-19-2015 at 02:14 PM.
Okay then..
Before trying the code below, make sure you give a same column heading to both columns ie in Master Tab and MSINDOOR tab.
I mean the columns you are matching must contain the same headings in their first cell.
Please Login or Register to view this content.
Last edited by Vikas_Gautam; 01-19-2015 at 02:56 PM.
No error on my end. Don't know what to tell you.
Without your workbook to look at it is difficult to say what is causing the error. Best of luck.
If you can't provide a workbook ..
Provide some screenshots if you can. that would help.
So the code is working now, however if there is only 1 number to move then the code errors
Have you tried the one in Post 10...?
Give that a try, if you can.. and share the results...
Try this
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks