Split data in excel by freezing column to multiple sheets

[abbyagarwal]

Hi,

I am looking for the solution on splitting the data.

[TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl63, width: 64"]Product[/TD]
[TD="class: xl63, width: 64"]Store 1[/TD]
[TD="class: xl63, width: 64"]Store 2[/TD]
[TD="class: xl63, width: 64"]Store 3[/TD]
[/TR]
</tbody>[/TABLE]

Above are the headers in my excel.

I want separate sheets for Store 1 , Store 2 and Store 3 with the common factor as product in all sheets.

Please let me know how it is possible apart from copy and paste job.

Thanks.

 

[PhilS2520]

Hi abbyagarwal,

I see this is your first post, so I will say welcome first.

Your post leaves a lot to understan. Where is the data? In One sheet and you want to convert it to multiple sheets?

If this is the case, and you do not want to copy and paste (which is the better solution IMHO) you can use something like
In the worksheet for Store 1 =<NameOfTheSheetWhereTheDataIs>A1 and that will copy the value from cell A1 to that worksheet. You will this for all the cells you need to copy to the new worksheets, and after you are done you can save as values.

I truly can not see what you are trying to do, so my solution might be based on the information you provided. In the future, try and describe what you are trying to do so that better answers can be given.

 

[abbyagarwal]

Thanks Phil for the welcome. Also thanks for the help you provided.
Now coming to question,

What i am trying to do here is split the data as per columns where A = product coloumn is a common factor.

So i want to make 3 different sheets which has product as common factor and store name as individual factor. So that i can send the newly created workbook to store associated without actually have to share the entire data between stores.

Let me know you find the description helpful now.

Thanks.