Cut multiple rows into new spreadsheet based on cell values

[sarah412]

Hi,

I'm new with macros and am trying to cut rows from sheet2 to a new sheet based on the values in column a. In Column A there are numbers (1-however many...sometimes 5 sometimes 80) and i want each number to be on its own tab (there are five columns of information for each row...not sure if that matters or not). Each number may have multiple rows associated with it so i would like to cut all those rows and paste them into a new sheet.

Can anyone please help??

 

[dbDamo]

This is an Access forum but I'll provide you with this link which should be what you're after - http://www.excelforum.com/excel-pro...create-new-sheet-based-on-value-in-cells.html

 

[Brianwarnock]

This is an Access forum but I'll provide you with this link which should be what you're after - http://www.excelforum.com/excel-pro...create-new-sheet-based-on-value-in-cells.html

This Forum does have a subforum for Excel , however the forum you pointed to is excellent.
Note that the code copies the data, it does not remove it from the original sheet. I also prefer that as I would like to keep the original until I know all is well.

Brian

 

[sarah412]

Oh great thank you for your help!!