apr

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 All, Need a help on resolving the below scenario. I have a column A with Months and Column B with unique products ID's. Each months are having checkbox and i need based on the check box selection, the text box and excel sheet should be updated with the all the products from that specific...

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

Good morning I have a workbook which has 9 individual Dept sheets to record travel costs. I am looking for help in calculating the total monthly cost on each sheet and transfering that figure into the correct month on the summary sheet. <colgroup><col width="64" style="width:48pt" span="7">...

I am trying to find the cell in a row that is >= 0% <tbody> Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec -0.3% -0.2% -0.1% 0.1 0.2 0.3 0.4 0.2 0.5 0.1 0.15 0.1 </tbody> In the table above i need to return Apr as the first month where the percentage is >= 0

Hi i'm trying to fill a formula where the reference will sequence the worksheet tabs i.e if worksheet tab 1 is Apr, tab 2 is May etc then by having a formula referring to worksheet Apr and dragging the formula down it will fill the sequential worksheet tabs, is this possible i can't seem to make...

I have many sales pivot tables showing columns of Current year, last year and plans. Last year and plan data is from Jan to Dec and actuals pasting each month. Now when I refresh to get YTD Apr results for example I need to select Apr manually in each pivot to change the YTD result Is there...

Hi Experts - Please give any formula I want to get the figures in row 3 for each month based on selection of month in cell A1 as per the given example below, in Mar and Apr figures are showing zero Suppose if I select Mar in A1 only Apr should show zero rest of the months should take sum from...

Hi all, I would like to use a VBA code so that to clear the numbers’ decimals which contains space before comma e.g. 26 ,7 should be 26 Therefore that, the code should run through col. “C4” : “O” and rows down. Please see below an extract of original data and the expected result. Thank you...

Fairly experienced user of Excel but not really used anything more than a basic column/line graph for using two columns of data. I now have three columns of data and i feel like, with experience, it may be possible to work out a way to show the data in a useful manner - Though i haven't got a...

Hello there! Can you guys please help me with my problem. i know this is very easy but to be like novice in excel, I don't know how to formulate below. Please help. Replies is very much appreciated. Result : Sum the quantity based on Type, month and destination. Thank you in advance...

<colgroup><col span="24"><col><col><col><col></colgroup><tbody> I need to some help to sum the coloums from month to calulcate the Year to date, the problem is I have two type of columnes I need to sum </tbody> <colgroup><col...

Hello, What code can I use to create a folder - say 2018 (ask me what year I want) in that folder, automatically create subfolders with months of the year, and in each subfolder with the months of the year, create one file with the sheet names of the days. The name of the days can be 1, 2, 3...

Hi guys Love Mr Excel and usually I can figure out what I need but am going round in circles here, so help would be much appreciated. In my workbook I have a sheet called "Summary" where I am picking up information for each month. The names of the months are in this sheet in cells B1 to M1...

Hello, I have a table that looks like this (It goes all the way to December); <TBODY> Employee # Jan Feb Mar Apr May Jun Total 123 4 -5 6 2 -5 -5 7 456 -5 -5 6 4 -5 -5 0 </TBODY> If the current month is Apr (based off of TODAY() or some other cell) then I need to total Jan through Apr...

Hi Guys, Hope you can help! If you guys could help me with this I would be hugely grateful as this would save me sooo much time every month. Basically, I want to count the number of times 1 appears in 3 or more consecutive cells. Each cell only contains a 1 or 0. <tbody> Name Apr 1st Apr...

I want to prepare a prepaid expense tracker in excel. But get stuck at certain places. I have an Invoice for goods/ services for $120000/- for the period 15 April 2017 to 14 April 2018. My financial year is from 1st April 17 to 31 March 2018 I have received this invoice on 25 Jun 2017 and...

Whilst there are a number of similar examples on here, none quite hit the nail for my problem. Each month I am required to compare a course catalogue, identifying any new courses that have been added and any that have been deleted. The worksheet is exported from a SharePoint site into Excel...

I'm thinking this might have to be an array of some sort, but here goes nothing. I have a tab that pulls 2 different codes, TA and TZ. Each tab uses EDIPI (individual unique identifier). I want to match in 4 separate columns the following; TA Code, TA Code Date, TZ Code, TZ Code Date I created...

Hi Excel Gurus. I have 36 cells to update and each cell has formulas that points to a sheet, which will need to point to a new sheet. Here is one of the cell formulas: =COUNTIFS('Apr 15 - 21'!$D:$D,Summary!$K$12,'Apr 15 - 21'!$C:$C,Summary!$K$13,'Apr 15 - 21'!$E:$E,Summary!C2)+COUNTIFS('Apr...