fluff

Hi, I'm seeking to develop a formula in Excel to calculate the number of weeks left in a month two weeks from the current week. I use the following formula to get the week and then 7 days are added and dragged to get the next 16 weeks. 14+(TODAY()-WEEKDAY(TODAY())+2) However, I'm seeking ways...

Hello all, I'm having trouble with conditional formatting formulas for the following percent complete versus start and end date situations. I've also included a screenshot to give you a better picture. -On Track (Trigger- Based on the current date, the task will be completed on time by the due...

On which country did the company spend the most money in Salaries in 2022? Employee ID Full Name Job Title Department Business Unit Gender Ethnicity Age Hire Date year Salary Per Month Bonus % Country City Exit Date BHR02002 Kai Le Controls Engineer Technology & Engineering Manufacturing...

BCDEFGHIJKLMNOPQRST2WorkingWorkingNo Formula3CARLIGHT BLUE2385 CARLIGHT blue2385CARLIGHT blue554CARgrey88CARgrey8CARgrey85CARwhite2013 CARwhite20133CARBLUE20136carblack6324 carblack63244carblack63247cargrey11cargrey1carDARK BLUE1189769=IF(AND(B3="CAR",ISERROR(SEARCH("BLUE",C3)))*(D3=""),E3,"...

HI EVERYONE.... I want to Export an Access Database table on OneDrive Folder Online Into an Excel format file. So i want to protect the file's data with Password protection. I exported a table with help a Macro command as i want but it Visible and Available to everyone. . . . . Is there any...

Hi All I have created a COPY button and a CLEAR button on an Excel file. And I have been using it for 3 months without any problems. Suddenly the Error below came out when I click COPY button. CLEAR button no problem. I just want to know, is this error related to my VBA code? I have...

Hi All, My previous post is about copying the worksheet and renaming it based on a specified cell value by using the click button. But still in the same workbook. See below the VBA code:- Sub RectangleBeveled1_Click() Dim ShtName As String ShtName = Range("L1").Value & " " &...

Hi All, This entry actually has similarities to my previous entry. Only this time, I tried to use the same formula to get data from multiple criteria. I have amended the formula, but not sure it is correct or not. (Having two criteria is fixed but the other two criteria are variable) Need...

Hi All, Need anyone helps. What's wrong with the below formula? I want to use this formula =IFERROR(INDEX(STORAGE_DATA!$E$3:$E$200,SMALL(IF(1=((--(INV_A6082!$I$1=STORAGE_DATA!$D$3:$D$200))*(--(INV_A6082!$K$1=STORAGE_DATA!$G$3:$G$200))),ROW(STORAGE_DATA!$E$3:$E$200)-4,""),ROW()-4)),"") To...

Hi All, I need help me to edit below formula to copy & paste data from FG_SHIP sheet to SHIPMENT_DATA sheet but need to separate some column. 1. Copy data from column "A3:F" & paste to "A3:F". 2. Copy data from column "G3:G" & paste to "H3:H" Sub RoundedRectangle3_Click() Dim wsFG_SHIP As...

Hi All, Need anyone's help to view this VBA code. I'm not sure what's wrong. Repeated edits, but still came out error #9. Sub datasheet() Application.DisplayAlerts = False Worksheets(Array("FG_Store Bundle", "FG _Ship Bundle")).Delete --> Is there something wrong here ...

Hi All, I need help to edit below formula. I want to autofill the formulas starting with the IFERROR (G2) in the column G until the last row that contains the data in the cells next to it (Column C, D, E & I). Column C,D, E & I is the cells that the IFERROR refers to. Sub fill_all_column()...

Hi Team, I have input sheet with employees time entries. It has the columns as Company, ID, Name and time entries which are aligned date wise and total break time for each employee in below format. In/out time would be recorded each and every time when an employee swipes the card for in or...

Hi Everyone, Happy New year to all Great ones. Please help in achieving my task, I have tried to some macros and some vba code to do some work in this workbook, actually I have prepared this excel for stock and inventory management as per our requirement. In this workbook user can do following...

Hi Everyone.. I have used the VBA code below to transfer data from another sheet to another sheet before. ___________________________________________________________ Sub RoundedRectangle6_Click() Dim wsIN As Worksheet Dim wsRegister_IN As Worksheet Dim CopyLastRow As Long Dim DestLastRow As...

=MIN(IF((A2=sheet2!$A$2:$A$1000)*(sheet1!B2=sheet2!$B$2:$B$1000),sheet2!$K$ 2:$K$1000,"")) i am comparing 2 column in diff sheet and would like to call for result in column k. but this formula work for number not for text, can someone please help me here..

Hi Friends, Please help me to get solution for the error i face at attached code. Much appreciate.

searchable column all cell sheet1 column no. B. Search from sheet6 column no. A workbook password 1 and 2 https://drive.google.com/file/d/1350IeJrS2Ld4MnRhVLnQ40gAvCxO4Y8Z/view?usp=sharing

I want macro with an automatic update as per the attached excel format 1. Sales detail year-wise (sheet separate) 2. customer detail consolidate detail (sheet separate) Following should be variable 1. card no. (if possible multiple numbers) 2. customer name (partial search) 3. year The...