Please Write code for respective Description

Firstly Thanking this Group for helping me in before posts

Entire program should be based on Column A ,as there are thousands of rows & columns

1)Column A Different category number which are of same category ( Example : Sheep ( count 30 ) , goat ( count 60 ) ...... ) in the similar way Column is filled based on that where other rows and columns are arranged .

2)At the start code should check total number entries in Column A & how many same type of entries are present in Column A

3)Now consider column A consists of ( eg: Sheep ( 300) , goat ( 120) ,camel ( 120) , dog ( 60 ) ) in this example i need all sheep ( 300 ) & Goat + Camel + Dog (120+ 120+60 ) = 300 as new sheets in which Column A should get deleted after New workbook is made ( Sheet should not Exceed more than 300 )

(Here it should Check the totals of different category entries whether they can set in one sheet or not )

Note :If same category i.e sheep (280) it should not get splitted , it should be on same work book )

Exceptional Case(this should work only if same category exceed more than 300 i.e if goat is 700 it should get into 3 sheets (300 +300 + 100 ) )

any queries plz ask i need this code ASAP

sai0449,

If you require something to be set up from scratch, without showing us what you have tried yourself thus far, I would kindly suggest you either close this Thread here, and post it in the Commercial Services Forum, or consider another approach.

Regards

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

Originally Posted by sai0449

you only suggest good title :@ thankyou

What are you trying to do? Use that for the title

Chicken and egg situation ... catch 22, if you prefer. If you're not going to try anything for yourself, there is nothing we can help you with.

You have not provided a sample workbook, no worksheets, no structure, no data, no formula, no formatting, nothing, nada, zilch ... or is that labouring the point? Oh, and no attempt at a macro to achieve what you want.

So you want us to take a very broad description of your problem, produce all those missing elements, and then develop and test a solution. Really?

Go to the Commercial Services forum, offer some points to make it worth somebody's time, and you will get a solution from some of the forum's best contributors.

Make a bit of an effort and you might get some interest and help here

Hello sai0449,

Please do not take offence to my previous post, or to what TMS has replied to your thread.

We are trying to help or guide you to a possible quick solution to your issue.

Regards.

i will attach excel files so that some one will help thank you



Kindly follow the same steps and need the out put file and code (as mentioned in the post dont mind about the data )