Vlookup:down load the 825KB zip file

[Sanne]

Hi,

I'm a beginner when it comes to Macros and I don't know anything about programming.

I need to extract info from one spreadsheet to an other and would like to find a way to do this automatically. See attachments.

The problem is that I would like to populate several spreadsheets ("Order sheet") from the spreadsheet called "QB Open Order".

The attached spreadsheet ("QB Open Order") contains 2 different Names (column D) and 2 different Item Descriptions (column H) per Name.

I would therefore like four different "Order Sheets". Or preferably, 2 "Order Sheets" per Name.

Is this possible?
Is there anyone that would like to help me?


Thank You & Regards,
Sanne

[pike]

Hi Sanne
zip up the files and i'll have a look

[Sanne]

Hi Pike,

Zip file is now attached.

Thank you

[pike]

Hi Sanne
Hadn't forgot work just got in the way

Please Login or Register  to view this content.

[Sanne]

Hi Pike,

You're a star!

Now, what do I have to do to be able to use this?

Sorry, I'm really a beginner at this.

Sheers.

[white3007]

may i ask? can we do VLOOKUP from other microsoft office like access?

For example i have my database in Ms. Access, but i need to take out the data into excel formatting, can i do VLOOKUP from access?

[shg]

white,

Please take a few minutes to read the forum rules, and then start your own thread.

[pike]

Hi Sanne
save the attached workbook"order sheet" in the previous thread to the same folder as "QB Open order".
The "order sheet" has a commandbutton enbedded, click and use the comboboxes and other buttons
displayed to print orders sheets

[Sanne]

Hi Pike,

thanks a lot. This is awesome. Just how I wanted it.

I found one error though. Don't know if you would like to continue to help me w. this? The sizes are getting populated on different tabs. Is there a possibility to get all sizes on the one spreadsheet down the right bottom corner?
Also, it would be great if I would be able to populate different tabs for the different styles (instead of different sizes) so that I can have one workbook per "customer". Is this possible?

Automate.zip

Thanks again,
Sanne

[pike]

Hi Sanne
Is this so you can print the orders?

[Sanne]

Hi Pike,

Yes, it's basically to get an overview, per customer per style, on one sheet/piece of paper.

Regards,
Sanne

[pike]

Sanne
if you just want an over-view of the orders try replacing the code in

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

you really need all the rest as it would be hard to digest

[Sanne]

Hi Pike,

Thank you for all your help, I really appretiate it. The overview doesn't really help though. Is there anything I can change to get the size breakdown on the one order sheet page together w. the other information?

Once again, I really appretiate your help and I understand if you don't have time or energy to help me further w. this.

Regards,
Sanne

[pike]

Hi Sanneno
problem try this

Please Login or Register  to view this content.

[Sanne]

Hi Pike,

Haven't had time to look at the code until now. Thanks, this is more towards how I wanted it. I can just manipulate the sizes with an other macro.

I added some columns in the QBOpenOrder. I thouight that I would be able to manipulate the code myself but got an error msg when trying to choose data, after clicking on the command button.

Would you mind having a look?
Hopefully I will stop bothering you after this.

Regards,
Sanne

[pike]

Its no bother .I can have a look but it will have to wait untill I can down load the 825KB zip file ,which probably wont be untill wednesday.

[Sanne]

Cool, thank you

Regards,
Sanne

[Sanne]

Hi Pike,

Don't know if you have had time to have a look at my problem. I managed to compress the ZIP to half size at least:


Regards,
Sanne

[pike]

Hey Sanne
Just unhide column A in QB open orders and everthing works fine

[Sanne]

That was easy. Thanks a lot for your help Pike.

Regards,
Sanne

[pike]

your welcome catch next time

[pike]

I've added some extra columns in the QB Open Order spreadsheet. I now have 17 columns of information. But, when using the Order Sheet spreadsheet, it seems like I can only pull in data from 16 columns

I'll take a look

[Sanne]

Want me to zip up the newer spreadsheet version?

[pike]

yep ... that would be good

[Sanne]

TEST.zip

Here you go.

Thank you,
Sanne