change

Hello again! Hopefully, today was a pleasant day for everyone. Not a perfect one, necessarily, but at least a pleasant one. :) I thought this would be an easy thing to find, but I can't seem to find any code that will do what I need. My spreadsheet is only 7 columns by about 300 or 400...

Could anyone please advise on conditional formatting? I'm trying to use a formula to have say cell a1 to change colour IF cell d1 has any input? I've been trying conditional formatting in cell a1 as - If(d1="",TRUE,FALSE) but no change happens with input to cell d1. Any help would be greatly...

Hi experts, I am new to the site, so I apologize if I have posted this in the incorrect area. In the below table I have the following formula in C3-C5, =IF(B3=1,$D$2,IF(B3=2,$E$2,IF(B3=3,$F$2,IF(B3=4,$G$2)))) <tbody> A1 B C D E F G 2 Start Pause Re-set Stop 3 1 Start...

Hi all, I am a beginner to this technology VBA Excel. I faced a problem in the project Read an external file and look for a Specific String (This external file name will change daily – as the Date – which will be part of the file name – will be dynamic) Return a Value from the 8th Column...

Hi, I'm using index match reference, but I have to change every formula one by one, is there a faster way? https://ibb.co/X2pcKzP See the photo attached, I have to change the formula in G56 from '[7 July Shop Yields.xlsx]1.7' to '[7 July Shop Yields.xlsx]2.7'! manually but whereby F56 already...

Hi, I have 50 DAX tables. I would like to change the order of the tables. But every time I move the tables. They go back to the original order (order of when created). Is there not a way to set the order of the tables? Thanks

Hi there, I have a userform with 4 textboxes that when text is entered they all refer back to individual cells. All data entered on a spreadsheet goes to the userform and when entered into the userform goes back to the spreadsheet. One of the textboxes displays a price but i cant seem to change...

I want to change the colour of the row to green when my 'project status' is inputted at 100%. Is there a way I can do this?

Greetings Can the below VBA string be modified to add the word "Date:" before the actual date, and change the font to Ariel 12 point bold? I'm using MS Office Professional 2013 and Windows 10 Enterprise. RightHeader = Format(Date, "dd-mmm-yy") & Chr(10) & "Page: &P of:&P" As an example, the...

Hello, I imported a CSV file into a query format and my date column is showing as this right now: 2019-08-28 03:32:31 EDT is there a way I can change that to read 8/28/2019? when I change format to date it does nothing. I can do a formula to pull the left numbers, middle and right but I'm...

Price change % is my column of interest. I would like to measure whether or not there are correlations between Price change % and any of the other columns. What visualisations would be best for this? What I've tried so far is creating pivot tables and grouping by Production year, Category...

When I make a selection using the drop down arrow, the change event executes once. However, if I type 1 character, the change event execute twice. I step through the procedure and I can see the code only execute once until to the end of the procedure and then my cursor changes to a wait circle...

Hi i'm using 365 I sort a remember that in older versions of excel, I was able to change the A,B,C, and the 1,2,3,to inches. Was I dreaming? I'm trying to make a business card and i don't want to keep changing the fonts and printing them till i get the size right. mike

So I have a spreadsheet that I have a drop down for the month of the data, when I change this month then I want the cell in my next table to increase y 1 month. In other words if I select June on B2 then I want K2 to change to July. I have tried a few different formulas but I am failing. Here...

https://1drv.ms/x/s!AvjBsEPEq12ngUI4aV0PG-l-4gVM?e=pByejI How do I convert the data in A1:B7 to the output in rows 12 and below (happy to use any method, pivot tables, power query etc) (Purpose is so that I can do YTD calculations using the output)

Hi i have a simple sumif formula in B2:B11 that is = SumIfs(tel!$J$2:$J$11,tel!$A$2:$A$11,$A2) What i need to is when i copy the formulas across to C2:C11 I need to move these ranges down 5 rows down from the end so this tel!$J$2:$J$11 to tel!$J$16:$J$25 tel!$A$2:$A$11 to tel!$A$16:$A$25...

Is there a way. . . I am in Cell A1 and the formula is =E1. I want to copy my formula down but instead of the row # changing from E1, E2, E3, etc. I need the COLUMN to change from E1, F1, G1, H1, etc. Is this possible?

I have an excel workbook with 6 worksheets. Each worksheet has a different header. Each week, I want to be able to change 4 of the worksheets footers without changing their headers. When I group the 4 worksheets and change the footer; it changes the headers too. Is there a way to change 4 of...

Hi I have some tedious data entry to do into a spreadsheet. Mostly text. Every once in a while I have to use the 1/2 character in a string So I can copy and paste the character from the clipboard (very quick) but copy/paste gets used a lot anyway so then I have - to stop typing. go find the...