help in need

I'm making a spreadsheet for work purposes and cannot quite manage to figure out a formula for some of the data they require, the info is as follows: TAB Name: APPS Column A: Surname Column B: Forename Column C: Sex (M/F) In a separate tab ('INFO') I need to calculate the most frequently...

Hi all, I want to fill a single cell with dates, spaced by 7 from the input date until the end of the month. For example: I enter 02/01 (any format is fine) and the cell should fill with 02/01 09/01 16/01 23/01 30/01 Is this possible? Thanks in advance for any help, sorry if this is a stupid...

Hi please help. I have the below formula but it has too many nesting levels: =IF(C4="1st",'Step 1 Materiailty Assessment'!B25,IF(C4="2nd",'Step 1 Materiailty Assessment'!B26,IF(C4="3rd",'Step 1 Materiailty Assessment'!B27,IF(C4="4th",'Step 1 Materiailty Assessment'!B28,IF(C4="5th",'Step 1...

Hi all, I have a large formula which currently looks into another workbook, part of which is as follows: [Project_Record_List_05.02.2016.xlsx]Customer Handling'!$B$15), the 'Customer Handling' is of course the title of the tab the formula is referencing in to but is also written in cell C2 in...

Hi All, I have a table of data and I'm trying to create a gantt chart, I have looked on numerous websites, even posted on here and I still can't get it to work, can anyone walk me through the process start to finish please? Many thanks Harvey

Dear all, I am in need of some help in creating a macro to get excel to do the following instruction: Split a row with different bullet points (a), b), c) ) in a single cell, to 3 different cells. Thus, there would be a need to insert new cells too. E.G. Current format: A...

Hi All, I am really stuck here. I have a table where in column A I have various bits of info, every 5 rows there is a "TOTAL" row Then this TOTAL Row is split into sub-total by columns STE, STP, RCA ST. Also the table grows every day, including table headers. I need to TOTAL STE for every...

I'm having a bit of trouble creating a formula with too many variables, basically I need up to 5 variables. If K19 is between 1-10 then add c47*28 If k19 is between 11-20 then add c47*20 If K19 is between 21-30 then add c47*10 If k19 is between 31-40 then add c47*5 if k19 is equal to/greater...

I'm not sure how to word the question accurately so I have included some Pictures to aid me. Using Excel 2010 I am trying to copy data from one sheet, the "Form" to a database called "Master" but the data needs to go into a Row that corresponds with employee's pay numbers. This is the Form...

I was working on my Excel 2013 workbook and when I clicked on "Save", Excel froze up and I had to eventually CTRL+ALT+DELETE it. Then when I reopened Excel 2013, I went to my recent workbooks and clicked on the one I was working on and it told me that the file may have been moved or deleted. I...

Hi, Is it possible to update the links including the highlights and comments in the cell? As a background, I have 2 identical workbooks. Workbook 1 - has my actual data. It also has a vba macro event where if there are changes made, the cell will be highlighted and a comment will be added to...

I have a very simplified version of a text string below. I am trying to use mid and find to extract the middle (Bold) data from the string. Right now this formula would return the 123 and 1234567 of the below line items. Can someone look at my formula and tell me how to make it count inward...

Hey guys, I'm stuck: I'm trying to do a personalized budget worksheet, but am running into an issue. Column A has the item, column B lists it as a necessity or a wish. Column C represents the budgeted (expected) price of my item, and after I buy it, column D represents the true value of final...

Hi, I'm a little stuck!! I would like to delete rows based on duplicated text values (names) in column B. The end result would show all individual rows in the spreadsheet with no duplications in column B.

Hey Everyone . . . Looking for some assistance on a formula or VBA. I have the below dataset and I am trying to automate the calculation of the running total. Basically, I need it to say, if the user stays the same, the processID stays the same, the client id is new, and the closed column is...

Hi I am working on a priority list and encountered some problems with it. I would really appreciate all the help, thanks. What I am trying to do is to have excel automatically assign a specific number to the Urgency Column based on how many days the item is from the Due Date. <tbody> Priority...

Hello everyone! I have a problem that I am sure can be helped with excel any help would be much appreciated! List one is a list of names and a number relating to where they came from ie Mr Jason Smith 456 Mrs ayleen Smith 122 etc in alphabetical order, several thousand records. I then have...

Hi all, I am trying to copy an example from a textbook so that i can edit it for my own use and i have typed out the Macro they apparently used. i Have checked a few time and can't see the error but i keep getting a 'invalid control variable reference' error and can't get any further. I would...

I have a mail merge type thing going on where I pull over data and print and then it moves to the next in excel. how I do this is by setting a first set record and a last set record. It prints 10 to a page and then pulls the next 10 so on and so on Lets say I have **45 records (this number is...

I use this macro as a sort of mail merge feature within excel that pulls over data and prints one at a time. StartRow defines what row to start at and print that first and then it moves onto the next all the way to the EndRow which defines what row I want it to stop at. My question: Instead of...