Sorting / arranging data onto another sheet

Hi Everyone,

I hope you can help me.

Please see the attached file, it should explain what I need to do a little better than I can here.

I have 3 sheets, one used for allocating quantities of products to different order numbers.
Another is for the price list of said products.

The last sheet is where the data from the other two is to be displayed. When the user clicks a button on the order sheet the information from there should be matched with the prices in the price list sheet and then displayed on the third sheet in a neat format.....

Like I said it would be easier for you to look at the attached file.

Any help in getting this up and running as soon as possible would be very much appreciated.

Thanks

Simon

even if you can just help with part of it, it would be really appreciated as im on a very tight schedule.

Hi Everyone,

Would it make it easier to do if instead of the user typing a quantity in, he just put a '#' symbol or something which meant 1. Removing the ability to add more than one of each item to each order?

check attachment

Make sure the following reference is on:
1. [Alt+F11] - open Visual Basic window
2. Tools - References - find and tick "Microsoft Activex Data Objects 2.0 Library"
3. Press "Report" button

Hi,

Thankyou so much for your help.

Would it possible for you to explain abit about your code as I would like to adapt what you have done to fit a slightly different format. Example attached.

All I need to do is just move a few things around on the report page and also know how to add more products to the list.

More help from you would be excellent

check attachment

Hi everyone

Can someone please take a look at the code below and simply write me an explanation of what the different parts of the code are doing.

I am finding myself sitting just starring at it......and that is not helping.

I need to know how to change the layout of the 'Report' sheet which is created. and also add in more headings etc.

Please Login or Register  to view this content.

Any help would be great. Thanks

Hi Guys,

I am using the code in the comment above to create a 'report sheet' in my excel workbook.
It takes information from One sheet and arranges it neatly on another.
If you look at the attached example a couple of comments up it will be alot clearer how it works.

I would like to know, if I add another column and lets say its used to select certain rows, one at a time, i.e. by enterting a '1' into that column the row that the 1 was on would be selected. Could I have a macro to take the data from the selected row (the same format as it does for the report above). Could I have that information automatically copied to a word document, rather than another sheet.

Let me know if you need any more information.