aug

Dear All, I have tried to subtract the Overdue Invoice Amount, It should go like below table. <tbody> A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB 2 AMT $ TTL DUE JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC PAID OD BAL. TTL JAN...

Hi Folks, Need help on the Pivot setting or option I can use to allow me show the percentage of TRUE on the column from each month see sample result below. RAW Worksheet <tbody> A B C D 1 DateM SLA Met 2 Sep TRUE 3 Sep TRUE 4 Sep TRUE 5 Sep TRUE 6 Sep FALSE 7...

Hi Folks, Need two options for this guys. If Pivot how can I configure the sheet raw to populate on sheet Dashboard percentage base on the TRUE and FALSE details from SHEET Raw Second approach if pivot will be hard formula I can use on Sheet DB to give me percentage;) SHEET RAW <tbody> 1 A...

Dear All Expert, I have a number in table range as show below and how to make the tolerance formula. <tbody> Week Date Output Trigger 4 31 Aug 206 1 30 Aug 201 29 Aug 196 28 Aug 206 27 Aug 187 3 26 Aug 199 0 25 Aug 195 24 Aug 202 23 Aug 208 22 Aug 209 2 21 Aug 200 1 20...

I have a macro that populates a range of cells with the months horizontally, but am getting an error when I try to make it vertical. Horizontal: ActiveCell.Resize(, 12) = Array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec") Vertical: ActiveCell.Resize(12, )...

Please can someone help me with a script - I have a sheet that has a blank row every time a new name appears in column A What i would like is to: Place a total of the figures in column G - total in column F (last row) Repeat the headings from row 1 on each blank line Example of end result...

Please can you help with a script. I have a spreadsheet that goes on for numerous lines - I would like to create a news tab every time there is a name change in Column A - and copy the contents of all columns (B - G) - the name could appear on several rows. ie in the example below 3 new tabs...

Hello trying to get this to loop: Sub WebData_2() Dim lastRow As Long Dim x As Long Dim urls As Variant Dim Prices As Variant 'Create sheet lastRow = Sheets("7th Aug 2019").Range("H" & Rows.Count).End(xlUp).Row urls = Sheets("7th Aug...

Hi, I have 2 worksheets - Course Entry worksheet and Training Room Schedule worksheet. For Course Entry worksheet, user updates data such as course title, duration, training room, etc. As for the Training Room Schedule, it shows a list of training rooms in a monthly calendar view. Once user...

Hi I wondered if anyone could help me with what I am finding to be a rather tricky situation which I am sure someone can help with though! I have extracted information from another system (not excel) into excel and the cell states 8/2/19 and the data is 02/08/2019 17:00:00. I need to...

Hi all, I would like to “SUM” all figures from col. “C” to “O” in one row if in column “B” contains the word Unspecified using a VBA code. Therefore that the rows are not stably but rows 1 to 5 are the headings. I present below the original data and the expected result. Thank you all in advance...

This is driving me nuts and Im hoping that someone knows what is going on. I have a simple 1 col table on sheet 1 with a list of dates. On sheet 2 of the same workbook, I have a table with 10 rows which contains end of month dates from 30 Nov 2017 to 31 Aug 2018 (30 Nov 2017, 31 Dec 2017 ...

hi all, I am trying to sum a group of values that looks for the text in cell B12 in a different sheet (shown below) and there would be several in the column then adds all these values based on an index of the month eg Aug in cell N8 (which would then add all the values for Jul and Aug (in a...

Re: How to calulate hours worked on Sundays in a specific month Hi, I would like to know how to add all hours worked on the sundays in a month. An employee might not work every Sunday in a month. Some employees will work one Sunday, others might work 2 or more and some might not work any...

I have the following formula in A1 to show the current file Name [code] MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1) Result in A1: Aug 2018 New Employee-Term File.xlsx [code//] <- What is the correct syntax so it shows up as...

Hi, I have never experienced this before on this board . There is a thread in the excel questions forum started by the user RyderS on Aug 6th whose title is Buttons that move and to which I responded on Aug 7th. To my surprise, today, when trying to click on that thread it took me to the...

I am working on a monthly menu planner. The dates are merged between three rows in order to allow breakfast, lunch, and dinner meal items each day. The merged cells are causing the calendar to go from Jul 29, Aug 1, Aug 4, Aug 7 (so on, skipping every three days because of the merged cells)...

Hi I am preparing the Project Plan and in which i need arrive at a day when task is suppose to happen. E.g BRD Completed - Mon,20,Aug,18 Submit BRD for BS-Review(cut off is every Friday or Tuesday) Review Date: Every Monday and Thursday I have used following formula H29 = Mon,20,Aug,18...

Hi, I'm trying to forecast weekly cost of equipment and rounding up the weekly costfor a full 7 day period so if a hire commences on a Thursday or a FridayI'd like to round up to the Monday howver I cannot seem to get the formula towork: B3 = Hire From Date of 31 July 2018 C3 = Anticipated...

Hello all, I've got a table with date and time of sportmatches being played. In another sheet I would like to have the most 7 upcoming games. a short/simple example: <tbody> A B C D E 12 Round Date Time yearfrac key/row# 13 1 11 aug 18:00 0,005555556 1 14 12...