design

When I create a custom pivot table design it shows under "custom" in my pivot table designs. But, when I close out of Excel and go back in...it's not there! How do I save my custom designs to show up when I open Excel? Office 2010 version. Thanks!

Hi, I'm new here :nya: Pleased to make your acquaintance. There is something not quite working about my VBA code and based on the results I'm getting from this function I suspect the problem has something to do with my Do Until IsEmpty() loop. It seems to me like it's only running once. Could...

Hi. I have been fighting with myself over this design question, Is a one field table valid and of good design? I'm trying to create a database which records locations though time. So for a "place" it it will have a name (one or more) a population (zero or more census) a location (GeoCoded...

Sir/Madam, I have been racking my brains to try solve this issue. Basically I have a table of data which I need to perform a calculation on. It is a summary calculation for the day based on 4 or 5 different entries that day. This is an excerpt from my table. Date Available...

Hello, I am trying to grab reference drawing numbers from another sheet using a design id. In the workbook that I want to add the drawing number to, the design id is formatted as FC1234567899 and in the workbook where I am matching, the design id is formatted as 12345678. The current formula I...

I have created an Excel database for my address labels, and then created the labels ready to print in Avery Labels's excellent Design and Print software. I thought that I could alter the fonts, colours etc, in one go after creating an Excel database, but having viewed the options in Design and...

Hey all, I'd just thought I'd chime in with my opinion after reading and attempting to help some posters over the last few days. I've been on the board here and there in the past asking questions on things I havent been able to find on Google related to VBA mainly. My opinion, from what I've...

Dear Experts, Can you please guide me how to make this kind of infographic in Excel or if it is not excel so what tool could be used to design one like such (attached)

Hi all, everything was perfect, today I run several macro (built by me and downloaded) now When I check the table design view option or paste option it is disabled it is happening for any access file I open. I have tried these option (AllowFullMenusAllowSpecialKeys enable design changes for...

Hi everyone I have a very large database like below in every row I want to have the sum of budget,Actual and remaining man hour of all departments. In other words i want to write a sumif based on header containing specific word. how can I do that? Thanks a lot...

In the below excel 2010 VBA I am trying to create a user menu that stores a selection (there are only 2 choices) in the variable strInput. That selection will be used later on. Currently the 1 or 2 from the selection being stored and not the unique 5 digit code? I added the Convert section in...

Good evening everyone, I have a model from powerpivot which its fact table has many colums. I wish to insert multiple pivot tables, each with unique columns. I know I can hide tables and columns from client tools, but this will hide the columns or tables I select for all the pivot tables I...

Hi again, I have two macros that are based on Condition formating. They both search for specific text in column N, but dispalys diferents results. WHen I run the macro, the entirerow where my text "ppo" is turns green. If i have 5 other matchaes , then they are all formatted togheter. I...

Hi there, thanks in advance for reading this. I have inherited a spreadsheet showing daily turnover that records the data and totals and displays it all in one sheet. It's a nightmare to try and make useful just because there are so many figures - 365 days with 8 departments, each comparing...

Hello everyone, I had a question that I hope I'm not alone in having. I am a federal contractor, specifically I work as a Quality Control Manager for a large security contracting firm. The nature of the industry is pretty conservative, even though I don't work directly for the government, most...

Hey Guys! I tried to create a banner for my Microsoft Excel sheets, but It looks quite bad, If someone could help me by creating a better one that would be amazing. The banner needs to say the words "Zac's Bakehouse" as it is the title of the company that the spreadsheet is for, it is a...

Hi I have a big problem. I was doing some graphical works in excel and for doing this I was creating a custom design color scheme (see screenshot attached). How can I distribute this design color set to other users in my company? thanks for your help. Martin

Hello All! I'm in the process of creating a spreadsheet that monitors the hours worked for employees under 3 different managers...there are a number of things the sheet will report such as 'total weekly hours', 'total hours worked in one shift' etc. The spreadsheet needs to cover every week...

Hi, Thanks for taking the time to look at this, I hope I can explain it well . . . I am trying to build a 'catalogue' database to assist pricing of large bolted assemblies. I have a list of about 500 parts, such as 12mm bolt, 12mm nut, 1m girder etc. I would like to be able to create & save...

Hello there! I have been asked for help by a client in designing a simple data entry DB (if you need to know, to record some data about diagnostic imaging studies performed). I made a UserForm that asks for the data and copies it in a table, along with other useforms that allow the user to look...