individual

This all content are in only one cell. i want to give multiple hyperlinks in single cell for each individual content.There are 10 pdf files in my folder..i want to open them by clicking on individual content <tbody> 1. Our Lr. No.Nil dt.06.04.2018 2. PD NHAI Lr. No.NHAI/PIU-SR//NH-...

I need to find a way in excel to show me the lowest amount shipments it would take to send out all of these orders, without splitting individual orders, by adding together rows that could fit under the volume threshold of 3400. Any help would be appreciated. https://imgur.com/a/X8AXTZO image is...

I have broken out my pivot table by a filtered field so now I have numerous tabs. I want to be able to set Rows to repeat at top for all of these individual tabs but that option appears to be grayed out. Thoughts on how to accomplish this?

I have attached a link of a screenshot of the workbook I am working on. I will try to describe what I need, but it might be easier to see the picture with it. https://postimg.cc/BLm3d5t4 *in the workbook I have a main "DATA" worksheet & an individual worksheet for each individual egg. So...

Hello... I need to embed an individual Powerpoint slide in to an Excel cell. I have searched trying to figure out how to do it and can't seem to embed just an individual slide. Is this even possible? I figured I would just come here and ask the professionals...can anyone please HELP?

Hi Folks.Hoping somebody here can point me in the right direction or provide a little assistance with a little quandary I've now found myself with.I run a daily KPI sheet for various sections of my workplace and we have a rather large workbook (30+ sheets) that runs myriad of statistics for a...

Hi, I have 10 tables which represents 10 regions all have individual files, the tables are the same in structure but obviously the values relate to each region. I have created connections for each file and then appended these to make one query table which is easy enough. However, I now...

I have data in 9 separate sheets in the same workbook which i need to combine. the objective is to merge all the data into one master sheet to be used for analysis and reporting. The data in the individual sheets will have the same number of columns and column headers. Each column represents a...

I have a dashboard tracking the number of pallets stock that we have stored at a warehouse. Each pallet has an individual location, but each location may appear multiple times if it's shared with other products, so I have been using the following formula to count the number of individual...

Hi all, was hoping someone could offer some advice/help. Trying to devise a way of logging payments using a simple userform. I was hoping to have individual sheets for individual jobs with a dropdown on the userform correlating to each sheet - hope is that user would have to select job...

Good Evening, I have been struggling with this macro code for a few days now and was hoping I can find the answers here. I am a zookeeper (birds) and we are changing our Incubator room process to all digital (there is a spreadsheet we use for basic data "egg measurements, parameters for the...

hi all, as the per the title, is there a way that an individual tab can be hidden and can not be viewed without a password?

I receive an excel file each week that has the race of individuals noted as a single six character Boolean string (e.g., 100000 or 011000 or 000111 etc.). Each 1 or 0 is a "yes" or "no" to the corresponding races. First digit "White", second "African American" etc. As you can see, an...

Hope you can help!! I have a progressive pricing formula I need help with, been tearing my hair out Each band gets individual earnings in steps apart from <10 that gets nothing. In the below example customer sells 35 baskets, so will reach the 4th band. Band 1 - Zero Band 2 - 10 * £1.15 =...

I have a Pivot Table that contains 3 columns. Column A is the date that the data applies to (10/28/2018, etc.). Column B is the individual category the data applies to (<6 Mo, >6 Mo <12 Mo, etc.). Column 3 contains the individual amounts that apply to that category, based on that date (.0030%...

Fluff Per your request, I am submitting this request in a new thread. For each of the individual worksheets being analyzed in the array, I'd like to get the total column count. I added a line of code (lcolumn) to the "One week only" macro, that I thought would do this. However, the code is...

Hi all, I have a table with a Date Field, each date is individual. When I add to a pivot table, it automatically sums or groups by month, instead of day. It is analyzing waste data from machines, there would be one record per day per machine that I want to see in tabular form. I cannot work...

Hi I'm using Excel 2016 and trying to make what should be a simple chart. I have a workbook with individual sheets to record individual progress through a variety of competencies. On each sheet is a total for how many competencies that individual has completed out of 219. On a separate sheet I...

Hi I'm using Excel 2016 and trying to make what should be a simple chart. I have a workbook with individual sheets to record individual progress through a variety of competencies. On each sheet is a total for how many competencies that individual has completed out of 219. On a separate sheet I...

Hello everyone, So I am struggling to fill out the table as attached. I want cells to return values from individual tables matching the date on top of each table to the date on row 2 and to match items from column B to each individual table depending on the first match (dates). It is...