excel

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

Hiya All, I have the following formula set in Conditional formatting to highlight the entire row when the town Aston is present. =SEARCH("Aston",$G1) The issue I have is it also highlights cells that contain words with "aston" in them i.e. Glastonbury. Is there a way to stop this? Thanks in...

Hi, Can someone help me with this issue please. I'm searching for ages. My code goes to 'else' when e = 15. At row 15, there is a number/text (C15) that needs to be equal to another number/text (L15). (6002559) When the 'do while' hits e=15 the condition er=et is FALSE, so it goes to 'else'...

I want to make a program that tracks which station each of my projects is at using barcode scanners. My small business deals with putting certain lots through certain stations, kind of like an assembly line but the line is a snake that wraps around it self a couple times over and ties itself in...