Create multiple workbooks

[VBABEGINER]

Hi Team,

i have data from col A to L.

in my col B i have names
abc
abc
abc
xyz
xyz
xyz
xyz
xyz

and in col A i have 3 different names for "abc" and 5 different names for "xyz", and go on till last record of col B.

so i wanted to create workbook "abc" and it should contain their data in that sheet.

can any one pls share the code..

----
For more example-
workbook name - Raw "abc" and this book will contain all the row till col L in this workbook
abc
abc
abc

 

[Fluff]

Firstly I have no idea what you are talking about in that post.
Secondly, it looks like a completely different question, so needs a new thread.

 

[VBABEGINER]

Firstly I have no idea what you are talking about in that post.
Secondly, it looks like a completely different question, so needs a new thread.

Hi Fluff Sir..

No, its not new question.

As im seeking for my answer, step by step when you have given me successful output that time i remember that i forgot to mentioned this to achieve. so like that, im mentioning that along with the main data there is one more sheet in my workbook.

i.e. sheet1 which contains value C3 = Y and C4 = N.

so using data validation on my main sheet i.e. Sheets("Pcode") columns J, K, L.
So user can select the Y or N option in cells..

Pls suggest..

 

[Fluff]

I stil do not understand what you are asking, but this thread is nothing about data validation.

 

[VBABEGINER]

I stil do not understand what you are asking, but this thread is nothing about data validation.

This is my 1st post..

Hi Team,

This is on my main sheet..

i have data from col A to L.

in my col B i have names
abc
abc
abc
xyz
xyz
xyz
xyz
xyz

and in col A i have 3 different names for "abc" and 5 different names for "xyz", and go on till last record of col B.

so i wanted to create workbook "abc" and it should contain their data in that sheet.

can any one pls share the code..


and there is one more sheet named - "Sheet1"

on this sheet, cell C3 = Y and C4 = N

Along with creation of workbook, I want this list (drop-down also) appear from col J,K,L on main sheet..

 

[Fluff]

I know what you wrote in your op, but I do not understand what data validation in another sheet has to do with.
Therefore please start a new thread as requested.