help

For work, I'm creating a schedule that has automatically updating dates. In the first relevant date hex I've inputted '=DATE(year;month;day), which by itself works fine. Now, this afternoon I saved the excel file with the other cells referring to one another (and to the original) with the...

I have a large dataset (c.75,000 rows) and I'm interested in the data from three columns. 1. Reference Number 2. Person 3. Value I want a formula to show to me who spent what on each job and return information the below Ref Reference Number Person Value 1234 Joe Bloggs 10 1234 Blog...

Hello! Thank you in advance for visiting my post. I understand there have been a couple posts here already that ask for help regarding VBA code and moving data from one sheet to another based on a drop-down value, I appreciate your help nonetheless. ---------- We are approaching territory...

Hello I use a macro to save mail merged documents into word and PDF files; very handy. I must select all the rows above the row I need in the recipient list for it to work. If I only ticked "Sam" and left "Connor" and "Vincent" unticked, the macro will produce a "runtime error 5631" on...

hey guys i would like to create a summary of the table into the table below in which when data is entered in the general table the summary table will only show the which have defects such as the poles that are rotten will show up in the table below , also the the pole number from the above...

Hello, My excel is a master document that pulls in data from different excel sheets in different departments, each of which are all updated daily. I need to save the "master" excel once a week into a different excel with all the values pasted. This creates a weekly snapshot of the data as it is...

Hello, Here is the issue I am having, I built a workbook containing several tables, each table on their own sheet. The purpose of the workbook is too assist with tracking of patient lines. How the table functions is that when a new line is placed on a patient, a staff member will add that...

I have started a new job in the construction industry and want to continue to be able to use excel in my day to day work as its a very powerful tool that I'm already familiar with. However I've run into a problem in that my firm use the FIS dimension formatting for everything. For those not...

Hello, my UNIQUE, FILTER formula is pulling through results but autofit row height is refusing to work. I have selected all cells and used autofit row height and applied wrap text but it is not working. I have to re-select and apply these every time the formula pulls through a new result...

Hello, The below sheet calculates the figures based on number of objectives set and how many of these objectives have received 'needs development', 'meets expectations' and 'exceeds expectations' criterion. I need to be able to calculate an overall status in A8, based on the following...

HI there. I'm trying to: Copy a range and paste it into another sheet (could I create one on the fly?) Then create a temporary workbook to copy the same information (could I eliminate the step above instead?) Then save the new file as a .txt file on the desktop with a specific name I'd like to...

Hi all, I am trying to build a part number generator based on certain characteristics of what's required, and I am not even remotely sure how to achieve this. My excel skills are definitely not this advanced! Any help here would be really appreciated! I will upload pictures I am working on...

I have one sheet called "data dump" and one sheet called "pulls" in the "data dump" sheet i have three columns. One has a name, one has quantity, and one has price. I am trying to find a way to take the rows from data dump to pulls based on a keyword. AKA: If column A has word Corrupted in...

I'm trying to get multiple tables to self reference to hold the information in place that I've manually added, somehow it's not working. I've scanned the website and come on to another tread with the same issue, and a recent YouTube doing the same, but unfortunately no success. Mr.Excel: Excel...

I have a dataset which will have columns of Item and Status ( there are more columns but these are the two I need to use for my result) Basically create a filter or use VBA to create a new dataset where I find duplicates of the combination of Item and Status, but keep the 1st instance of that...

I have a working code to ask user for: - a product - what column to put it in - quantity of product All this happens based on customers region and checkboxes. (Checked regions will get data from user input) Code is working fine in columns from C all the way to Z. But when I try to change the...

Hello In C1 i'd like to be able to type a name and when the search button is clicked, excel performs the search function. I've tried recording a macro for this but it keeps going to an incorrect cell. Is someone able to help with VB that I can assign to the button? Many Thanks

Hello, This one has the potential to be quite complicated, as UK holiday law is governed under the Working Time Directive. I have been trying to make a calculator on Excel which calculates holiday entitlement and can also take into account if someone starts employment part-way through the...

Probbably a really simple solution to this.. When my coleagues are quoting, sometimes it could be for 10-15 rows others could be up to 500 rows. instead of them constantly adding lines to the sheet and running the risk of removing formulas, is there a way that I can have a row or two where when...

Hi, Using formulae and Name Manager I am able to display one picture based on the content on one cell. However, this does not help as I am looking into populating a table (few to several rows, this may vary) with pictures based on the content of [@[Reference]], thus allowing several rows to be...