individual

  1. A

    Master File with Hyperlink

    Company policy dictates we don’t save excel files on our desktop as a revision could occur and we work off old forms which is against our ISO procedure. We must open them from our employee portal every time, I do this daily with about 10 individual documents. I was thinking of making a master...
  2. jl2509

    Print Multiple Charts to a single PDF, but not all Charts

    Hi All, Can anyone help with my issue below please I have multiple charts on a worksheet (Dashboard) and have several command buttons which will print selected Charts. I can print individual Charts to PDf, Print Multiple Charts to Individual PDFs but cannot fathom how to print multiple Charts...
  3. M

    Multiple Worksheet_Change macros in one worksheet

    Hi Excel gurus My 2016 workbook requires the following Macros and also a suggestion on Data collation I could not upload a file as the forum rule says but tried to copy the table but it is not copying the borders. Please let me know if it is not helpful 1) MACRO in the ‘Task Allocation’ sheet...
  4. C

    Macro to open and close another workbook that's password protected

    Hi, I have a number of workbooks (15) for staff that contain stats - these are password protected to the individual. I have a mastercopy which is linked to these so that I can pull the stats together for me to analyse the team performance. Currently I have to input all the passwords in...
  5. S

    Can't autofilter dates

    I am trying to use autofilter on a column with dates but it only lets me select months and years - i.e.not individual dates/days I've changed the format of the column to date but to no avail. Any suggestions?
  6. M

    Expand Range of Values to Individual Values

    Hello Friends, I need a solution for my complicated requirement. I have specific format of value range. I need to expand the values as individual values. Example: Input - 1to10. Output - 1 2 3 4 5 6 7 8 9 10 this is a simple example. My specific format is **150**155. The ** replaces by any of...
  7. R

    Sum of individual values in a Cell

    Folks - Need some help here. I have searched the forum and haven't been able to locate this specifically. I have a sumif function that adds up all the values in a column based on set criteria in another column. Is there a VBA Code/Macro that would convert this sumif value into the sum of...
  8. L

    Summing number of entries for many different entries

    Hello, I have a data set I am working with where I have a long list of zipcodes. I need to count for each individual zipcode, how many entries there are. Here is a picture of my spreadsheet: https://imgur.com/7mEewe5 I am having trouble attaching excel sheet to this post, so here is a dropbox...
  9. J

    Macro to Add Individual Tabs to One Main Tab

    The attached spreadsheet is an inventory list. Each tab is a different category of parts and supplies and the first tab, called "All Parts Catalog Only" is the main page. I am having a problem with people adding new parts and pictures to the individual tabs but not adding them to the "All...
  10. W

    Splitting and re-importing Excel Sheets

    I am new to this forum and new to VBA. What I have is a "master" workbook where each tab is a different employee timecard. I want to split each sheet into its own workbook, have employees update their individual sheet, then re-import the data back to the master. I have found the code to split...
  11. B

    Complex reference question

    Hi! I would love to know if anyone knows I would go about doing this. So I have to following: - MASTER spread sheet with columns of Scrambled number sequences. - Individual sequence sheets that reference a columns of scrambled numbers BUT start haphazardly anywhere in the sequence. I want...
  12. S

    VBA to sort range of rows based on value

    Hi I am completely new to the coding side of Excel (using Excel 2013) and am creating a spreadsheet for where I work. Basically its a development chart that tracks the readiness of individual employees filled out by our team leaders and there will be a master one that links all the info...
  13. G

    Running Macro From Separate Workbook

    Hi all, I have an excel workbook that keeps track of every individual quote that my company does. Within that excel workbook is a macro that takes the pertinent information from that single quote and puts it on a master quote sheet so that we can look at and filter out historical data all in...
  14. S

    VBA - "Indirect" needed

    Good afternoon On Sheet 1 of my spreadsheet I have in column B, starting in B2, down to B22 the list of names of the individual tabs. B2 = AAA B3 = BBB B4 = CCC etc. What I need please, is some lovely VBA coding that uses an INDIRECT (or whatever the equivalent is in VBA) that looks up that...
  15. B

    any month calendar template help - Excel 2013

    Hi all, I'm using the calendar templates available in excel 2013 and wondering if what I'm trying to do is possible. I've already added a drop down list of the 27 people this applies to. I have a data sheet, with resource name, task start date, task end date &what the task in individual...
  16. M

    Refreshing FactSet Codes/Functions

    I am using an add-in called Factset which I refresh on a global basis (multiple sheets in the workbook) with the following line of codeExecuteExcel4Macro "FDSFORCERECALC(FALSE)"This code executes a refresh across the whole worksheet but I need to be able to run a refresh on individual pages...
  17. S

    Count nubmer of time a date in specific month appears

    Hello all, I have a worksheet which contains dates that people have been out on visits and wish to report how many times there was a visit occurrence within a particular month undertaken by a particular individual for a specific reason. Both the individual and reason are also logged on the...
  18. J

    Countif by individual date

    I have a column of dates and a column of actions (buy and sell). I need to be able to count how many buys or sells there were on each individual day. I have part of of the formula as Countif(B2:B1000,"Buy"). I need to know how to add onto this to be able to count the buys on say 1/1/2017...
  19. E

    Resizing individual cell in a row/coloumn

    Hi, I've searched for an answer for a while now. And according to my research it is not possible to resize an individual cell, without resizing the entire row/coloumn. I'm posting here to validate my research, which is telling me that it is in fact not possible. :) Thanks in advance
  20. K

    Make a group fill in individuals

    I need to create a health record for my sheep. I would like to be able to put in details for both individuals and groups that will populate and organize all the data into just individuals. I.e. "Wormed all sheep" "All Sheep", "B16 is sick" "B16", "Vaccinated Ewes" "All Ewes", "Jacks is Limping"...

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