I want to create multiple worksheets based on similiar data from attached excel sheet. Similiar data should be clubbed together in same worksheet.
For eg. data from column 'I2' to 'I4' with number /PNS/TN/02208 should go in one excel sheet and similiarly multiple worksheets will get created for other similiar data too. Hope my requirement is clear to you.
Attached sheet for your doing the needful.
Thanks & Best Regards,
Javed Ali Sayed
The attached file is not (yet) and Excel file, so I suggest your rephrase your question for others to understand better.
If I understand you correctly you want to open the CSV file and create a workbook with a number of sheets that answer to your criteria.
Don't know if I have the correct answer for you but I will try and see if I can help
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Sorry Brother. It's a CSV file. Yes I want to open the CSV file and create workbooks based on details provided in column 'I'.
For eg. it should create a workbook by name '02208' and should have all data related to '02208'. Currently we are opening the file
deleting other data and saving the new workbook by '02208'. Its all manual efforts.
Similiarly multiple workbooks should be created for 02291, 02292 and so on.
Everytime we get this CSV report from an application and we need to create multiple files based on data in column 'I'.
Hope my question is clear.
Thanks.
Okay, that's clear, but the next csv file you get, will there be identical values in column "I" as the previous one? I am asking this because then you do not create a new workbook but open an existing one and append the new data to the workbook 02208 or 02291 from the previous run.
Re: Multiple Sheets creation based on data
Thanks for your response. There won't be identical values in column "I" everytime when CSV file is generated. The data may differ in column 'I'.
Okay, clear, tank you for updating
What about the path reference in I? and the otherone?
well i did not understood your question. whatever data (from column 'A' to 'H') corresponding to the number in column 'I' after /PNS/TN/, a new workbook to be created and it should have all the contents as below. Similiarly workbooks to be created for other 02291, 02292...............
DWG/DOC NO REV DRAWING/DOCUMENT TITLE ISSUE REASON DISCIPLINE DOC. TYPE FILE PATH REMARKS Out.Tr.Ref
4100-FDTY-2-80-0001-001 2 General - Electrical Symbols & Legends IFA 2 80 C:\Users\Rasheed.Veettil\Documents\Assai\GC171086D0-PNS-TN-2208\4100-FDTY-2-80-0001-001-2.zip /PNS/TN/02208
4100-FDTY-2-80-0001-002 2 General - Electrical Symbols & Legends IFA 2 80 C:\Users\Rasheed.Veettil\Documents\Assai\GC171086D0-PNS-TN-2208\4100-FDTY-2-80-0001-002-2.zip /PNS/TN/02208
4100-FDTY-2-80-0001-003 2 General - Electrical Symbols & Legends IFA 2 80 C:\Users\Rasheed.Veettil\Documents\Assai\GC171086D0-PNS-TN-2208\4100-FDTY-2-80-0001-003-2.zip /PNS/TN/02208
I mistook the contents in Column "I" of the cells for file paths, my mistake.
Hi, just to tell you I'm almost there.
Testing the final steps for you.
Okay, here's the file.
It will create all the workbooks in the same folder as where you place this file.
To change; modify the path in the variable destFolder (DO NOT FORGET THE FINAL BACKSLASH)
I have attached two of the exported files
The processing progress is shown in the status bar in percentages
Hope this is what you want.
Dear Brother Keebellah,
Your are a star. Genius. Loved it. Awesome. Thank you very much. GOD bless you.
Best Regards,
Javed
I made some modifications for the folder selection and so.
I hate hard coding paths in VBA, it's against my rules
Thanks. One more help required. Can we have the output files in csv format instead of xls please.
No os the time for you to start working on your VBA skills, create the new workbook as it is now and the save it again as CSV file.
part of the code looks something like this
Replace the code in your module with the red lines
Please Login or Register to view this content.
I can't leave it to you, there are one or two things you need to know and edit, so here is the modified file
Thank you very much. I know only basic excel. Appreciate your efforts.
Best Regards,
Javed
Hope for yourself that you can find the time to play around with VBA, it is fun, but ... you need time , very much time, and patience and your own imagination is the only limit
Happy coding and good fortune.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks