details

Hi Maybe someone can point me in the right direction. I have a tab that I am using as a key (Award Abbrev) that I want to use to populate cells in another tab in the same workbook (Staff Details) I have created specific text in I2:I60 in "Award Abbrev" that on the corresponding row has values in...

Hi I have multiple shapes with name/job role on worksheet 1; can I 'link' the shape to their corresponding row on worksheet 2 to generate a mouseover with all their contact details? TIA

I have a large spreadsheet with events that have happened, noting (across the row) the time and a lot of information about that event. I wish to add a column that counts how many times an event has happened in the last given amount of time. So, for example, in the following spreadsheet where...

Hi guys, Can you please help me with a really easy thing? What I would like is to createa filter for my data. The data is structured like this: Country manager | company name | city | blablabla other details I have a big database for these company details, but on the first tab of the excel I...

https://www.dropbox.com/s/gfp9tfe6k2kc61r/Model%20sheet.xlsm.xlsx?dl=0 Dear Excel Ninjas The above link excel sheet with the formulation which I'm using to maintain our company details since 2015 to till date. (Pivot table and Pivot charts not included as it is a model sheet created with...

First off, I want to specify that I have very little to no knowledge of VBA. What I have put together is a mere step by step copy and paste code. I am just trying to simplify my code from have over 1000 lines of code down to as few as possible, but still have the same outcome. I have a excel...

Can someone help me with this macro on how to have the user pick the folder Sub Details() ' ' Details Macro ' ' Sheets("Asset Backed ").Select Range("A1:G28").Select ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _ "h:\AIM Shared Files\AIM\Certificate...

Hello All, Sorry if this is a stupid question, I'm Fairly new to using Excel and having a bit of an issue with what I am hoping to achieve with a report I'm Creating. I have included a bit of the data below to hopefully help illustrate what I'm working with. I have a master file tab in Excel...

When I click on "Show Details" on a field in a pivot table, all the entries for that row appear on a new worksheet, which is great. However, the format of each column does not match the formatting of the columns in the data table. I have quite a few columns, so resetting the format for each...

Hello everyone, I have a table that the first column is the column of a subscription number and all other columns are currently empty, I have defined that if I double click on one subscriber number, a form will open Then fill in all the data of the same subscription number (eg first name...

Is it possible to nest SUBSTITUTE within an IF formula? I have a column that has a range of numbers in it that I want to combine in a TEXTJOIN string. However IF the number is a decimal, I need to substitute the decimal with an underscore. i.e. instead of 6.875 it needs to be 6_875. I'm not...

Hi All I'm looking for a pointer where to start with this problem. I have two worksheets, sheet1 and sheet2. Sheet1 contains businesses whose credentials are correct. Column A has the businesses Ref No, Columns B-H contain the businesses name and contact details. Sheet2 contains the...

Hi guys, I have a spreadsheet I use as a template for employees to fill in. I would like to save the workbook after employees have entered details under their name located in cell M1 but not overide the current template. So they start by opening the spreadsheet template.xlsm. Enter their...

Hello All, I have a IF formula that is not working saying "too many arguments" however I tried to follow the details HERE: https://exceljet.net/excel-functions/excel-if-function =IF(Y2=88,"Complete","Under Review",IF(X2=88,"Not Started")) Can anyone help.

Using Power Query From folder to return the folder details. The folder I am working with also shows the "owner". That information doesn't automatically pull into Power Query. Is there a way to add a column for that? Ultimately, we want to be able to filter by modified date and owner. Thanks...

Please can anyone help? If i have 3 columns in excel,, A and B and C A contains unique names, B contains details about names in A and C contains values for each of those names in A i want to get average of hte values in C dependant on the details in B.. so i might want an average of the values...

Hi All, I have a large data set with details from A1 to H1 containing details like Date, Time Shift, Week Number etc then from K1 to CY1 showing issues found. These cells are filled in for each product checked as a single part could have multiple issues. I am now trying to pivot this...

Good Morning All I'm having a bit of an issue - i'm updating a form we use for customers (schools) buying in to annual services. Last year we used this form, but left school details fields as freetext which was good, however the numbers in the pupil headcount were either lower or higher...

Hi, Find and replace changing records. I get copies of a corporate directory each week. I want to upload the newest export and maintain a table of only unique records. The Employee ID should be the unique record When details change for the EE id I would like to keep those updates and get...

Hi gudpm again, After my first useform I got excited to create and develop another one which can be useful more likely in my work. For example I have a spreadsheet like this Machine REPAIR DETAILS DATE MECHANIC PARTS USED M1 replaced battery 1/1/2000...