Multiple entries query

  • Thread starter Thread starter K-Man
  • Start date Start date
K

K-Man

Hi,

I have a spreadsheet in which I am querying some data (by VLOOKUP)
from another spreadsheet. My problem is that there might be multiple
entries of the serial number in Column A, however I want to update 2nd
spreadsheet with multiple entries of same serial number, it will only
take the first one on the list and will not update the second or third
entry of same serial no.

For e.g.

A B
1 11
2 12
3 13
1 14
2 15

I want to update both entries of cells A1 and A4 and A5 as new records
on the second spreadsheet.

I hope I explained my issue enough for anyone to help out.

thanks in advance.
 
K-Man presented the following explanation :
Hi,

I have a spreadsheet in which I am querying some data (by VLOOKUP)
from another spreadsheet. My problem is that there might be multiple
entries of the serial number in Column A, however I want to update 2nd
spreadsheet with multiple entries of same serial number, it will only
take the first one on the list and will not update the second or third
entry of same serial no.

For e.g.

A B
1 11
2 12
3 13
1 14
2 15

I want to update both entries of cells A1 and A4 and A5 as new records
on the second spreadsheet.

I hope I explained my issue enough for anyone to help out.

thanks in advance.

So then, is what you want to do is to remove all dupes from the source
sheet and put them on another sheet in the same layout, one record per
row?

Are the records all in A:B?

Will there be multiple dupes of the same serial#?
 
K-Man presented the following explanation :

So then, is what you want to do is to remove all dupes from the source
sheet and put them on another sheet in the same layout, one record per row?

Are the records all in A:B?

Will there be multiple dupes of the same serial#?
Could you lookup a different column?
 
Best done with a FINDNEXT macro.


"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."
 
K-Man presented the following explanation :










So then, is what you want to do is to remove all dupes from the source
sheet and put them on another sheet in the same layout, one record per
row?

Are the records all in A:B?

Will there be multiple dupes of the same serial#?

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Sorry Garry,

The source spreadsheet is pretty extensive with lots of serial number
data and sometimes serial number will be repeated for various reasons
so copying and removing dupes will be labor extensive and will take
too much time..I am looking for an automated way..may be I might have
to write a macro of some sort..I am not that experienced with VB
macros though!

thanks for your input.
 
It happens that K-Man formulated :
Sorry Garry,

The source spreadsheet is pretty extensive with lots of serial number
data and sometimes serial number will be repeated for various reasons
so copying and removing dupes will be labor extensive and will take
too much time..I am looking for an automated way..may be I might have
to write a macro of some sort..I am not that experienced with VB
macros though!

thanks for your input.

I was asking to determine the logic you want to use because, as you
stated, you want to move A1,A4,A5 to another sheet. However, A1 is not
a dupe; it's the 1st instance. I can understand moving its dupe in A4,
but I was confused by your logic in that you did not include A2 (which
is also duped in A5)

So.., state clearly what you have AND what you want so I can help you
get to a solution.
 
Sorry Garry,

The source spreadsheet is pretty extensive with lots of serial number
data and sometimes serial number will be repeated for various reasons
so copying and removing dupes will be labor extensive and will take
too much time..I am looking for an automated way..may be I might have
to write a macro of some sort..I am not that experienced with VB
macros though!

thanks for your input.- Hide quoted text -

- Show quoted text -

I repeat my offer
 
Back
Top