Import data from one sheet to another

[web]

Anybody who can help??
Im stuck with my expense sheet as I dont know how to import data fromone sheet to another.

The issue:
I want to import data from my expense sheet into my invoice. When a order number is entered in the invoice, data from the expense sheet has to be imported to the invoice automatically.
I know how to import data when the order number only occurs once, but I need to find out how to import data when the order number occurs several times which means it is several data which need to be imported (this data is going to be listed underneath eachother)

Anybody knows how to do this?
Hoping to hear from all you clever excel people out there.


Cheers

[JBeaucaire]

Hi web, welcome to the forum.

This all sounds very straightforward. To be most quickly helpful, we need to see the workbook.

So mockup a sample workbook showing the data and your desired results, point out where the results came from if not obvious in your sample data. BEFORE/AFTER is always nice when it's the only way to make it clear what needs to happen. (may not be necessary for yours, I think I understand it already)

Click GO ADVANCED and use the paperclip icon to post up your workbook.