individual

Hi there, I have a 'feed' of data on a sheet1, which reports the time and location of when I click on some scoreboards (sheet2) to report + or - points for 4 candidates doing a test. I would also like to have individual 'feeds' below the scoreboards themselves so the examiner can see the...

Please could someone have a look at this as its a bit too hard for me to code. On MY workbook Have 3 sheet Sheet1 = “Customer Records” Sheet2 = “Data” Sheet3 = “Dormant” I take data from an online web form and paste it in to Sheet2 “Data”. I then run the vba to sort the data...

I have a workbook that I use to track attendance for meetings, training's and a few specific duties. I have a worksheet for each individual I track where I put the totals each month. I have another sheet that references each individual sheet to give me a good overall view for all individuals...

Hi everyone, I'm looking to send all worksheets in a workbook through email as individual files. I was using this sort of method to split the files but I would like to split and email them: https://www.extendoffice.com/documents/excel/628-excel-split-workbook.html Workbook has sheets A-F, A...

Hi all hoping someone on here can give me a slap to the head and tell me what I am doing wrong. I am trying to write and Index Match formula and I am running into an issue where I cannot pass the formula variables IE Sheet names Range("D20").FormulaArray = "=INDEX(" & month_Sht_Name &...

Hello, I am having many timesheets say around 60 in H:\JJ\Charge Out\Mar 2018\Individual TS - with same format. Every individual is sending me Time sheets with naming convention as their name Eg. Adithya TS , Ravi TS, Megha TS etc. I need to consolidate the data from those sheets to one sheet...

Hi, Not sure if it is possible, but I am looking for a way to move contents of a dropdown into individual adjacent cells. Please refer to link below that contains small test file. https://ufile.io/itmb6 Thks.

I realize this is very easy for most on this board, but my expertise is quite limited. I would like to build a formula to add a unique normalization factor to scores that that individual has given. <tbody> Individual Score Score + NF Normalizing Factor AM 2 AM 0.00540 AM 1...

I realize this is very easy for most on this board, but my expertise is quite limited. I would like to build a formula to add a unique normalization factor to scores that that individual has given. <colgroup><col width="100"><col width="100"><col width="100"><col width="100"><col...

is there a macro I can write that will print all the tabs in my file to PDF and save each individual tab into the current folder naming them by their tab name? thanks

Hello Marvelous EXCELers, Here is what I have: In cell A2 I have a value (numeric), in cell B2 a set of codes (alphabetic) delimited with a comma. Here is what I need: I need to find out how many entries will be parsed into individual columns if I perform a Text-To-Columns operation on cell...

Hi all, newbie here, don't know what else to use besides IF function for this. Reaching nesting limit doing it this way. Any alternative ideas are appreciated! Formula in B5 of image attached: =IF((AND(C2=1.5,D2="L",H2=0.625)),'[1-MASTER.xls]A & LH SINGLE ROD END'!$M$10, (isolating this on...

I have a single cell with a few numbers, along with other information, for example: [9273, 9274, 9329, 9342] I want to output each number in an individual cell. How can I do this? Here's an image for reference: https://i.imgur.com/bu1dzix.png

All, I have a sum products that is working for individual things. =SUMPRODUCT(--(MONTH($B$15:$B$1010)=MONTH($AF$3)),--(YEAR($B$15:$B$1010)=YEAR($AF$2)),X15:X1010) I then write one with mult arrays...

I have a Workbook that has 10 different Worksheets in it, all with their individual names. Then I have 10 separate Workbooks, all with names corresponding to the Worksheets names. I am looking to copy each worksheet in the original Workbook into its relative individual workbook.

If I have a corrupted XLSX or XLSM file, can I recover by converting it to a ZIP and reading the individual worksheet XML files? Ed

Hello all! I am once again posting for some support. I have developed a spread sheet that reports back information to the "master sheet" from other sheets in the workbook. In my scenario I am trying to improve a function where three contacts need to be made before the file can be escalated...

Hello All, I have a formulated table and over 100 workbooks with different names. I would like a macro that will let me pick an individual workbook and pull data from it into a master workbook. Can anyone help? Adrac

Hello, I have a table of data showing emails and phone calls done by different agents during different months. If I wanted to show the lowest or highest number of emails/calls done by an individual in each month, what function should I use? <colgroup><col width="64" span="3"...

I have a few dozen sheets that I need to do the following with: Column A in each sheet has an individual's identifier (name) Column B has a number corresponding to that individual I need to add the numbers in Column B across all sheets for each individual in Column A This would be simple if...