Move rows to a new sheet [Closed]

Question

Move rows to a new sheet [Closed]

Report

messi1252 - May 6, 2010 at 09:13 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- May 6, 2010 at 09:52 AM

Hi,

I have an sheet with thousands of rows. I am looking for a way to move all the rows that have similar data in the cloumn A feilds. Hope it is clear. for example;

Column A Column B Column C Column D

aasa Untitled-1.jpg Z:\Home01\aasa.BAH\scan\ 136.7 KB 2/25/2004
aasa Untitled-10.jpg Z:\Home01\aasa.BAH\scan\ 212.2 KB 2/25/2004
aasa Untitled-11.jpg Z:\Home01\aasa.BAH\scan\ 206.4 KB 2/25/2004

aasa Untitled-12.jpg Z:\Home01\aasa.BAH\scan\ 234.8 KB 2/25/2004

ssmm Untitled-12.jpg Z:\Home01\aasa.BAH\scan\ 234.8 KB 2/25/2004

ssmm Untitled-12.jpg Z:\Home01\aasa.BAH\scan\ 234.8 KB 2/25/2004

So when any row having Column A as "aasa", copy all these rows and paste it in a new spreadsheet, and so on for "ssmm" ..etc.
Thank you

Messi

Move rows to a new sheet
Stay on same row when selecting next sheet ✓ - Forum - Excel
If certain 'type' is in col. K have whole row copy to new sheet ✓ - Forum - Excel
Multiple tabs set row count based on sheet 1 ✓ - Forum - Excel
Excel copy row to another sheet based on cell value ✓ - Forum - Excel
Excel if cell contains text then copy row to another sheet ✓ - Forum - Excel

1 reply

Ask a question

rizvisa1 · Answer 1 · 2010-05-06T09:52:03-0400

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

766
May 6, 2010 at 09:52 AM

See this
https://ccm.net/forum/affich-339638-link-data#9

The macro there, will create sheets "aasa", "ssmm" etc ( what ever is in column A) and paste rows that match in those sheets

Move rows to a new sheet [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!