displayed

Hello, Would like to have worksheet sections displayed by command buttons, but I do not know how to do it. In the worksheet the month range should be displayed by clicking on the respective button. So that the respective desired month after column G appears (column A to G should always be...

I have several columns of data & would like to display only a few. I can manually hide them but it's a pain. I use the advanced filter & do the "copy to" another location thinking only the specific columns being put into the "critieria range" would be displayed but all columns come back. Is...

I am currently working on a spreadsheet to show duration between several date/times displayed as DD/MM/YYYY HH:MM. I need to report on the difference between the Request time of a job versus its completion time. The only issue is, not all jobs have a requested time so i have some cells in that...

Whatever cell format I choose, the # filler characters are always displayed. E.g.: For a selected display '$'#,##0.00, we see $#,##1.36 rather than $1.36. What is wrong ?

I have a spreadsheet in which the total of the values entered along the row are displayed in column 'E' Gift Aid is marked 'Y' or 'N' in column 'F', with the amount entered into column 'G' if 'Y' or 'F' if 'N', ie depending on whether the person can Gift Aid, or not. If possible, I would...

If I want to have the same color following a for example a "brand" in a graph. Excel automatic set colours depending on the value, but if I for ex in my graphs always want that AUDI to displayed in RED and BMW displayed as BLUE. What function must I use ?

I have out grown my current excel method and I have started to think a little more long term in the next phase. I now manage a number of customer's car collections, each with at least 6 or more cars. I currently keep a separate spreadsheet for each customer. When I make an improvement to a...

Hi I have a textbox for total amount. I want its value to automatically get calculated from two textboxes (i.e. txt_QtyBought and txt_UnitPrice) by multiplying its values and get displayed on "txt_TotalAmount" But I'm stuck.. Somebody help me please Thanks.

I have a list of RAL DESIGN colours like this: Row Code Gernman English Code German English Code German English I need is displayed: A B C 1. Code German English 2. Code German English All the codes are unique ans displayed like this 000 60 00 I'm struggling to get...

Hello, I join a series of two cells together with a slash in between, such that the cell shows the two numbers as a fraction, such as below: C1=A1&"/"&B1 I'm wondering if it's possible to have the numerator be displayed in bold font, while the slash and the denominator are in regular font...

I want a cell to display a number from another sheet in the workbook if two things are true. For example: on sheet 2, I want information from sheet 1 in column E displayed in sheet 2 column M if sheet 1 matches sheet 2 column A AND sheet 1 column D matches sheet 2 column C. Can someone help me...

Hello, I am new to VBA and need help! I have a price list with over 4000 items. I have it set up with the top 11 rows frozen. There I enter a part number into cell R1 and it pulls that items price up and calculates my markup ETC. That all works fine. But I also need to find out the row number...

Hello, from the image located below I would like to convert all of the vertical information into horizontal information. I know that you can use transpose but I have a problem here. I need this to be formula based to some degree. In other words, the horizontal information at the bottom, the...

Hi all. I would like to create a macro which would scroll through a table if there are too many rows to fit on the display. For example, if the table had more than 25 rows, scroll until the last row is displayed. Once the end of the table is reached, the scroll would return to the first entry...

In excel work book i have 10 worksheets. On each of the worksheet i have 50 employee names with unique Id numbers (eg. column A will have ID no and column B employee name). In the 11 sheet i want the sheet name displayed in B1 when i type the employee no in A1.

Hi, I have a range of dates in column A from A18 to end (the number of rows will vary) and I've named the range "TradeDates". For each date in that range, I'd like to have a column starting from column J displaying the date on the top and then 3 columns to the right, I'd like the next date to...

Hey Guys, Having trouble solving this one. I have data that is displayed like this: England 4 France 3 Brazil 4 USA 4 USA 4 Canada 3 I'm trying to count how many times a combo of England,France occurred as a 4/3, Brazil, USA as a 4/4 and so on...the data is displayed vertically...

I need to visualize train paths on a single track railway to suggest optimization of train schedule slots and increased service patterns. The distances the train are traveling are obviously well known and should ideally be displayed on the Y-axis with the fixed points being the (accumulated)...

I am trying to convert standard time to military time in excel 2007 and have 2 different formats one is displayed as HH:MM:SS and the other is displayed as HH:MM. I have used the formula =TEXT(G2,"HHMM") for each of the data sets and for the column formatted HH:MM:SS it is converting...

Hello! I need to create an excel sheet that will be filled in by individuals but the contents of the sheet are dependent on the answer of cell B2. If B2 is Yes then the below is displayed: <tbody> Credit Yes Name Surname Address </tbody> If B2 is No then the below is...