seperate worksheet

  1. A

    Mode function using multiple criteria

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

    how to keep a log of previous runs in a seperate worksheet

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

    VLOOKUP/comparing adjoining cells in seperate sheets

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

    HELP! New to coding-need to split workshhet into multiple by finding a word that ends the data each time

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

    Creating a Template

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top