Hi,

I am looking for a macro for copy and pasting data based on condition. The
format of data id pasted below.

FSN Plan Name Rate Hrs
1112 ABC Tim $12.00 32
1112 DEF Nick $12.00 176
1245 CCC Tommy $38.00 67
1356 DDE Ricky $25.00 168
1112 FGT Tim $14.00 145

What I require is that entire data based on FSN No. should be pasted in the
diffrent sheet whose name is based on FSN. For example all data of FSN 1112
should be copied and pasted in different sheet where sheet name is FSN 1112.
And data of FSN 1356 should be copied and pasted in sheet FSN 1356.

It would be great if the sheet named on FSN is automatically created.

I request all the member to help me.

Regards

Prem

I'd keep the data in one worksheet.

Then use data|filter|autofilter to see the info that I want. I think you'll
find that this is the easiest solution.

But if you really, really must. Keep the data in one worksheet and refresh the
worksheets whenever you need (not while doing input--just run the macro when
you're ready).

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Prem wrote:

Hi,

I am looking for a macro for copy and pasting data based on condition. The
format of data id pasted below.

FSN Plan Name Rate Hrs
1112 ABC Tim $12.00 32
1112 DEF Nick $12.00 176
1245 CCC Tommy $38.00 67
1356 DDE Ricky $25.00 168
1112 FGT Tim $14.00 145

What I require is that entire data based on FSN No. should be pasted in the
diffrent sheet whose name is based on FSN. For example all data of FSN 1112
should be copied and pasted in different sheet where sheet name is FSN 1112.
And data of FSN 1356 should be copied and pasted in sheet FSN 1356.

It would be great if the sheet named on FSN is automatically created.

I request all the member to help me.

Regards

Prem

--

Dave Peterson