excel
42580 TopicsUsing VBA to make a cell blink
I am trying to figure out how to use VBA to make a cell blink in Excel. In the attached example, if a cell in column G is over 45 days old from the date in column F, I would like the corresponding cell in column D to blink between red and white for the fill color and leave the font color white. If possible, I would like the cell to blink once a second. Anybody have any ideas?Solved52Views0likes12CommentsQuestion on a type of text linking between sheets
Hi, I'm trying to work out how I would copy text live from one sheet to another. Essentially what I'm trying to do is create a meeting minutes template that automatically puts yesterday's actions onto today minutes without having to copy and paste it. Only condition to end this (and to prevent it pasting across all days of the month) would be crossing it out with ctrl+5 once the action has been completed. The setup I have is a sheet for everyday of the month, each with their own actions box on identical coordinates. It's not the only thing on the sheet but it's the bit I'm trying to make easier. Is there any way I could do this? I'm not particularly experienced in excel so I'm hoping it's not too complex. Image of the actions section plus sheets.30Views0likes3CommentsIntegration of worksheets and dashboard in Excel
Hi, We are working on a project to track the ships arriving and departing from our port. We currently run a simple spreadsheet to track the ships coming and ensure they have completed the required forms. Attached is our workbook that we do this through. At the moment we can make "yes" for columns such as pre-arrival for received, or hot work completed. We then have to manually check the prices and add it to the invoice column. I have managed to build out the form to allow the automatic adding of hot work charges etc. Rules that we have to follow: We have ships calling to the port wharves. These cannot be levied for berthing but do pay for hot work and engine immobilisation. We levy ships that anchor (that then do not call to the port) or those that anchor. The rates differ between cruise ships and cargo ships. Cargo ships have 2 different rates. Is there a way to then have this information automatically transfer through to the invoice template? Is there a way to build a dashboard to show when ships have booked and are using the anchorages? There are a couple of us working on this so want to ensure that we don't double up a booking. We have other activities that are charged. Is there a way to get this data through to the invoice template sheet? I am envisaging that there is method to send the information to be sent to the invoice template once it is ready.Solved86Views0likes9CommentsGraphing Multiple Series on one Graph
SampleSheet Hello all, I have been asked to Graph a variety of different data series into one graph to see if any may relate to each other. The graph is intended to be a line graph, having 5 different lines, representing 5 different data series. I believe this is possible, but just cannot remember how to do it. An issue that I'm having is that the Data series has such different values, ranging from a series having values of <1.0 to series having values of >20,000. Is it possible to have a 'break' in the y-axis so that the gap between say... 100 on the y-axis to 20,000 on the y-axis is non-existent or would it be recommended to just add a secondary Y-axis for this series? The dates are of significance, and should be on the x axis to show the timeline of these different values. Any help here would be appreciated as my direct report has been asking this of me, and we're both stumped. I've attached a spreadsheet with the 5 series included. Is anyone able to have these 5 series added to the same line graph in a legible manner without adjusting their values? Thank-you so much in advance. Toon11Views0likes1CommentChart doesn't update its range when recalculate happen when the file open
Reproducible Steps: Set formula =SEQUENCE(SECOND(NOW())), and create a chart. It is a dynamic array, so the chart's range should update when the array change Close and open the file. The array change when open, but the chart stands the range before28Views0likes4CommentsSharepoint Hyperlink not Dynamic
Recently a bunch of items were moved from a drive to Sharepoint and I am trying to update my dynamic hyperlinks. Every month there is a checklist of tasks that need to be accomplished and I have Hyperlink formulas to click on and go to the current month-year folder. I setup my formula using the "December 2024" folder as my basis and the formula sent me there. Perfect! Then I changed the MONTH_YEAR cell to "December 2023". The only difference between the file paths when copied and pasted from the address bar is 2023 versus 2024. When I clicked on the updated link it sent me right back to the 2024 folder. Does anyone know why the link isn't changing when I change the parameters? =IFERROR(HYPERLINK(CONCAT(http_to_Master_Folder, "%2F%5F%5FCharacter%2FCY", RIGHT(MONTH_YEAR,4), "%2FNotes&viewid=x00000f2%2X0x0x%2XD0xxx%0Xx00x%0X0000x000xx00"), CONCAT("Game > Campaign > Player > Character > CY", RIGHT(MONTH_YEAR,4), " > Notes")), CONCAT("Game > Campaign > Player > Character > CY", RIGHT(MONTH_YEAR,4), "> Notes")) Thank you5Views0likes0CommentsXLOOKUP when lookup value may be text string or number formatted as text
I have a data set that has lookup value which may be text string or number formatted as text, with the lookup range formatted General. How can I format the lookup value as general? I currently have a formula with [if_not_found] as XLOOKUP value VALUE($A2), but would like to simplify the formula. =IFS( $BA2 = "N", "", TRUE, CHOOSECOLS( XLOOKUP( $A2, 'Data'!$A:$A, 'Data'!$F:$AA, XLOOKUP( VALUE($A2), 'Data'!$A:$A, 'Data'!$F:$AA, "" ) ), 1, 3, 4, 5, 6, 7, 8, 12, 14, 16, 22 ) ) Can I use TEXT formula to change lookup value to General format? I saw another post that suggested the following but returns #VALUE! for numbers formatted as text : =IFS( $BA2 = "N", "", TRUE, CHOOSECOLS( XLOOKUP( TEXT($A2,"General"), 'Data'!$A:$A, 'Data'!$F:$AA, "" ) ), 1, 3, 4, 5, 6, 7, 8, 12, 14, 16, 22 ) ) How can I fix this?29KViews0likes4CommentsFreeze Panes Question
Hello Excel Experts, I have a problem that I'm facing that maybe you all might be able to solve. I'm trying to freeze my top and side navigation bar in place in Excel. Technically I got the top bar to work, it stays in place when I scroll vertically and technically side bar is also frozen in place but only when scrolling horizontally. Anything below the top navigation bar when scrolling vertically moves. Is there a way to freeze both the top and side columns in place so my navigation buttons are always available to use without using VBA? I have tried the split window option, it works but there's the duplicate view of what was split which if there was a way to hide/lock that duplicate image behind the stationary split view. I also tried combining split view window with the Freeze pane option but that didn't really work I do have a video of what I am talking about with the freeze pane issue option that I'm having which I have attached, along with the file as well Thank you, and I look forward to the help!!!!!31Views0likes2CommentsRounding up/down half a pence on excel
Good afternoon, I am needing to round up/down certain columns whilst keeping the formula. I need columns E & F to round up or down depending on the amount, from rows 5,6 7, 8 and 9. Due to the % and the amount some of the answers will include .5 of a pence. I need something that would do the below. 5245.505, the formula will round it to 5245.51. 5245.495, the formula will round it to 5245.49. Any help appreciated. (I left an example in the sheet to show) Thank you Joshua21Views0likes3CommentsConditional format dates
Hi, Is it possible to apply a conditional format to a cell. If column I states Yes then highlight red if the date is 5 workings days old and over If column I states No the highlight red if the date is 10 working days old and over If column I states NA or is blank then to not highlight15Views0likes3Comments