Display non-redundant data list
hi everyone.
Please help me on this.
i have a macro which get all sales order in another excel file and put it in another sheet example sheet1. then i will generate list of the sales order from sheet1 in sheet2.
the problem is i don't want the sales order to be redundant in the list.
example sales order:
SO001
SO001
SO002
SO003
SO003
SO004
I want the list to be like:
SO001
SO002
SO003
SO004
please help...=(
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
hi. i think this is manual. i mean how do i embed it into the vba?
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
sheet1 is where the list will be.
when click get sales order it will copy all sales order in masterdata to list.
the list-down at sheet1 is based on sheet2.
hope you understand what i mean.
Does this help?
Please Login or Register to view this content.
after searching through the net. i saw something using example
it store unique string character.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