march

Hi I am Preethi, Please help me in VB Script I have large excel file which I have to mail the particular line items to customers. (for example) <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Code...

Hi everyone, first time posting, but I can't seem to find the solution. When I encode 11/3/19 in a cell, when formatted it would show March 11, 2019. I would like it show as November 3, 2019 instead. Is there away to change this. Thank you very much.

Hello, I started learning VBA yesterday,.. please bear with me if this is v basic,.... I have a set of data in a worksheet that will vary in size. i would like to copy the value in cell P2 (10.10.2019) down to the bottom of the column,.. which is currently 4000 rows long. <tbody> Column P...

I have this setup: ``` date cost 22 march 2018 100 10 january 2018 20 15 march 2019 150 12 january 2019 133 ``` I don't know in advance, which cost, dates or how many rows I'll have. Need a measure that...

Hi all I'm an absolute excel newbie, so please forgive me for my lack of knowledge... I have values for 2018 (Jan, Feb and March) and 2019 (Jan, Feb and March). I've created a bar chart but it is displaying Months between March 2018 and 2019 which I don't want. What I'd ideally like is to have...

Hi All I feel this is probably something very easy that I am missing. When I create a pivot table with my data I cant seem to group any of the data columns. As a result,if I want to show the complaints that were upheld in March 2019 I have to look in the filter and manually select each day in...

Hi all, I have a 6 column running Table (called "CS" - see table below). Each month my macro takes current data from a separate 5 column table and pastes it to the bottom of the CS table. After this procedure, there is always the expected blank 1st column in the CS (which is the "File...

Hi All, I am working with a database that needs the rolling total of the last 3 months. For example, let say we are in June. One column will Sum the total of Mar, April, May. Another column for Feb, March, April. And the last one being Jan, Feb, March. I have figured out how to calculate the...

Hello there, i have kind of a perplexing question that I'm not sure which way to go about it. To set the stage: i have data which has calculated mean time between failures for our shop at work, and my boss wants me to create something that provides a percentage of the good trends over the bad...

Dear Excel Community, Currently I have a tab that references data from a pivot table via getpivotdata function. How can I modify the getpivotdata formula in a way that it will give me the grand total value up to a certain month. For example, I would like the grand total from the average price...

Hi, I am working on an Index Match function whereby I input a date in one field and a text in another field and it should return the total sales for a product for that particular month. This should bring back a value if the conditions are met. I need to have multiple criteria because my formula...

Hi - Is there a way to say look in A10 and if the word "March" appears, put "March" in B10? Thanks!

Hello All - Greetings from Las Vegas, NV, I am new on this message board and am desperately in need of some VBA/Macro Help. Over the last few months, I have been manually saving 30+ PDFs and then emailing them 30 different times through outlook with a different distribution list for each PDF...

Hi I have workbooks in which there a number of worksheets. Each time I save a new file from the previous one I need to change the names on each worksheet tab. Each name is different. Some are days of the month, for instance. In that example I have 31 tabs that need to be renamed 01 March...

Good morning all. I am not all that savvy with excel and am attempting to create a form that will auto fill from another spreadsheet when given a few criteria. On the column header is dates from the first of a month to the end. On the Y axis are names. In the data range are letters denoting...

Hello folks, I am new to Excel and new to this forum. I am using Excel 2010. I am trying to create a court filing deadline calculator that calculates two different kinds of deadlines. One for business days and one for what I call calendar days. I have been able to figure out how to calculate...

Hi everyone, Need help with a formula. In cell range A1:A365 I have the numbers 1 through 365 In cell range B1:B365 I have the dates. Most recent date in cell B1 March 1, 2019 In cell B2 I have the same date March 1, 2019 Cell B3 = February 28, 2019 Cell B4 = February 28, 2019 etc. etc...

I would like all duplicate files on Col A on sheet3 ending in .xls to be deleted march sales.xls march sales.xlsm sept sales.xls I only want march sales.xls to be deleted Your assistance in this regard is most appreciated

Hi all, I have an Excel file for the month end where I compare the data from this month to last year, for the actual month and year-to-date. When I open an earlier Excel file, certain links don't show the correct value anymore, I have to reopen the source file so that the correct value shows up...

I have an issue on hand whereby the format of the data is not usable for pivot. Current format <tbody> Header 1 Header 2 Header 3 Header 4 Header 5 March 2018 Quantity March 2018 Value April 2018 Quantity April 2018 Value May 2018 Quantity May 2018 Value June 2018 Quantity June 2018 Value July...