help

Hello! I'm trying to make a dynamic reference to a closed workbook in my report. Currently, a straight-up hardcoded link looks like this: ='G:\Reports\Management Reporter\[India Trial Balance 2023 in US dollars v2.xlsx]ManagementReporterISbymonth'!J16 My goal is to have the bolded part be...

I'm struggling to take a median of a set of data with multiple criteria I have a set of raw data (Shown Below) I want to find the Median of the data in Row K (Gain) for all the cells where the DEF Call (Row H) is "Base Tommy" AND it's in Hole (Row R) 2 OR 3 OR 4 OR 5. (I don't want the median...

Hello My code is set to wipe a workbook based on a date Private Sub Workbook_Open() Dim ws As Worksheet ' Check to see if specified date is passed If Date >= DateSerial(2023, 7, 6) Then ' If it is, loop through all sheets For Each ws In ActiveWorkbook.Worksheets '...

I have 3 tables I need to connect and return a value into a cell in 1 of the tables. In 1 table I have a list of names and a number correlated to those names, we can call that table (Names). In the second table is a list of members of various clubs, we can call that (Clique) In the third table...

Hi all, REALLY WOULD APPRECIATE HELP ON THIS ONE :) I'm struggling with this one. So I've used Substitute & Concat in a formula to a Summary page to check other tabs for a '!' in any of the cells (which means action required), if there is a '!' it will do a tick on the summary tab. This has...

Hi, I'm trying to create an Inventory Count Database in Excel using a Macro/VBA. The concept is for the Count Team to enter in an Item Number and Bin Number (which I have Data Validation on to prevent typos/errors). The Item Description is a formula that will pull the description associated...

I'm looking to convert an entire column within a spreadsheet, to ensure each cell containing a list is converted into rows underneath with single postcodes as per the example below. I wasn't sure if there was a function or a formula I could use to execute this. Any help would be much...

I have the following data I want to analyze the data and answer the following questions in the same format How to do this? Since I'm a super-beginner at Excel, I'm struggling to this data analysis. Requesting the community's help.

Hello, I track the whole company's absence on a single excel tracker (excerpt below). At the end of each week, I am required to provide an individual absence report to managers in each location. There are currently 62 in the business across 8 locations and this is hours of work on a Friday. We...

Hi there I have a spreadsheet that I use to keep helpful formulas in for work that I need to do. I have made two buttons that calculate two different cells but a specific number, when I am copying it into other workbooks the buttons arent working as it is copying the cells names, for example...

Hi I need a VBA code to clear/reset all filters from all sheets upon workbook close. A number of users of a workbook are always leaving filtered criteria applied and exiting. With some sheets having 100 columns, it sometimes causes problems when others open the workbook and think data is...

Hey I am looking to be able to pull a list of numbers in separate row from one cell, for example i have a cell that states "23000 - 23010", i want 11 seperate cells that say 23000,23001,23002 etc is this possible? what I currently do it type the first two and drag down as far as I need but...

Hi all, im a bit stuck with this. I am trying to find a formula that will find the 'parcel_volume': cell and then return the cell next to it. But as you can see below that 'parcel_volume': is not just in colulm N and is somtimes in another colulmn. I am unable to change the layout of this as it...

I am sure this is simple but i have searched the internet to then end with no answer. I have 3 columns. A1 has the name of of the person B1 Has the sales made column 3 has the price per sale. What i am trying to do is this: In D1 i want it to do a if greater then .8 but less then 1.3 show...

Hello, I have two sheets, named: 1. Master Data - This sheet will be updated daily by pasting a system report over the existing data 2. 2022 - I want to calculate some stats from the master data sheet on this sheet The gist of this is, I need to report on people who leave between 0 and 5...

Hi everyone, I'm hoping you can help me with an excel formula to solve a problem I'm stuck on. I think I am pretty close to solution but just can't crack what it is I need to make the formula work how I would like. Basically, the problem is this: My formula is pasted all down column B. I need to...

Hi, i am still in learning process with Excel i am trying to make head to tail of a thing so here is my question and please if you can give me some guidance on how to sort this out for me, so i created this excel form that i am trying to introduce to work and i managed to get most of the thing...

In excel I would like to enter a formula under the employee number column that when I enter an employee number it will auto populate the employee's name, position and skill code. All of these are on another sheet in the workbook Ie: employee number is column B, name is column C, position is...

Hi all, I have this formula: =IFERROR(SUM(IF(FREQUENCY(IF($A$2:$A$101=A2;IF($D$2:$D$101=D2;IF($H$2:$H$101=H2;MATCH($I$2:$I$101;$I$2:$I$101;0))));ROW($A$2:$A$101)-ROW($A$2)+1);1));"0") It checks the following sheet (please note that A2, A3 and A4 have the same value): ' I want the formula to...

Hello, I have the below assigned to filter buttons which automatically filter a list, based on the criterial. For "office" I also need it to filter "call centre" in addition. So when the "office" button is pressed, it also filters call centre with office. Sub Office() ' ' Office Macro ' '...