Copying specific range to another sheet

[SVShankar]

How can I select a group of rows that have specific value in a cell/column then copy that range to a new sheet within the same workbook?

[JBeaucaire]

Are you looking for worksheet formulas to update another sheet in real-time based on some search/filter criteria? Or are you thinking of an on-demand macro?

Tell us more ...or click on GO ADVANCED and use the paperclip icon to attach a sample workbook showing example data and example "results" so we can see your work process.

[SVShankar]

attached is the excel sheet.

Thanks for your help

[Paul]

Hi SVS,

On the Original Datas sheet:
1. Select cells A5:G71
2. Click Data -> Filter -> Autofilter
3. Click the drop-down next to Volume in F5 and select (Custom...)
4. Change the first drop down (should default to 'equals') to 'is less than or equal to' (or just 'is less than')
5. Type 300000 in the box to the right of that, then click OK
6. Select the filtered rows of data
7. Press F5, then click the 'Special...' button
8. Select 'Visible Cells Only' and click OK
9. Press CTRL+C (or Edit -> Copy) to copy
10. Go to Output sheet and in cell A2 press CTRL+V (or Edit -> Paste)

[JBeaucaire]

As long as the OUTPUT sheet exists, this macro will ASK you what your cutoff value is and then copy all the rows on the Original Datas sheet below that value to the OUPUT sheet...any data on OUTPUT will be replaced.

Please Login or Register  to view this content.

[SVShankar]

that works. one more option? what about 2 or 3 criterias? say <300000 and on specific date. my point is instead of doing an autofilter and copying things i want to create a macro where you input the field and it will show you the extracts in separate sheet. i would request you to not to input the data but check the 3 criteria in the macro itself and copy things to the new sheet.

thanks