Time Saving Techniques?

mudraker,

Sorry about breaking a forum rule regarding formatting of code.

Thank you for your coding expertise. I tried your code and it works well, I have been playing around with it trying to tinker it to my design but cannot work out how to do so.

All I want to know regards formatting so:
1. Each table is separated by a blank row.
2. Each table is surrounded by the "All Borders" option.
3. At the bottom row of each table, before the total columns, there are 3blank cells, I just want to fill this with a colour such as grey, I also need this for another blank cell on the same bottom row of each table for a column after the cost.
4. Each heading in each table has a grey background with white bold font for any font but default.

Also, there are times when some numbers in the No column contain an additional letter and need to be grouped together with this same number. E.g. 10, 10f, 10g, all should belong to the same separate table.

Finally a personal question. How long have you been working with Excel to gain the expertise to write this code? I would love to write it myself but haven't the time.

Thanks again for your knowledge.





Leith Ross,

I tried your code but nothing happened at all. Thank you for your time though.

Hello Xelpme,

If you post your workbook I'll install the macro for you. If you can't post the workbook, due to your location or confidentiality, post a larger sample of data that I can use. I will create a workbook from that with the macro it so you can see how it runs.

Sincerely,
Leith Ross

Sorry about the long delay, I have been busy during the week annd didn't have time to respond.


mudraker

I tried your latest macro and it was great except for a little formatting. Thank you.


Leith Ross

I have uploaded a an example spreadsheet with 3 scenarios, so 3 macros required.

1. Create table for each code including number and letter belonging to same table, so 11 and 11a belong to same table.
2. Create table for each unique code, so 11 and 11a would have their own table.
3. Create table for each unique code and sort by date with each month having a separate table.

It should be easy to understand once you see the spreadsheet.


Could anyone recommend a good excel book or web site to help me understand the code from mudraker and Mr Leith Ross, so I can add to it and make changes later on if necessary?

Thanks for your expertise mudraker and Leith Ross.

mudraker

Thanks for updating your code and including comments, it has been helpful and allowed me to understand and update it to the format I require. However I am unable to convert the prices to currency, only the total has been formatted to currency and the bold is not being applied to the total for some reason.

Also I need to format the dates like 1-April-07 ,and, if you look at my previous post and uploaded spreadsheet, I need different things for different scenarios.

Thanks for the helpful commenting.

Please look at the spreadsheet after my formatting, I didn't update the comments though, will do it when I've finished.

Hello Xelpme,

The attachedd workbook has been updated to provide you with most of what you asked for. Excel can't sort the codes 11, 11a, 11b, etc. as a group. I am writing a sorting algorithm to deal with this issue. The other part I haven't added yet is the grand total lines. The worksheet now has a button that displays a UserForm for you to select how you want the data sorted. Have a look and let me know what you think.

Sincerely,
Leith Ross