copying from one sheet to another based on cell value

**tinkerbelle** · 07-29-2010, 07:24 PM

Hi Forum, hope someone can help.

I have a spreadsheet and a range of values in sheet1, range A1:J500.

I would like to copy the data from sheet1 where the value in column J is 6 only and put it in sheet2.

Note that row 1 of sheet1 contains a header row and that would need to be copied across to sheet2 also.

All help gratefully received. thanks
Luce

**stanleydgromjr** · 07-29-2010, 08:18 PM

tinkerbelle,

Detach/open workbook tinkerbelle - EF 739500 - SDG10.xls and run macro Copy6s.

Each time you run the macro the rows where column J contain 6, will be copied to Sheet2.

**tinkerbelle** · 07-30-2010, 05:06 AM

Thanks, your answer and solution were great.
Luce

**stanleydgromjr** · 07-30-2010, 06:51 AM

Luce,

Thank you very much.

Come back anytime.

If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.