I want to find the supplier number that exist in tabel 2 adn copy it
to my tabel 1.

To do that I need to comapre both tabels, 1 and 2 in steps:

1) compare the column - material number in tabel 1 and 2.
2) Compare the dates. In tabel 1 I have the date where the compan
bought the material.
IN tabel 2 I have the dates (valid from .- valid to) where the compan
was buying for a certain supplier.

The dates from tabel 1 need to be in between the dates in tabel 2, fo
example:
If tabel 1 date is 3-february-2003, I need to find which supplier wa
valid in this period. and so on

Please take a look in the excel where I have the 2 tabels and it i
easy to understand hte problem

I dont believe the Macro is difficult to write, but I do not know ho
to do it

I really appreciate any help
Thanks a lot in advance
Mart

Attachment filename: forum excel- macro problem.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=65361
--
Message posted from http://www.ExcelForum.com

it's not a macro but a real nifty tool. and it's free.
go to http://www.jkp-ads.com/Download.htm
it works like excel find but it searches ALL sheets and
shows a list of where it found it all. click on a member
of the list and it takes you to it where ever it is. click
another member of the list and boom - you're there.
Great tool. everyone should get it. downloads as a zip.
easy to install. even puts an icon up.
-----Original Message-----
I want to find the supplier number that exist in tabel 2
adn copy it
to my tabel 1.

To do that I need to comapre both tabels, 1 and 2 in
steps:

1) compare the column - material number in tabel 1 and 2.
2) Compare the dates. In tabel 1 I have the date where
the company
bought the material.
IN tabel 2 I have the dates (valid from .- valid to)
where the company
was buying for a certain supplier.

The dates from tabel 1 need to be in between the dates in
tabel 2, for
example:
If tabel 1 date is 3-february-2003, I need to find which
supplier was
valid in this period. and so on

Please take a look in the excel where I have the 2 tabels
and it is
easy to understand hte problem

I dont believe the Macro is difficult to write, but I do
not know how
to do it

I really appreciate any help
Thanks a lot in advance
Marta

Attachment filename: forum excel- macro
problem.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=653613
---
Message posted from http://www.ExcelForum.com/

.

Hi martha.

I posted 3 times already (failed 3 times i think), though first time o
internet.

I will give you a new attachment, with the solutions. In the red cell
for suppliers I putted formula's, which check if one of your material
is in the list, and further checks which supplier comes in a certai
date criteria.

Please let me know if this is what you are looking for, and if you hav
any questions, send me a email to my address.

Regards
Max(16)
the netherland

Attachment filename: forum excel- macro problem 2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=65453
--
Message posted from http://www.ExcelForum.com