Needed macro for entering data into seperate sheets

**Tarana1** · 04-25-2013, 08:02 AM

Hi All,

I am having a table wherein I am having the following columns:

ColA ColB ColC Rank
addf asd asd 1
-- -- -- 2
-- -- -- 3

I want to separate my dataset based onto the rank into different workbooks. Eg. here I want data with rank1, 2 and 3 in three different worksheets.

Any help would be really appreciated!

**arlu1201** · 04-25-2013, 08:37 AM

A few questions -

Once the data is copied to the respective sheet, do you want it to be cleared from the main sheet?

Also is there already data existing in the 3 rank sheets? If so, should it be cleared before fresh data is entered or should the data be entered in the next available row?

Also, do you want the copy paste / cut paste to happen at the click of a button or on the selection of a value from a dropdown for a particular row?

**Tarana1** · 04-25-2013, 11:55 AM

Hi Arlu1201,

Thanks for the prompt response.
1) No, my aim is to have data distributed based n ranks in different worksheets only. So, even if the data in the main sheet is there or not, it doesn't hurt my requirement.
2) No, there is no data existing in the 3 rank sheets, in fact, we need to create new sheets based on the ranks.
3) Answer to your third question is, I will be putting a filter in the main sheet on rank column, then it should pick all rows with same rank and copy those in different worksheet.