Mushfique Khan
asked on
MS Excel Question
From a big CSV file, I've to extract expertise of people, residing under Title header, e.g,, need to copy all PHP folks into another sheet and same for other expertise too, like Designers to another sheet and so on and so forth.
Headers are First Name, Last Name, Email & Title.
Please do assist here, thanks in advance.
Headers are First Name, Last Name, Email & Title.
Please do assist here, thanks in advance.
Steven Harris
Can you upload a sample file for us to work with?
ASKER
uploaded, need to segregate people on the basis of their expertise.
test.csv
test.csv
Can you be a little more specific? Where should this data go exactly? If an existing location, should it overwrite everything in the destination? Also, what version of Excel are you using? Will this file be open already, or do you want to choose it from a file dialog picker, or does it reside somewhere you already know? Please give as many details as possible.
Regards,
Zack Barresse
Regards,
Zack Barresse
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
firefytr ... task is to segregate on the basis of expertise ... that's it, enable us to contact them accordingly, otherwise will be a spam for others ... is this clear, now how you would like to do this task ... up to you ... we are only interested in the bottom-line; people divided/segregated on the basis of their title/expertise.
Please check the attachment, this is a CSV file.
Please check the attachment, this is a CSV file.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for this Zack, if I couldn't clarify, let's try one more time:
You can see my excel sheet (test.csv), has 4 columns, attached is what we are trying to do, please have a look and update ... whatever best way to achieve this, just did for 3 titles only.
Do update, if still it's not good ... :-(
test2.xlsx
You can see my excel sheet (test.csv), has 4 columns, attached is what we are trying to do, please have a look and update ... whatever best way to achieve this, just did for 3 titles only.
Do update, if still it's not good ... :-(
test2.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi mkhandba,
Please provide sample expected output for the sample input you've provided.
And I suggest you do this wherever appropriate, when raising questions in future, in your original post, so experts can see exactly what you're after, and they can test their solutions against your input/output data to see if they work before they post answers. A bit of extra time spent up front, can save a lot later.
A "picture's" worth a thousand words.
Thanks.
tel2
Please provide sample expected output for the sample input you've provided.
And I suggest you do this wherever appropriate, when raising questions in future, in your original post, so experts can see exactly what you're after, and they can test their solutions against your input/output data to see if they work before they post answers. A bit of extra time spent up front, can save a lot later.
A "picture's" worth a thousand words.
Thanks.
tel2
Sorry mkhandba - looks as if you may have pre-empted my last post, by 8 mins.
ASKER
But Zack, can you tell me how to write/code this code in excel, where to write this :-( have no idea, never did this.
Sure. It goes into a standard module. You'll need to go into the Visual Basic Editor (VBE) first. To get there hit ALT + F11. If you have the developer tab showing (doesn't show by default, right-click the ribbon and customize to check it) you can click the Visual Basic button.
Hit CTRL + R to show the Project Explorer (if not already showing). Find your project (aka workbook). There are a few ways to insert a standard module. Either right-click the project and select Insert, Module, or with it the active project go to the Insert menu. Paste the code in there. Put your cursor in the 'SegregateByTitle' routine and press F5 to run it.
HTH
Zack
Hit CTRL + R to show the Project Explorer (if not already showing). Find your project (aka workbook). There are a few ways to insert a standard module. Either right-click the project and select Insert, Module, or with it the active project go to the Insert menu. Paste the code in there. Put your cursor in the 'SegregateByTitle' routine and press F5 to run it.
HTH
Zack
ASKER
thanks Zack ... let me try, will get back in a while :-)
ASKER
Here are the steps:
1. Alt+F11
2. Ctl+R ~~> shows my sheet
3. on my sheet, Right Click ~> Insert ~> Module
4. Copy/paste this complete code: Sub SegregateByTitle() ... to ... End Sub
5. place the cursor on SegregateByTitle() ... and press F5
6. got this error ... attached
What I'm doing wrong here ... :-(
error.JPG
1. Alt+F11
2. Ctl+R ~~> shows my sheet
3. on my sheet, Right Click ~> Insert ~> Module
4. Copy/paste this complete code: Sub SegregateByTitle() ... to ... End Sub
5. place the cursor on SegregateByTitle() ... and press F5
6. got this error ... attached
What I'm doing wrong here ... :-(
error.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
would like to test this ... thanks Zack and sorry for the delay.