dear all,
since i am new with vba stuff need some help on below situation
I have master sheet where in column a has names, All I want is filter name of each name and copy and paste the data into new workbook with the name of filtered name and with filtered names as sheet name
like if filter with rishi then new work book with name of rishi and worksheet name rishi and in there rishi names filtered data
pls find below is the attached dummy data
many thanks
Rishi Saw
Maybe:
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 07-11-2014 at 06:51 AM.
Re: vba code for copy specific data to another sheet
hi
Check attachment..
Filter the data & double click cell A1, new file will be created in same folder.
Cheers!!
no working creating loads of sheet
i only want three sheet with name of ( for this specific attached sheet) rishi, kumar and saw
and rishi sheet will contain only data which is name (column a ) is "rishi"
Hi, John,
using SaveAs and assuming that a user who indicates 2007/2010 as used Excelversion uses *.xls as Standard File is a bit off the target for me and maybe one reason for an error (maybe refer to Ron de Bruin on SaveAs from 2007 on).
Besides: building an array with unique names and applying the Autofilter while looping through the array could prove to be a far more elegant way.
Ciao,
Holger.
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Try:
Please Login or Register to view this content.
Good points Holger. I definitely will refer Ron de Bruins SaveAs.Originally Posted by HaHoBe
Hi, rishikrsaw,
both procedures go into the same Standard Module:
Please Login or Register to view this content.This will take the path where to save the workbooks from the workbook with the code as well as when trying to make up what extension to use for the new workbooks.Please Login or Register to view this content.
Ciao,How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Holger
Did you tried solution given by me?
thank you its working now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks