Help with formula that looks up numbers

**Badvgood** · 02-26-2007, 07:12 PM

I need a way of searching / matching sheet 1 column D for a invoice number, then searching sheet 2, column I for the same invoice number.
Once all the matches are found I need the values that correspond that invoice number drawn together onto one spread sheet.
The values I need shown in red text
This needs to happen for all invoice numbers that are matched automatically.

See that attached filr for more info.

Any ideas on how to go about it?

Regards BVG

**Bryan Hessey** · 02-26-2007, 07:33 PM

Originally Posted by Badvgood

I need a way of searching / matching sheet 1 column D for a invoice number, then searching sheet 2, column I for the same invoice number.
Once all the matches are found I need the values that correspond that invoice number drawn together onto one spread sheet.
The values I need shown in red text
This needs to happen for all invoice numbers that are matched automatically.

See that attached filr for more info.

Any ideas on how to go about it?

Regards BVG

Hi,

I hope that you know a little VBA.

As a start, Record a macro, apply AutoFilter to the first sheet, column D, and copy the displayed rows to the new worksheet, then apply autofilter to the second sheet, column I, and copy all displayed rows to the worksheet as required.

If you do not want to use VB code then follow the same Filter & Copy-Paste procedure manually.

hth
---

**Badvgood** · 02-26-2007, 07:44 PM

Sorry I know nothing of VBA, but if thats what I need to learn it can be done.

Thanks for the help,

Regards BVG

**Bryan Hessey** · 02-26-2007, 09:01 PM

Originally Posted by Badvgood

Sorry I know nothing of VBA, but if thats what I need to learn it can be done.

Thanks for the help,

Regards BVG

Hi,

the recorded macro is always a good place to start for most tasks required, then you can read and modify (or have modified) that code as required.

http://www.excelforum.com/showthread.php?t=584092
lists many good references, especially for VB tutorials etc, and when you get stuck there's always the Programming forum.

---