Copy Specified Range of a Sheet to Another Sheet

[roypabitra]

Respected Sir

I have a data file where have so many data , I Want to Copy specified specified Range to select and copy to another sheet a xls file have been attached for reference where two sheet one is Data Sheet and is Result sheet i.e. I want to copy range through vba from data Sheet

Please share vba code so that I complete my job.

Thanks & Regards

Pabitra Roy

 

[vletm]

roypabitra
Yes, 'DATASHEET' and 'RESULT' has some differences, maybe same data..
Are there any clear rule of copy?

 

[roypabitra]

Yes Sir, if criteria starts from ABC Ltd and copied all the row upto customer total of end of ABC Ltd a

 

[vletm]

roypabitra
Do You write about same file, OUT12.xls?
If so, then something is hiding.

 

[roypabitra]

Yes Sir

 

[vletm]

roypabitra
hmm ... if same file and something is hiding ...
then ... there is something which would be more clear.
Of course, I could start to guess,
but You should able to give clear rules.

 

[charlesdh]

Hi,
The user needs to let be known if the "Result" sheet will have a header as he has indicated in the workbook provided. Also need to know if each "Criteria" will have it's own worksheet and Header.

Charles
vletm, hope you do not mind if I look at this.

 

[vletm]

charlesdh
If You could get proper clear answers and help him
that'll be more than okay.

 

[charlesdh]

Hi,
I have a partial code completed.
However,I'll complete the code once the user lets us know
what he wants.

Charles

 

[roypabitra]

Respected Charlesdh

I want to copy the data to another sheet in criteria matched