Export date from one file to another: report

[Rober]

Hello again!
I have a WB like this dummy example.
The Book1.xls is the original file
Book2.xls gets the data from Book1.xls and
the final result should be like the one in Book2!Report.

Any idea?

Thanks
Rob

[arlu1201]

Copy the list of Companies to your Book2 - column A. Remove duplicates using the Data->Remove Duplicates option.
Then in column B, put this formula -

Please Login or Register  to view this content.

In column C, put this formula -

Please Login or Register  to view this content.

Change references as required. Drag down to how many ever rows are needed.

[Rober]

Sorry for my ignorance but what is "$J2" for?
Thanks
R

Edit: Ok Now I GET IT!!!!!!!!!

[arlu1201]

Oops i am sorry, it should be A2.

[Rober]

Thanks Arlette,
I figured it out soon enough!

I have another example here if you can help me with this one.
The concept is the same but I would like to extract the clients name/ per sheet (company).

Every Company is in its own sheet and the same data needs to be listed like in ABCD (Sheet 1)
I have no idea what to use.

Thanks in Advance!

Rober

[arlu1201]

You can do this -
Have a macro that will copy the data to its respective tab. Then it will do the calculations for you for New & Old Boxes...will this work?

[Rober]

Macro would be ok,
but if I wanted not to use the macro what would the formula be?
VLookup? Search?
I am still searching...
Thanks
R

[arlu1201]

I guess it would be a mix of Index, Match functions. But i am not very comfy with those. I can help you with a macro that will do the actions you want on the click on a button.