Copy the data from Master file and paste into individual excel file as per criteria

Hi,
. I cannot help you with Pivot Tables.
. Copying data from a Master file based on criteria and pasting into individual excel ( sheets? Or File ?? ) is something me and many people here can do..

. But in any case, I do not think you have given anything like enough info for anyone to help..in fact you have given next to nothing!!

. You need to provide a good “picture” BUT NOT IMAGES of what you have , and then what you want.

. You should produce sheets with reduced test data. They should reflect the situation before and then after the running of any code.

So: -

. The Before or Befores, should look just as it / they does before running of any macro.
.
. The After or Afters, should be hand filled by you so that it they / looks exactly as you want it to After running of any macro, based on the actual sample data in the Before / or Befores
. Make sure there is just enough data to demonstrate your need. Remember to desensitize the data if necessary.

. If you can give a clear picture of what you want , with reduced test data, and no one else picks the Thread up in the meantime, then I will take a look tomorrow

Alan

P.s.


To upload Files : ( Most people use Method 2 )
. 1 ) use the Forum Tools in my signature to produce screen shots we can copy to a spreadsheet ( NO IMAGES ! )
. 2 ) Post Files
. 2 a) To Attach a sample workbook:
View Pic
http://www.excelforum.com/members/da...ch-a-file.html
http://tinyurl.com/oenwprw
. 2 b) Send over a file sharing site, such as this free thing
Box Net,
https://www.box.com/
http://tinyurl.com/7chr7u8
. Remember to select Share and give the link / links they give.

Hi, Good day to you.

Originally Posted by Vikas_k

.....

1) I have Attached Excel file named as "SAMPLE Master Data", there are 5 sheets one of them is "master data" and others are Pivot sheets.......

. Thanks for the File.
. I am sorry but I still do not understand fully your requirement.
. (Possibly this is because I do not understand Pivot Tables )
.
. I asked you for Before and afters.
. Possibly what you have supplied me with, is what I meant by a before.
.
. I would like you to produce one or more “Afters”, which you fill in manually yourself to show exactly what it is that you want the Macro to do. Remember it , or they, they should be based on the example data you have given in the before. Then when I re-read what you have written I may be able to see more clearly what it is that you want.

Thank you
Alan
.

Hi Vikas,
. Thanks for the extra info.
. That makes it very clear

Originally Posted by Vikas_k

....
If you do not understand Pivot tables then just assume these are normal worksheets..There is no concern with any pivot table.....l

... That is what I was hoping, so thanks for confirming that. So I will assume I simply copy those sheets.

. I will write the code such that it should work with any amount of Pivot table sheets. Indeed you may include any other sheets and they will similarly be copied to the "Vertical" File
. I will write the code such that a new File is created, should any "Vertical" File not exist. Otherwise the existing Files will have the sheet "Master data" updated


. I will post again if I have further questions or when I have a code written for you.
Alan

Hi Viskas,

. Here is a code to circumcise your “Vertical” and make new Files with your cut-off bits. ( Apologies if my English is not perfect ) .
.
. I find it helpful to put in words what is going on

. Some general Points then first.
.
. There are lots of unnecessary extra steps and comments in the code I need to remember what is going on. It is easy to simplify the code if you wish when you are happy with it.
.
. At Excel Forum I can edit my posts for some time after posting, and typically do so to make corrections, Typos etc. So it is worth coming back and getting a fresh copy should you be using the code in the Future.

. The code is here:
http://www.excelforum.com/developmen...ml#post4182410
. And here.
http://www.excelforum.com/developmen...ml#post4182417
....

. – it was necessary to split the code into two posts to fit it in. However it is one code and you should copy both parts into the same Module, and the second part should go directly under the first part.

. Some detail to the Code.

