excel

Hi, I am fairly new to Excel, and I am looking to create a random number generator that can exclude random numbers (these random numbers are not always the same.) I need to create this in sets, for example, A 1 through 12, B 1 through 12, and so on. Would it be possible to have the excluded...

Good Evening, I am in charge of creating the workbook to use for the soccer league I play in to keep track of the top scorers for both male and female players, and also for the red cards and yellow cards. I have sheet with tables for each team with each player, their gender and how many goals...

This is the sixth part of this series. The relevant topics are outlined below. The code accepts a different source table which resides in the project sheet and converts it to the required format. Run the tray routine to generate the raw diagram without the connectors. Bring up the user form...

Hi! I need a vbscript to reopen a spreadsheet when it closes and refresh the document every minute. I have tried using task scheduler but it wont work because I dont have admin privileges. Thanks for your help! :) Regards, Rochelle

I have a table with cell value (Codes) in column "E"and date value in column "I" and because of these codes might be duplicated many times while I need only maximum two cells can be valid with the same code based on the date value in "I" if >=TODAY(). so I need a help please to check if there...

How do I pull in rebate in column G ( after four quarters)? The Sale quarter is an input that can be changed, rebate recognition should change to after four quarters of sale and should do it automatically based on sale quarter.

I work on a sheet where i neecd to check if the value is duplicated in the same column "E" and if date for both duplicated value in clolumn "H" is =>TODAY() then return value as "Valid Stream" otherweise keep it clear i have reatched this formula but unfortunately it has one issue I don't...

I inherited a report from a colleague who passed away recently and I've hit a roadblock while trying to update the data. The report has quite a few pivot tables and a good portion of them reference a table or worksheet called "All_Data". Problem is I can't find the table anywhere. The workbook...

Hello, excel gurus, So, I have a vba code that checks every checkbox that i have in a table, and deletes said checkbox if the row is empty or outside of the table, but I had to put a "+8" in the row range, because the table starts at row 7 of my worksheet. Problem with this, is if someone make...

I am trying to get the script/macro to move my selectee from onboarding table to completed table. 437&438-Onboarding table column y= "Move to Completed" is a drop down and is blank until "YES" is selected from the drop down. (that is the only option) Station Selectee Effective Date Position...

Hi good people. I need help calculating the Work In Progress (WIP) inventory for my work. My Excel spreadsheet has three columns. Column A is the item’s unique identification code Column B is the time that the item entered the warehouse Column C is the time that the item left the warehouse Is...

Hello Every1 ! I have 3 pc connected to 1 newtork and one pc i am using add-in numbertowords but if i want to share & use 1add-in on all 3 pc how i can do, pls guide ? I tried to share from properties but didn't worked for me, may i am doing some wrong step. Thanks in Advance.

I want to make an Attendance system in which i have to calculate the 'Overtime/Deficit Time' for each employee. I have done this successively. Now the problem is when i want to add the total overtime/Deficit time i got the value error in adding negative time(Deficit). Please help me how...

I would like to create an image slideshow that loops through all the images in all the subfolders in thisworkbook.path with a fade in effect for each image and a 5 second timer delay between each image in an excel userform. I searched in copilot and I have some code, but it currently gives me...

Hi there My question is related to the custom data validation that locks the cell as per the value in the other cell. I have two data columns (G1:G1000 and K1:K1000). My question is, if we enter “Open” in cell range G, then unlock the specific cell in column “K” and open drop down with Yes &...

Hi All, I have the code that loops through all my worksheets and resizes all the images but is there anyway to make it so that the images also align center within the cell? Sub ChangeAllPics() Dim s As Shape Dim ws As Worksheet For Each ws In ActiveWorkbook.Sheets For Each s In ws.Shapes...

Hello, I have a file which automatically generates 100 sheets of different brands. The system was updated and now all the sheets include a "- (462," at the beginning of the brand names. Previously this would just be (Armani) but now it is - (462, Armani) Could you let me know how I could just...

The Macro below is what I use to change the sizes of my pictures in one sheet but I would need to apply this to all my worksheets. What could I add here to make this happen? Option Explicit Sub ChangeAllPics() Dim s As Shape Dim ws As Worksheet Set ws = ActiveSheet For Each s In...

Hi, I would like to have a code that copies a string to the windows clipboard using VBA. So i can paste the clipboard to other software then excel. My code is now the following: Dim strText As String strText = FilePath With New DataObject .SetText strText...

Good Morning, I have a set of data with start/end dates which I am trying to split into hour categories so I can dissect further (i.e if a line starts at 5am and ends at 7am I would expect to see 1 hour in the 5 and 6 am columns) My formula splits things up nicely but when the end date falls in...