How to capture values from particular cell which are in quotes " "?

[akhan1985]

How to capture values from particular cell which are in quotes " "?

[Glenn Kennedy]

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Also. are you exclusively looking for VBA?

[akhan1985]

HI Glenn,

Thank you for showing interest. I have attached the file.

I need to capture the information of Serial number in " " from E Column

The solution needed Excel VBA

Thank you
Khan



Initial Question:

"How to capture values from particular cell which are in quotes " ",? the cell contains bunch of information.


Need to capture only serial # from " ".

[jindon]

Try

Please Login or Register  to view this content.

[akhan1985]

Hi

I also need Case/Subcase Number from C Column to be displayed against the printer serial #'s and duplicate serial numbers should be removed


Thank you for for your help in advance

[akhan1985]

Hi

I also need Case/Subcase Number from C Column to be displayed against the printer serial #'s and duplicate serial numbers should be removed.


Thank you for for your help in advance

[akhan1985]

Hi Glenn,

Can you please help me with the request.

[Glenn Kennedy]

Sorry, I'm hopeless with VBA....

[akhan1985]

No Problem Glenn !!

[akhan1985]

Can someone please help with my request

[akhan1985]

Can anyone help me in this?

[jindon]

You should understand the time difference.

Deleted the rest.

[akhan1985]

Hi Jindon,

I made the appropriate changes. The code can be found in my attached excel.

I also need Case/Subcase Number from Column C to be displayed against the printer serial #'s and duplicate serial numbers should be removed.

Appreciate your help on this

[jindon]

If you upload a workbook with the desired results, it will be clearer.

I need to go out in 20 min for about 3 hours.
So my reply will be late.

[akhan1985]

Hi Jindon,

I have attached the sheet and my requirement is in Sheet1.

The Case/Subcase Number from Column C to be displayed against the printer serial #'s and duplicate serial numbers should be removed.

The code is is in the workbook which you gave yesterday.

Appreciate your help on this

[jindon]

Any difference between my results and the one in your workbook uploaded?

[akhan1985]

Yes! The case number details i entered manually and the serial numbers reflected with the code you provided.

I need the code to populate the case numbers with serial numbers.

[jindon]

But I don't find any difference.

My result is completely identical to your Sheet1!A.

ColumnC is your result and A is mine. ColD formula compares each result by row and all the rows are True.

[akhan1985]

If run the code you will find the difference.

I need C2,C3,C4 column details (Case/Subcase Number) compare with E2,E3,E3 (serila numbers)

I need the code to populate the case #'s. the sheet contains code only to pull the serial numbers not the case no's.

Please confirm if still need more information .

[jindon]

I don't understand about the difference. All are the same.

Is it different at your side?

I just need to see your EXACT DESIRED result.

[akhan1985]

The desired format I like is Sheet1. The source date is Page1_1 from Column C and E

I have attached sheet of desired format

[jindon]

What is r: in col.A? Where did it come from?

[akhan1985]

It came from Column C of Page1_1 sheet

I have attached the updated file. I need the information in RED from Page1_1 and output should reflect as Sheet1.

[jindon]

OMG!

Now you upload a real data and how anyone can even guess what you have in your brain???

Please Login or Register  to view this content.

[akhan1985]

Sorry for running you around the bushes.

Thank you so much, it worked. A small change is needed.

It deleted all the unique serial numbers. Eg: in below case# we have 4 unique serial #'s but in output we see only 1 which is "LQN4202285"

Similarly, we will have multiple serial numbers in the sheet which linked with 1 Case#. And, also 1 case with 1 serial also linked.

Case/Subcase Number - 123456818

LQN4202285
LQN4202294
LQN4202243
LQN4202282

[jindon]

I have changed the code due to a typo, so copy the code again.

[akhan1985]

It worked.

Thank you so much for your valuable time and effort.

Thank again Jindon!!!!!

[jindon]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[daboho]

i not understand exaxtly what you want but i am compare Jindon code with col c not to duplicat

Please Login or Register  to view this content.