topic

  1. K

    Is there a way to automatically duplicate a system subfolder structure in Excel?

    I've been asked to create a tracking template to track every step of the process for formal inquiries that go into a Outlook inbox. The plan right now is to create a system folder for all inquiries, and then in that folder create a subfolder for each day an inquiry comes in, and from who...
  2. H

    How to attach file on newpost

    Hi everyone! I'm new mem :) How to attach file on the new topic Thanks you so much!
  3. D

    Extract multiple strings from 1 cell

    Hi, I have a list of topic codes in a cell and I need to extract just the codes. The only thing that gets me close is splitting the cell based on a delimiter but there are two issues with that 1) I then need to delete the columns which contain the unwanted text and 2) sometimes I may have 4...
  4. R

    Automatic sheet layout based on topic selection.

    The idea is to have a topic selection page where i can select yes or no and then based on my answers the next sheet will show all of the topics that i answers yes to. Images can be seen here: https://ibb.co/YfKK6pG AND https://ibb.co/1GpyjmJ Looking it this it maybe could be something where...
  5. F

    Remove item from drop down list once selected

    I have a work book with a tab labeled Training with about150 training topics. I then have a calendar with each month its own separate tab. What I would like to do is, put a pull down box of thetraining topics in each day of each month that requires training and then oncea training topic has been...
  6. S

    VBA Filter

    Hi, i need some help on two matters. both are related to filters, involving dates and multiple column. a sample of my database as such: <tbody> Name Project Gender Type Funding Topic Date of Application Survey Date 1 Survey Date 2 Survey Date 3 Survey Date 4 Survey Date 5...
  7. D

    Dependent Dropdown, referencing DRanges

    https://docs.google.com/spreadsheets/d/1JLq1yaPo5OwFXCldO4ruQKtBaVho1T2A59IQfgLUgOM/edit?usp=sharinghttp://i1275.photobucket.com/albums/y445/DarkJester89/Capture%20Photo_zpsc3qnmomn.png I've been working on this worksheet for weeks and I'm on the very...last..formula. There are 10 topics in...
  8. T

    Layout help for Pivottable - Yes/No from multiple questions

    I have a substantial database with multiple entries for employee evaluations – each entry showing YES/NO/NA responses for up to 40 individual questions. Currently, I have a summary spreadsheet with various formulas (sumproduct, etc) that presents results based on selected employee name and...
  9. D

    find all values corresponding to each values

    hi all, I want vba code for following activity. Sample data is provided below. Copy each value in 'Find value' column and find all in column 'For Topic 1'. Paste the find all values in the column 'Topic 1'. Repeat this activity for all column Topic 1 to 4. <tbody> Find Value Topic 1 Topic 2...
  10. M

    Barcode Script

    I am guessing that this topic has been addressed in the past. If anyone knows of where I can find the information that I seek I would greatly appreciate it. I keep my inventory in Excel Column A is a list of numbers that are unique that are also associated to the barcode on our boxes I have a...
  11. J

    Projected end dates subject to conditions

    Hi, I'm trying to prepare a study schedule/planner based on certain conditions: Week starts on Monday Study hours/day: 4 hours (Mon - Wed) & 12 hours (Thur - Sun) Topics are assigned a time limit and will roll over to a new day until time limit expires. In case a topic ends midway through a...
  12. Pinaceous

    VBA Hidding Ribbon Tabs

    Hi All, I'm trying to hide the ribbon tabs except for the "File" ribbon tab. Does anyone know how to do this?? I've did some searching on the topic, but I can't find anything useful for my application. Many thanks in advance! Pinaceous
  13. A

    Looking up a drop down list entry in a range defined by another drop down list

    Hi, I'm working on a spreadsheet that we use to record Supervisor safety contacts (when Supervisors have a "safety moment" with an employee). The contacts fall into different categories/topics (ie: PPE, egonomics, etc.). Each department (packaging, production, etc.) has a different list of...
  14. S

    Most frequently occurring text in a range (combo of rows and columns)

    Hi, I would like to see what the most frequently occurring text occurs in the whole range, not just line by line. How do i combine all? i.e. A1:F8? And ignore blank cells? I see there are a multiple threads and posts on this topic already, but all focus in on 1 row or column at a time. Any...

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