I have 12 worksheets ( one for each month ) i have a list of names in the column "K" in all the 12 sheets. I have a separate sheet apart from the 12 sheets in the same workbook named as "Names" in which i want all the names from "K" column of all the sheets to be combined and i want the duplicates also to be removed .
Try this udf
In sheet you want merge
=Iferror(xx(row(a1);select col k in sheet1 and press F4;sheet2 col k press f4,etc in sheet you want))
Please Login or Register to view this content.
"Presh Star Who has help you *For Add Reputation!! And mark case as Solve"
VBA macro on button on sheet1.
Sheet("Join") is empty at present.
Transfers all columns "A" to Sheet("Join")col "A" then places uniques in column "D"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks