1. M

    Get unique values from one column from all spreadsheets in a folder and copy to a new spreadsheet

    Hi, I have anywhere from 60-100 spreadsheets generated from a reporting process in a folder. Each spreadsheet has set number of columns (A through G). Column G (Notes) is used by end-users to put notes. I am working on creating a unique list of all these notes from all the spreadsheets in the...
  2. N

    Subtracting if drop down box says "Yes"

    Hi all, I would like some help with an excel spreadsheet I am creating to keep track of my overtime at work. As seen in the attached file, Column D is the overtime that I worked on that day. Column E is a dropdown box (Yes,No) which identifies if I have used those overtime hours (Eg. On X...
  3. B

    Excel Solver | Need help resolving a constrained optimization problem

    Hi, I am quite new here so I am not exactly sure how everything works. I just wanted to know if anyone could help me with Solver? -Given some information, I need to construct a spreadsheet and use Solver to resolve a constrained optimization problem (may be simple for some but it is my first...
  4. V

    Negative values in SPARKLINE "charttype","bar"

    I am using sparkline in google sheet specific to charttype as bar if all the values are positive then works fine if I have any negative values then it shows full bar attaching both the screenshot and the formula here =SPARKLINE(P24,{"charttype","bar";"max",max(P24:P25);"color1","#AEB7C0"})
  5. M

    Google Sheets Help

    Hello, I need to make a spreadsheet but I'm still new to Google Sheets. I would like how it would be to make a spreadsheet that: from an initial date, put the number of days you want, then show the end date (except for the holidays I put and also weekends). At the end I would like you to show...
  6. D

    Medical Procedure Database

    Please excuse any wrong terms I may use when attempting to ask my question - I'm new to the community :) My goal is to set up an excel spreadsheet that can serve as a database from where I can pull information, in any combination, to perform research, evaluate procedures, etc. Many of these...
  7. J

    Refresh spreadsheet when listbox updated

    Hi, I need help writing a vba code which had 7 textboxes and an update button to update the listbox then spreadsheet updated via the listbox. base on the colunm selected from the listbox, it populates through the textboxes. when selected column from listbox is selected, update is made via the...
  8. R

    Rolling Calendar Attendance and Tardy Tracker

    I'm trying to help my manager create a spreadsheet to track various types of absences and leave. I've linked the spreadsheet here to see what I have set up, but need to figure out how to extract the right data. I am looking for a way to figure out absences based on a rolling calendar year, and...
  9. T

    VBA help with time results

    Hi Everyone, I am trying to create a spreadsheet to work with my timer. At the moment my timer is ok and i can lap it and send the data to the active cells. My issue is that the amount of rows is varying. I write a number in the first column from one to however many i have. Im a bit stuck...
  10. C

    How do I bring my excel program to the foreground?

    Hi everybody, I've been doing some research on how to bring my excel spreadsheet to the foreground whenever it goes into the background. I've stumbled across 'AppActivate Application.caption' but it doesn't work. The excel spreadsheet simply flashes orange in the taskbar and doesn't come to...
  11. L

    Finding values that don't have the right # of characters

    I am working with a spreadsheet (received from an external source) where all values should have 9 characters. I want to highlight the cells where the values are fewer than 9 characters. Is there an IF/THEN or some sort of function that I can use to highlight? It is a very large spreadsheet...
  12. P

    EXCEL shapes.visible won't work anymore

    I have the following code. It used to work on this spreadsheet but no longer works. ThisWorkbook.Worksheets("Sheet1").Shapes("Terminator").Visible = True I know there is nothing wrong with the code because I made a brand new spreadsheet and tested the code and it works. However, there is...
  13. D

    Excel Indexing formula to Match two criteria and find the closest match on a third criteria

    Hello, i am working on trying to automate one of the tasks that i have to complete at my job, this consists of matching the charge rate on our system to a list of charge rates in a database, the old way of doing this works but is very manual and takes a long time to complete. the new way that i...
  14. D

    What would be the best way to do this?

    I am making a spreadsheet that allows you to enter an activity, press a button, then it stores the activity. A list of activities are compiled over time and there is another button that selects a random activity from the list. You can't use variables for this as they only last until the...
  15. G

    Creating a variable cell reference in a 'sorting' macro

    Sub All() ' ' All Macro ' ' Keyboard Shortcut: Ctrl+z ' Range("A6:Z23").Select ActiveWorkbook.Worksheets("All").Sort.SortFields.Clear ActiveWorkbook.Worksheets("All").Sort.SortFields.Add Key:=Range("Z6:Z23"), _ SortOn:=xlSortOnValues, Order:=xlAscending...
  16. K

    Importing data from multiple workbooks to one sheet in master workbook

    Good day all. I'm busy to automate some of our time sheets and overtime reporting. Each employee completes his/her own timesheet in a Excel Spreadsheet. Some of this information is then merged into a monthly summary. At the end of the month the employee is using a button, with a Macro, to print...
  17. W

    time calculation first time last time

    I have a spreadsheet where the columns are (A)operator (B) time of transaction (C) transaction type. The same operator can be listed up to 200 times in the spreadsheet. I need a way to calculate the operators total time (Last transaction minus first transaction). I have 50 operators within the...
  18. T

    Automatic alphabetic data extraction macro needed

    I came across someone in the office today that has been spending huge amounts of time on unnecessary copy/paste/sort gymnastics and it hurt my soul to watch. I know you geniuses can help me/her out so here's what she's doing... She's working with 3 spreadsheets; I'll call them Initial...
  19. S

    Pivot Table Filter For Multiple Survey Responses

    Hi! I have a spreadsheet with data from a survey: 9 questions, each with an answer between 1 and 5. I have a pivot table that shows me a breakdown of how many of each answer (1 through 5) there is for a single question. Is there a way that I can include all of my data and filter by question, so...
  20. E

    How to make cells equal certain row

    I am looking for a formula to help me in my spreadsheet. I want it to look for the month of January and an ID# with the amounts in that row to copy it into the next 11 months. So January would be column B and ID# in Column E, while the data i want to copy are in J, K, and L. It should display...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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