blue

Hello Gurus, For the following issue, I request your assistance. I have two columns: first one has Shirt color and second one has Sizes. Within a color, the order size received is varied, just as below <tbody> Shirt Color Size Yellow XL Yellow XL Yellow XL Yellow XL Yellow L...

Hello all, I am trying to write VBA code that will show or hide subsequent questions based on the answer to a prior question. As an example: "Do you prefer?" "blue" or "red" (in a drop down) If I answer "blue" I see the 2nd row which has the question "Do you prefer?" "dark blue" or "light...

Hi, I have a master document that goes form Cell A1:BG22458. i want to create a summary report with just 6 columns. 5 are a simple link, the other requires a formula. In Sheet1 I have set my summary tab up. Sheet 2 is the master data. In Cells F1:F22458 all cells contain number of words and...

Hi. I'm trying to use a code found on this site https://www.extendoffice.com/documents/excel/3269-excel-concatenate-cells-if-not-empty.html Unfortunately, when I try to execute it gives me the "can't find project or library" error. What could be the problem? It also briefly highlights the first...

Is there a simple count formula that I can input on sheet 1 in cell B1, B2 and B3 that I can copy down that will return the number of times Red, Blue and Green are listed on sheet 2? There are about 650 items that I need to have counted, so hoping there is something I can use that I can copy...

I have words in a cell cell and would like to have the brackets and single quotes removed and put in alpha order. I have this in a single cell: ['red', 'blue', 'green', 'yellow']. I want this in a single cell: blue green red yellow

Hello. I have multiple rows of data that I would like to consolidate into one row based on information in a number of columns. In the example 1 below I would like to consolidate all rows based on UniqueId, however would like the rows for Product & Question columns combined across the page with...

<tbody> A B C D 1 Red 5 Red 1 2 Yellow 3 Yellow 3 3 Blue 7 Red 2 4 Blue 4 5 Red 2 6 Blue 3 </tbody> I'm trying to get this SUMIFS formula to work, but I can't seem to figure it out. I'd love a bit of guidance. Thanks. The table shows the results...

Looking for code assistance, please. How do I select cell A1 & dynamic range for ActiveWindow.Zoom = True My attempt (in blue) doesn't work. iCol = wsSheet1.Cells(1, Columns.Count).End(xlToLeft).Column wsSheet1.Range(A1, iCol).Select ActiveWindow.Zoom = True

I have two sheets. Sheet1 has a table of data that I will need to lookup, and I will be pasting data from another workbook into Sheet2 that has somewhat consistent column headers but in different orders. I want to put a formula in Sheet2!A:A that finds a specific column in the pasted data and...

Hi, can anyone help me with this in Power Query? I'm trying to get data like this first table (Table 1) to look like (Table 2). I understand how to unpivot and pivot in Power Query (and it doesn't work here - I get an error with Sally's hobby) What I don't understand is how to go through and...

Hello all, I am after the code required on a Visual Basic command button, so any cell that is selected will go blue. Thank you

I'm using the vba code below to sum cells by their color and it's not really working to my need 1. It rounds the sum to nearest whole number. I need two decimals precision 2. It does some weird stuff, e.g. it sums 2 * 1,5 to 4 but it also sums 2 * 2,5 to 4... <tbody> A B C 1...

Hello, Im trying to run a macro that will make multiple sheets. I want it to cut any cell that is say "blue" and anything beneath it till another blue cell into another sheet based on the text in the first blue cell. Any ideas?

Hi All, Hi All, I need a formula to calculate the following in column D (example of returned info in there): Only bring across the cost (Col C) info from Red (Col A) that is more than £5.00, all others show 0 inc Red, Blue and Green. I need it for a summary at the bottom (if possible) or...

Hello, I have a stacked bar chart in Excel with a Right Brace for two of the 4categories. Is there a way to automate the resizing of the Right brace to matchtwo of the four categories? As I mentioned it’s a stacked bar chart. Categoriesare Red, Blue, Green, and Yellow. The Right bracket is...

This is probably a very simple request, but I am stumped. Hopefully someone can lend a hand. On a main data sheet, I have a populated row of data (header). Below the header, I have certain cells populated with data. I want to do a look up on a separate sheet and match the 'header' and...

Hello, Would it be possible to highlight any/all updated fields in a form inAccess? I’m looking to highlight the first update instance in Red with theupdated date. Then I need to highlight any second updates in Blue. Is this possible? Thank you

I have a 4 step flow chart to follow to put the correct item in the cell dependent on what' in previous cells. Is it possible for me to use a, long, IF statement? The flow chart will never change so I'd only need to do it once! The flow chart is Is it A or B If A, is it 1 or 2. If B, is it 3...

Hello...My name is Robert, and I am trying to discover a way for me to merge multiple CSV files into a single Excel worksheet? I don't want the merged files to appear as tabs on the bottom of the new worksheet. I simply want the data for each file to be stacked on top of each other. For example...