Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Macro or method for identical data selection/export


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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 258
Default Macro or method for identical data selection/export

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Macro or method for identical data selection/export


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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 258
Default Macro or method for identical data selection/export

Hi,

http://www.j-walk.com/ss/excel/tips/tip47.htm

you can adapt it to your needs.

Regards,
Ivan

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with macro to export data Mayte Excel Worksheet Functions 2 April 27th 08 05:07 AM
Macro to add different characters to identical data in a column ? Steve Excel Worksheet Functions 4 December 15th 06 10:33 PM
ASP & EXCEL2003 - RUN-TIME ERROR 1004 in Export method Mau[_3_] Excel Programming 0 September 12th 05 09:23 AM
Chart appearance using "export" method Alex St-Pierre Charts and Charting in Excel 4 December 3rd 04 03:29 AM
export method not working properly Malone[_2_] Excel Programming 2 December 24th 03 08:34 PM


All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"