made

  1. H

    Excel how to auto run vba code?

    Hi, May i know how enable vba code to run automatically when i open my workbook? and run the code again when changes is made in one of the cell? I would be so grateful for your help.
  2. A

    Pasting to multiple sheets

    Evening all! This may be a far stretch.... I have workbook with 500 tabs. I have made the first tab exactly as it needs to be but now I want to copy that (formulas and all) to the other 499 tabs. Any advice?
  3. S

    COUNTIFS stopped working

    Hi My dropdowns have been working fine. Each time a selection is made, a text cell increments plus 1 etc. The problem is PC wide, as no spreadsheet dropdown selection will increment. A few changes were made to the Trust Centre in order to prevent Excel asking any silly questions. Any ideas...
  4. A

    Sum using Index Match

    I have a request if anyone can help. I am by no means great at Excel, but I have learn a bit. I can SUM using Index/ Match, but when I get to anything other than a general value in the cell, I get an error. I have made the small list with generic terms for simplicity. Very much appreciated...
  5. M

    Creating a timestamp for changes made across a range of cells in a row

    Hi! I want to track changes I have made on my worksheet by having a time stamp against each row. I have data from columns C to AX. I would like to have a timestamp in Column AY (only date would also work), if any value changes in any cell between C and AX. I found a couple of VBA codes which...
  6. M

    How to populate a table with data from tables on other sheets using a drop down list.

    I am trying to populate a main table using a drop down list whereby each dropdown option extracts data from a table from its respective sheet. All the tables are of the same dimensions. Example: I have 3 populated tables for Types of insurance claim down the y axis (public liability, flood...
  7. E

    COUNTS Given Criteria

    I have data that shows the all the store visits made by each person with their timestamps. In Column A I have the Person ID and column B is the timestamp of the visit (e.g. 23/4/2017)<strike></strike> I need a formula that will work out the following in two separate columns: - A person who has...
  8. E

    Counts given criteria

    I have data that shows the all the store visits made by each person with their timestamps and looks like this: I need a formula that will work out the following in two separate columns: - A visitor who has made at least 1 visit in a 6 month period - A visitor who has made 6 or more visits...
  9. L

    View users who made changes to cells

    Greetings! I'm currently using excel 2016 in the office previous versions had a feature where you can view changes made to cells on a separate sheet. This would issue the user's name, date, time and cell number change but I don't see feature on the worksheet. Would anyone know where I can find it?
  10. M

    The best "Excel-ist" you know?

    This is just an open topic of discussion I've been curious about and would like to hear from the community. I remember when I had just turned 20 and learned excel was more than just a bunch of squares you can punch numbers into. Fast forward 10 years, I finally started diving into macros this...
  11. S

    Calculate pay only up to 40 hours

    Hello, I have amount employee makes in C5 and hours worked in D5. I need an if statement to calulate the amount the employee made up to 40 hours only. Thanks
  12. Z

    Need help with Query formula

    I have lots of data one one spreadsheet, the goal is to make a query formula that will search for all the responses a person made based on a cells critera. EX: Sheet 1 <tbody> Name: Response: X A Y B X C X D Y E Z F </tbody> Sheet 2 <tbody> Query Formula Criteria (name): X A...
  13. L

    Find column in another column in exact row order

    Hey, i'm struggling to make a macro which looks up column made out of 5-90rows in another column in exactly same positions. example: column 1: asd asd2 dfd dfd 33h8 reg3 sfd 11d ads6 hef3 fe2 hrt6 rhw4 2f1 fef0 jj column 2: reg3 sdf 11d ads6 In current state that'd find only 1 column made out...
  14. S

    How to extract specific data from a cell

    I am looking to get out from all cells the letters I made in buld out from this cell https://www.screencast.com/t/apAeD0FCrE6 <tbody> walgreens.com/store/c/as-seen-on-tv-roll-a-lotion-applicator/ID=prod6095201-product...
  15. J

    Pivot Table -

    Hi All, I have a table with information, to indicate the type of calls being made and each staff name, however using a manual table i can find out who has made calls and who hasnt. Using a Pivot table i can find out who has made calls and have lovely graphs, what i cannot find out, is how do i...
  16. S

    Use of index for multiple sheets and match for three criteria

    Hi , I am making a format of salary slip using index and match function. i am trying that if i put the month and emp. id the rest data should come automatically to that payslip format. but i have 12 worksheet having 12 month salary on it. and in that i have already made table of the salary made...
  17. P

    VBA code stop working

    I wanted to use the same layout for two projects, and was to lazy to create an entire new worksheet, so I made a copied of the worksheet's whose format and VBA codes I wanted to use. Apart from the colour scheme, I've made no changes to the copied document. The VBA code still works in the...
  18. H

    pop up message that tells you all the changes you made to a spreadsheet

    I use a lot of data entry on my spreadsheet. Is there a way to create a message box that will tell me the entries that I made during the day? I have 3 different cells that would need to be displayed. the first cell ( cell A) is just a description the second cell ( Cell B) is an amount that I...
  19. B

    formula help

    column A is # of contacts made in a week 18,245 Column B is # of FTE 212 Column C is # of weeks 52 how would you determine # of contacts made per FTE per Week ty
  20. S

    Formulas Are Showing

    My spreadsheet is showing formulas in some of the cells. I type in a formula and it appears as though it was text even though it starts with=. Also the format of the cell is "General." Actually, there are 600 cells showing the formulas. But while I kept messing with the cells one or two of them...

Watch MrExcel Video

This Week's Hot Topics

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
Top