seperate worksheet

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...

I am currently working on VRP with "D arrays. I worked through initial solution, and now I did random descent technique. However, I am supposed to store the results from the previous runs that I did in the seperater worksheet in excel- a log has to be kept. There is a problem with my code, as...

I have a workbook with two Sheets (sheet1 and sheet2) that each have 2 columns of data. Column A is a unique ID and column B is a date. I need to do a vlookup for a matching ID in column A and then compare column B values. If sheet2 column b is < sheet1 column b then I need to update sheet1...

Hi. I am not really a coder and this is new to me but I have an extremely large spreadsheet I need to disect into a seperate workbook for each set of data. While browsing on this forum I saw many references for splitting data, but it always split it due to a certain value in a column. My...

Hi, I have a spreadsheet that is created new each month. It has over 1000 lines of data and several columns. What i then need to do is create a spreadhseet that seperates the data in to new worksheets for all of my technicians (1 worksheet for each technician) then format the spreadsheet so...