Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Copy rows to new sheet based on value in column A

I have a sheet which a person will add data to every day. In the left hand column are the account numbers. I need a macro or VBA to copy the rows of each individual account to a tab (worksheet) with that number and there should be no gaps.

I don't want to use autofilter on the original sheet as this reorders the data and confuses the person who does input.

Is there any command that goes down one row at a time, copies all rows that match a value in column A then puts them in order on a new sheet?

Thanks!

Example:

Account No. Amount

153 50
167 75
175 43
153 66

Copy all rows with instance of "153" into new spreadsheet that should look like this:

Account No. Amount

153 50
153 66


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
Code to copy column in sheet 1 to column in sheet 2 based on matched criteria skitsoni Excel Programming 1 July 14th 12 11:25 AM
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. bertbarndoor Excel Programming 4 October 5th 07 04:00 PM
Copy rows of one sheet into mutiple sheets based on column value Wesley Breshears Excel Discussion (Misc queries) 0 October 18th 06 03:19 PM
MACRO - copy rows based on value in column to another sheet Michael A Excel Discussion (Misc queries) 1 March 5th 05 03:15 AM
MACRO - copy rows based on value in column to another sheet Mike Excel Programming 2 March 5th 05 01:21 AM


All times are GMT +1. The time now is 05:16 PM.

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

About Us

"It's about Microsoft Excel"