working

Hi, When I try and right click on the field buttons to hide them there is no menu. Everything else seems to be working fine, any ideas what's happening? Much thanks

Hi everyone, I'm working on a spreadsheet to calculate average scores from a given range,where they're 0-100. What I have is working fine, however for the purpose ofranking the averages I need to treat scores that are < 75 as “50” whencalculating the averages. Eg. Scores are 100, 89, 85, 76...

Hi guys, I'm new here and very new to VBA (just know the bare basics) -- nice to meet you! I wanted to create a code to insert a blank every 10th row and after copying and pasting bits and pieces of other people's codes, I finally got the code to work...but I'm not sure how this is working and...

Hi All, Preparing a calendar for reports handled by me, need a formula to derive the working day date. I have a list of position dates for which the report needs to be published. My date of reporting will be next working day. I also have the list of holidays with me. For instance if my...

So I am creating a incident log sheet which puts the time in column B when the merged cells in Column C:L are not bank it also should add a border to the row when it is filled in for a cleaner look. I have code in the sheet to auto expand the row height of the merged cells. All of this works...

I'm new to Macros, but I'm trying to write one that does the same formatting (e.g., bolds columns, adds a total, adds a column, etc) regardless of the number of rows. The data I'm working with will have a different number of rows each time, but the columns remain the same. I was wondering how to...

Hi, Please see snapshot from Excel: https://imgur.com/pQdHs71 Why does it not color the "current selection" J4:J300? Also tried this; =IF(AND(DATEDIF($J4;$L$2;"M")>=3;TODAY()>$L$2);) Not working. I want it to color cells with dates that 3 months due.

I'm trying to submit a form on a old asp classic page. Here some script: <tbody> [ ******** type="text/javascript"> //<=!=[=C=D=A=T=A=[ var theForm = document.forms['aspnetForm']; if (!theForm) { theForm = document.aspnetForm; } function __doPostBack(eventTarget...

After great success in my last post, were I received help with Excel, Im once again seeking the help of 'experts' I have a work log spreadsheet which I need to extract some performance indicators and then present these as monthly graphs. The jobs have a 3 working day pass/fail trigger and...

Hello, In my work i have to make weekly working schedules for my co-workers. Almost all of them are part time workers and have a first main job. I have 2 or 3 cases that they have a rotating schedule on their first job but it's always the same: example day 1 2 3 4 5 6 7 8...

for some reason, the advance filter only works for one criterion...when i try to expand the range...it stops working... e.g im only filtering for OSP 397 if i add another column OSP 400 the advanced filter via VBA stops working (just shows blank).....yes, I have modified the named range...

I've been working on this spreadsheet for a while now, and I'm not sure what I put in the code to make it stop working because it was working fine until today. I went to the Registry Editor and made an UndoHistory entry and it will undo an entry if I have a cell selected and want to undo the...

Hi All I have a spreadsheet for which I need it to do the following: I have populated all weekdays into a separate sheet, and then also added in the bank holidays until 2025. Now, I need it to automatically fill in the working days only into another sheet. So for example, a dropdown box in...

Hi all, Thank you for spending your time to read the post. I have some questions regarding the excel. I am in the process of creating an excel workday calculator. The issue is 1. There are some working saturdays 2. There are some non-working holidays (which i grouped under public holidays)...

Hello, I'm new to everything. We had a person that use to work for us that wrote some macros to scrape information from Rocket Software's Bluezone. Last Tuesday, most of the computers wouldn't let the excel script run. There were 3 that would. One a new desktop, one an older desktop and my...

I am trying this formula =IF(OR($K7="2",$K7="3"),OR($<wbr style="color: rgb(31, 73, 125); font-family: Arial, Helvetica, sans-serif; font-size: small;">M7="LIL",$M7="BEG",$M7="GWY",$<wbr style="color: rgb(31, 73, 125); font-family: Arial, Helvetica, sans-serif; font-size...

Hoping someone can help me with calculating the number of employees working during 15 minute time periods over 24 hours for a 7 day period. Currently I can calculate the number of employees working using the following formula: =COUNTIFS('Perm Sched Format'!I:I,"<="&A4,'Perm Sched...

Hi all, I am trying to find a formula that calculates the last working day of the following month based on whatever date I enter in to cell B2. I expect it to be some combo of WORKDAY and EOMONTH but I can't get it to work. For example if I put 13/04/2019 (UK format) I want the result to be...

Hi. Please see Excel spreadhseet via link. https://1drv.ms/x/s!AtIvkRgReIvwgQsRvSATK0IvdCRG Please can someone help me with this, as I have tried and tried to get it working, without success. In column AV I want to return the value relevant to the column AW. Column AW will return the...

Hello all! I have been doing this manually for a while and had a "duh" moment, that I should have a macro! This is something I felt I would store in my Personal workbook rather than within a project I am working on, as the need to use it on multiple projects is obvious. I need a macro that...