Monthly Report

Hi every one!

I want to create a monthly report in a new woorkbook.
I have 9 woorkbooks with data ordered by month and I need for example. To write in a cell July and automatically excel makes me a list of all the data of the 9 woorkbooks that containt the same month.

I try to do this with the commans index and match but it's not what I'm looking for.

Thanks

Hi!

Sounds like a job for Hlookup() or Vlookup(). I can't give you any specifics without more information, so either download Colo's utility (see sticky), attach an example, describe the problem in more detail, or check out XL's help on hlookup() and vlookup().

HTH,

Some potential VBA solutions could include automated advance filters, or MSquery. If your still interested, let us know.

-C

for Colo's utility, check out:
http://www.theofficeexperts.com/forum/showthread.php?s=&threadid=529

It just makes answering questions a lot easier. NateO has a good point about match/index, they should accomplish what you want... V/Hlookup is a little easier to use (IMHO), but I believe match/index gives you more flexibilty.

edit: I know its annoying to be told to check the help. Without concrete examples to use, however, there's no point in trying to explain all the nuances of different formulas, if they're irrelavant. If you post a little more, I'll be glad to try to write a formula, without referring to XL Help (oxymoron). Or at least someone will!

HTH,

Thanks for your answer Nate

I know that index & match is functional but I was looking for something of Visual Basic that makes this monthly report.

I thought that using VB will be more easy and functional but since my knowledge of VB is very basic I couldn't go further and my only option was looking for help. :confused:

Thanks again

Victor

Howdy Victor,

No problemo, the question is what are you trying to do? E.g., run it for January, print/save/do something, then refresh it for February (etc...)?

I'd probably stick with the index, just pull it out of the printable range or place it in a hidden sheet and create a loop to go through the months of your choice....

But I'm guessing here as to what you're really after...

Thanks for your answer Corticus

I had download this file MyVlookup.zip so I will try it to do using the Vlookup () function.

I did not find Colo's utility :(

If I still have the same problems I will explain my problem in more detail and will send an example.

Thanks again

Victor

Howdy ineedhelp!!!,

I'm trying to determine what's wrong with the index & match function combination... It's not a poor man's way of solving this issue... Is it not functional? What's the problem?

#If you have any other info about this subject , Please add it free.#

Posted on at 4:57 am by admin.
weletothejungle.com :|: :|: edit