individual

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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