NEED A MACRO FOR EXCEL

[floridagunner]

floridagunner (MIS) 13 Jul 07 9:37
I have a complex problem WITH EXCEL

I have a datasheet with number in one work sheet (sheet 1).

EG:

Account#
12345
45678
52314

In another worksheet (sheet 2) I have have the same account numbers recurring multiple times like this:

12345
12345
12345
45678
45678

What I need to do is write a macro that will look Vlookup the account numbers in sheet 1 from the table in Sheet 2. and if there are duplicates I need the macro to insert additional rows automatically into sheet 1 and bring in the duplicate information as well.

Please Help.
Thanks

 

[PHV]

And what have you tried so far ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[floridagunner]

Right now I tried some formulas that I thought might work but unfortunately I came up abysmally short. I am not really any kind of an expert with macros, but desperately need to do this somehow. I appreciate your help.

Thanks
Adeel

 

[SkipVought]

Hi,

I think what PHV meant was, post specifically what you have that is not working.

You might also take a look at faq68-5829. I could get what it seems you are referring to in about 20 seconds using this approch.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}