jan

Hi, I have made a simple shift schedule. i can't figure out a good solution. When cell W22 = "FREE" and i'll type in the name of U22 anywhere in W4:W18 i must gett a message not possible because U22 is vrij (free) Also for the other names there must be a check. <colgroup><col...

<colgroup><col width="64" span="7" style="width:48pt"></colgroup><tbody> <tbody> Name jan feb march apr may june jack 1 2 3 4 5 6 sally 7 8 9 10 11 12 Girish 13 14 15 16 17 18 wen 19 20 21 22 23 24 </tbody> </tbody> <tbody> Name Jan to june sally...

<tbody> Jan Jan Jan Feb Feb Feb Mar Mar Mar Subscribers Leads Customers Subscribers Leads Customers Subscribers Leads Customers Homer 5 6 7 6 7 8 7 8 9 Lenny 6 7 8 7 8 9 8 9 10 Carl 7 8 9 8 9 10 9 10 11 Barney 3 2 1 4 3 2 2 1 0...

Good morning Gurus, I have a table. Across the top (X-axis) it has the 365 days of the year and on the left (y-axis) it has a series of names. Each cell has a letter that is updated each day. 01 Jan | 02 Jan | 03 Jan A B C What I want to do is have a separate...

I have a table with Months across the columns and warehouse and items down the rows. I am trying to automate an upload file and need it in a format with warehouse, item, Month and quantity...is there a way to do that with a pivot table? See simplified example below... Table looks like this...

Dear All, I need help with a VBA code for the following , please - Allocate an amount over time, and split the amount into monthly column, based on a period start and end dates & number of days in each month - e.g Start Date: 01/01/2019 – End Date 31/03/2019, & the spreadsheet has monthly...

Hi All, <colgroup><col width="58" span="3" style="width:43pt"> </colgroup><tbody> Date Month Value 1/1/2018 Jan 2 2/1/2018 Jan 4 3/1/2018 Jan 8 1/1/2018 Jan 1 2/1/2018 Jan 3 3/1/2018 Jan 5 1/1/2018 Jan 7...

Why is this line... ActiveSheet.Range("B3").Resize(3, 1).Value = Array("Jan", "Feb", "Mar") producing in Range B3:B5 >>>>> Jan Jan Jan Does the Transpose statement need to be considered? Tks in Advance!!

Hello, I have a pivot table with several items in rows and their respective values by month in columns (column labels). It's very simple but I have a sheet with several groups of pivot tables and different colors for each so I started using the same ones as in 2017. I just had to delete 2017...

hi, i would like to extract some data based on the date (Between dates) using userform (date start and date end) example data below SHEET1 <tbody> A B C D E DATE REF CODE AMT NAME 1 JAN 2, 2018 AAA 111 25.25 STEVE 2 JAN 7, 2018 ABC 123 654.00 JOHN 3 FEB 6, 2018 DFS 364 215.40 MICHAEL...

I've got a list of Projects with multiple unique month values. What I want to do is take Jan data and compare to the Feb data (same file layout, just different dates) to see if people are changing Feb data after it was entered in Jan. Did they change targets after they were already locked in...

Hi Experts! I have a project like this: <tbody> A B C D E F G H I J K L M N O P Q R S T 1 2 3 START DATE 1 JAN 18 4 END DATE 2 JAN 18...

This is probably a REALLY basic thing but I couldn't find anywhere with a solution which works... Is it possible to SUM all of the numbers in Column C Where Column B (On the same line) equals X. (Example Below) <tbody> Month Total Jan 2018 5 Jan 2018 4 Feb 2018 7 Feb 2018 4 Feb 2018...

Hey there, New to DAX so any help is appreciated. My goal is to understand how many customers cancel in a given sold date. Basically how many items did we sell in a given time period vs how many cancelled in that same period. What I'm trying to do is count the number of rows where [Cancel...

Dear All, how can I use a constant array to make this formula work? basically I need a count of the food that "aida" have between jan1 to jan 4. summing them is...

Hi, I have a formula here which works but is not so handy. I dont want for example create a new userform for every day in Januari as you can se that I have done here. Is there a way to create a code to do the same thing with only one userform and a shorter code? If Not...

I have 2 sheets with multiple tables, Sheet 1 got A1 for Jan. 1, then A7 for Jan. 2, A13 for Jan 3; On Sheet 2 I have same single table. What I wanted to have is, if I input the date Jan. 1 on Sheet2 then it will give me the table for Jan. 1 from Sheet1, if I change it to Jan. 2 then table for...

Dear I have a question to you. Im using SUMPRODUCT for some querry and its perfectli works if at criteria Im using onlu one paramiter for one comumn. But now I want to use two parameters for one of columns. Simple example below Month Turnover ……. Jan 1 Feb 2 March 3...

Hello i was wondering if i could get some help with a count if/vlookup forumula. Need to look at each direction, first looking at "north" direction in the month of "JAN" Then need to look at the "NUMBERS" sheet and see how many times does that number matches the one that is in the DATA Column...

Hey guys - I have an inputbox in my macro that will prompt a user to enter a 3 month character for 1 of 12 months: Jan, Feb, Mar, etc. If the user doesn't type a value or most importantly, incorrectly types the month character like Jam instead of Jan, I want an error handler that will notify...