business

Hi All - I have below code which loops an array (filters column A) to create a report per business. However, I am encountering an error everytime my arr is just 1 business. Can you help me modify below code which will proceed even though there is just 1 business in column A? Thank you! For i =...

Hello, I need the Column R to be search to see if it contains the value in Column C and for each row that does not contain the value in Column C to have the row deleted. The below is a sample of the data: CR Number FRS Type FRS ID Business Risk GxP Risk Other Regulatory Risk FRS Name Doc...

Hi all I have a workbook that reports due dates for documents to be reviewed. I have 11 Business Divisions that need to get a copy of there due and past due documents only. To eliminate having to filter and copy and paste information to a new workbook and save etc was hoping a macro would be...

hello, I have 2 columns of dates I want to find the number of business days ( ignore holidays) between ColA + ColB then add the number of days resulting back to ColB ( date or cell No ) to show a future date I used networkdays to get the difference but can't get the rest...

Hi guys, I am trying to count how many times a text appears next to a staff ID across 5 columns. I foolishly thought a countifs formula would sort it, but I'm getting an error so that's obviously not right :confused: Below is an example of the data I'm working from (I can't attach a...

HELLO EVERYBODY!!:( CAN YOU GUYS HELP ME HOW TO SOLVE THIS QUESTIONS?? REALLY NEED YOUR HELP GUYS COZ I'M NOT GOOD IN EXCEL ESPECIALLY ABOUT RAND AND PMT FUNCTIONS. SO I HOPE YOU CAN HELP ME TO SOLVE THIS QUESTIONS...

Hi, Have been working on a project, Am calculating the total hours worked for business days based on the Start/End date & time excluding holidays and weekends but the result is not as i wanted for, FYI, BUSINESS TIME: MON 5:00 AM UNTIL SAT 5:00 AM FORMULA USED IN CELL (D2)...

Hi all I've been googling for 2 days on this and still have nothing. I'm looking for some VBA code to seek out and remove all / any .TMP files that are created, across a whole server. I'm looking cause we have a issue with in my business of files creating lots of .tmp files If anyone has any...

Hi all , I need small advice !!. everyday we pull data from Oracle business application which is web based tool and I daily pull reports for our analysis . so now my question is can we pull that date using VBA that interface with the tool and get the dump . and point to be noted there is...

I have a data set of accounts which is about 20 columns and 800 rows (could be more or less depending on the month). The data is extracted from another program/server, then saved to excel. In column "C" I have business names. I am trying to identify which business names are for the same account...

Hi, I would just like to ask for help for a formula on how to calculate the due date with below details. It should only count business hours, exclude weekends, and if possible holidays. Ticket Open date time: 06/28/2017 21:00:00 Time required to complete: 16 hours Due Date: ...

Hi, The following vba works fine, however if a file is locked and is read only, the code stops. Is there a line I can enter so it ignores the error? Better still, inform which file is read-only? sub copyfile() Kill "\\retail\dfsroot$\31705 - Business Change\3. Business Readiness &...

I want to understand the best way to run a simulation in excel. Input data: Client orders (normal distribution, time of order placement is random over 24 hours). 1 order is a box (it contains 10 items). Step 1: Compare to Inventory level, do we have over 10 items? If yes > go to step 2...

Hello again everyone! I was wondering if someone could help me with a problem i have. I work for a company that sells commodities (for this case i jsut need help with coffee), I have a sheet with our internal countries of origins and destinations along with the amount (in tons) that we send...

Dear, thank you for taking the time to review my issue. I am attempting to create an excel template for my sales team to use. The first 5 columns establish a list of all our possible product ID (800+) (category/type/brand/specificities,...) Then I created formulas which look for this ID in...

I am creating a working template spreadsheet for a small business owner, and she would like to see how many repeat customers she is getting. I have built a table that has the customers names on one column sorted alphabetically. Just curious if I can write a formula that will countif. The way...

Hi All, I have a question. I have the following code saved in my macro: 'Open ITEM MASTER SKU Workbooks.Open Filename:= _ "R:\Shared\TEAM\VMI FILES\ITEM Master SKU (NEW).xlsx", ReadOnly:=True, Notify:=False However, I would like to add in some code that will open a...

I am tracking how many days an order is late. The formula I am using is =IF(H4=0," ",H4-G4). That translate to =IF("Date Received"=0," ","Date Received"-"Date Wanted". Can I make it to where it only counts business days? We are open Monday through Thursday. <tbody> Date Wanted Date Received...

Dear Group Members, I have recently joined this group since I have started a University course which requires VBA/SQL programming. Since I have not prior experience in programming, but have some IT knowledge, I would like to ask for your help.:) For my project, I have to come up with a...