I have a Problem using Excel Right now and I will be really thankful if anyone can help me in this regard.
I have table 1 where I have different invoices numbers. Table 2 have the same invoice numbers and additional Information to it e.g. Factory and/or Test system. I would like to find e.g. Invoice nr. 23 from table 1 in table 2 and then copy the other Information (factory / Test System etc.) into table one next to the invoice number 23. There are almost 3000 Invoices there. So I either have to use visual Basic, makro or a function.
can anyone kindly help?
