design

Hello, I need some help on figuring out the design (ie. modules, controls, structure) for a VBA program I want to make to create the required schedules at a Call Center. I haven't really got into the coding part yet, I'm struggling a little bit with the designing of the program and how I should...

Hello My name is Maria and I'm new to this forum. I have used Excel for a while and I started in August last year with a new, big project for the company I work for. To make you understand my problem, I'd like you to explain what we do: We offer a home delivery service and employ several...

I'd like to know if anyone can suggest a product or resource to get a good fundamental education on the process of building/creating Excel models. I know that sounds broad, so let me explain. I've learned a significant amount through MrExcel products and Mike Girvin, and asking questions on the...

My Pivot Table must be condensed to fit a printed page. How can I stack the fields to achieve a look like this: <TABLE style="WIDTH: 336pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=448><COLGROUP><COL style="WIDTH: 48pt" span=7 width=64><TBODY><TR style="HEIGHT...

Hi all, Have just had Excel 2007 installed next to 2003. I used to have my "own" toolbar with icons I desinged myself for a specific action and used the different coloring to make things clear. They now safely appear in my addins ribbon or something imported via Personal.xls Is there anyway I...

We have a complex spreadsheet where it's not always clear which cells should be modified and which should never be touched in normal use. It's especially error-prone to have an area filled with formulas, but due to a few exceptional cases some cells have just a number or something else. Are...

When working with a Pivot Table, repeated entries are deleted: ABC1 DEF1 100 ---- DEF2 125 ABC2 DEF1 200 (The ---- represents a blank) This can cause problems when attempting to lookup certain values. How do you change the table so that it doesn't skip the repeates...

<!-- / icon and title --> <!-- message --> I am trying to query a transactional historical data having fields -origin, destination, Supplier Name, rates. Each field have multiplecombination with other fields. I want to see the result by origin, bydestination, by Supplier, Avg of rates. I...