Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Okay what i have is an excel spreadsheet with lots of entrys. What i want to do is select all the rows that have identical data in column D. Now this data is a long and random so its not specific as in i cant just go i want all teh 1's and 2's, i need to just find duplicates and export them to another worksheet. Is there a way to make a macro for this so i can run it? I'd really appreciate the help guys as it would make my job much easier. SO once again i need: - macro to search for duplicates in Column D and export the whole row for those cells into another worksheet. Is this possible???? -- boozer ------------------------------------------------------------------------ boozer's Profile: http://www.excelforum.com/member.php...o&userid=34072 View this thread: http://www.excelforum.com/showthread...hreadid=538359 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Boozer,
yes, it is possible, find what you need at: http://www.j-walk.com/ss/ Regards, Ivan boozer wrote: Okay what i have is an excel spreadsheet with lots of entrys. What i want to do is select all the rows that have identical data in column D. Now this data is a long and random so its not specific as in i cant just go i want all teh 1's and 2's, i need to just find duplicates and export them to another worksheet. Is there a way to make a macro for this so i can run it? I'd really appreciate the help guys as it would make my job much easier. SO once again i need: - macro to search for duplicates in Column D and export the whole row for those cells into another worksheet. Is this possible???? -- boozer ------------------------------------------------------------------------ boozer's Profile: http://www.excelforum.com/member.php...o&userid=34072 View this thread: http://www.excelforum.com/showthread...hreadid=538359 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() okay thank you. But maybe im not seeing it or i have searched wrong parameters but i cant seem to find any articles on what i need. Could you please provide a link? -- boozer ------------------------------------------------------------------------ boozer's Profile: http://www.excelforum.com/member.php...o&userid=34072 View this thread: http://www.excelforum.com/showthread...hreadid=538359 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with macro to export data | Excel Worksheet Functions | |||
Macro to add different characters to identical data in a column ? | Excel Worksheet Functions | |||
ASP & EXCEL2003 - RUN-TIME ERROR 1004 in Export method | Excel Programming | |||
Chart appearance using "export" method | Charts and Charting in Excel | |||
export method not working properly | Excel Programming |