Rem 1) Initial sheet info, Importantly Copying entire data from Master Data to an Array ( arrIn() ). As much as possible is then done “internally” away from the sheet
Rem 2) if necessary, a Folder Viskas CircumcisedVERTICALs is created in the same directors ( as defultPath ) in which the Master file is found.
Rem 3) data in VERTICAL column is considered and eunique Array ( eunuch() ) produced from that.
. Rem 4) Main Outer loop for going through copying data to “vertical” workbooks
. 4a) Indicies are obtained for the “rows” required in each “vertical” workbook
. 4b) An Output Array for the “vertical” is made. This "majic bit I still do not understand .
. http://www.excelforum.com/excel-new-...ba-arrays.html
Rem 5) An Inner loop will produce if necessary new circumcised “Vertical” Files. It will be assumed, for now, that should a File already exist then it has all the required sheets.
. 5a). For the case the Files exist, the Master Data sheet is emptied of Data
. 5b) For the case that the File does not exist, the File is created with no data in Master Data sheet
. 5c) The filtered Data from Master Data sheet in the Master File is placed in Master data sheet


. I believe I achieve the results you want, here for example just a small extract of your supplied Master File Master Data Sheet
Using Excel 2007

Row\Col	O	P	Q	R	S	T
1	ACTIVATED_OB	LEGAL_ENTITY	GROUP_NAME	VERTICAL	HQ_CIRCLE	REGION
2	1.00	0	abc	System Integrators	Cicrle M	0
3	5.00	0	xyz	System Integrators	Cicrle B	0
4	5.00	0	vdfd	System Integrators	Cicrle D	0
5	2.00	0	effew	System Integrators	Cicrle M	0
6	17.00	0	abc	Strategic	Cicrle B	0
7	3.00	0	efr	Strategic	Cicrle M	0
8	6.00	0	abc	Strategic	Cicrle C	0
9	4.00	0	eefr	NGN	Cicrle C	0
10	0.90	0	efww	NGN	Cicrle B	0

Master Data

...
And after running the code, here is a small extract of one File , your Strategic “vertical”,
Using Excel 2007

Row\Col	O	P	Q	R	S	T	U
1	ACTIVATED_OB	LEGAL_ENTITY	GROUP_NAME	VERTICAL	HQ_CIRCLE	REGION	OB_CREDIT_CIRCLE
2	17.00	0	abc	Strategic	Cicrle B	0	Cicrle KL
3	3.00	0	efr	Strategic	Cicrle M	0	Cicrle B
4	6.00	0	abc	Strategic	Cicrle C	0	Cicrle H
5
6

Master Data

. The above File is found in a Folder with the name “ViskasCircumcisedVERTICALs”. This File also contains all the Pivot Sheets.
. If you wish to add Pivot Files in the future to the Master file, you should delete all the Circumcised “Vertical” Files in Folder, “ViskasCircumcisedVERTICALs”. And the program will on the next run produce the Files a fresh with all Pivot Sheets in. Alternatively you can delete the entire folder , “ViskasCircumcisedVERTICALs”, which on the next run the program will make a fresh along with the New files within it.

. See how you get on and then please reply back and share your findings, and / or ask if you need further help in applying the code.

. Good day to you. Hope your circumcised verticals meet your requirement
Alan Elston
Bavaria
Germany.

Hi Viskas_k

Originally Posted by Vikas_k

.....
Thank you very much, I will verify this code and will revert you soon
......

. You are welcome.
. Look forward to you "reverting" and look forward to hearing from you
Alan

Hi Viskas,

Originally Posted by Vikas_k

....Superb. Its worked for me...

. Thanks for the feedback and kind words. Always welcome.
.
. I was pleasantly surprised that you were able to take what was quite a long complicated code and get it up and working in your Workbook.
.
. There can always be unexpected problems when using real and larger test data. Glad you appreciated the many explaining comments. They may help you to track down and modify the code, should any problems occur later.
.
. If i can help any further report back. If you find any useful additions / modifications to the code which might help its implementation when others may have a similar requirement then please post back any relevant suggestions

. Best wishes and wish you further success in using the code.

Alan