1. N

    Macro to Combine Data from Different Columns

    I have a large sales data report containing severalgroups of customers. I would like to automatically generate individual usagereports (separate files so not by tab) from this large file for each groupevery month and save them separately on a shared drive. I would like to also have each...
  2. R

    Excel Issue between dates (specific month)

    Hi Guys, I have an issue with a formula. I need an if between dates with in the middle August. Example: 12/06/2019 12/10/2019 If in the range there is august do something, otherwise something else. I have no idea how to write it. Thank you guys, Have a nice weekend.
  3. J

    VBA Compare 2 lists and isolate 2 types of differences

    Hi folks, I regularly have to compare 2 report lists (approx 10,000 rows on each report) that are nearly identical. However, there are always 3 types of differences (sorry my title says just 2 I couldn't edit it) throughout and I currently spend a lot of time finding/listing these differences...
  4. N

    How to Create Multiple Reports from One Sheet

    I have a large sales data report containing several groups of customers. I would like to automatically generate individual usagereports (separate files so not by tab) for each group every month and save themon a shared drive. I would like to alsohave each report automatically be customized...
  5. gheyman

    Access: Date in an unbound field on a form

    I want to add a field on my form that will act as a "Title". Actually I have 6 fields. In the first one, if todays date is in the month of September I want it to say "September" in the field. I would even be OK with the Month and Year (But not the day). In the next box if today is 9/17/2019...
  6. A

    Sum between rows

    Hi community, I want to know how can i calculate numbers between specific rows? if user selects January from data validation list i want excel to calculate numbers from January to august, if May than from May to August. btw user can select start and end date. so it can be from january to may...
  7. T

    Generating 2 rows on a different spreadsheet based on a value

    Hi All Our accounts software accepts bulk upload of journals from excel, the format is as below: <colgroup><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody> Batch Date Batch Description Batch Type Main Location Nat Dept Amount Description Journal Code 20/08/2019...
  8. JackDanIce

    Add vertical line to chart

    Hi, I have a graph based on a 3-column data table where x- axis is time (months, Jun 2019 to Dec 2020) Primary y-axis is account balance ($0 to $3.5m) Secondary y-axis is PnL (-$300k to $200k) August 2020 is first month PnL > $0 (Aug 2020 as the answer is calculated in a different cell) How...
  9. Z

    Vba Convert Date value from 8/7/19 to August 7, 2019

    Hello All, Here is my situation, i'm using excel vba on a spreadsheet. All the values of column K are in mm/dd/yy ie (8/7/19). Now i have made a macro that take information from this sheets and fills a few word documents. My problem is that they now want the documents to display the full...
  10. T

    Auto saving date

    In my spreadsheet in E1 is yesterday date in this style 31/07/2019 is there a way of adding to my macro a way to save as T/P5 August 2019/31.07.2019 Contact Finance
  11. D

    Countifs formula

    Is it possible to make this "Golf Course Count Table" (on the right) without the "Day" cheater column? and just get the info from the "Date" column? <tbody>#DAE7F5[/URL] "] AC AD AE AF AG AH AI AJ AK AL AM AN 3 #548235[/URL] "]Date #548235[/URL] "]Day #548235[/URL] "]Time #548235[/URL]...
  12. R

    Formula to update data each month

    Need a formula, or possibly a macro if necessary, to execute the following based on the current month: If the current month is January then if B1<E1 then D1=""; if B1>E1 then D1=E1-A1. Cell D2 would be if B1+B2<E1 then D2=""; if B1+B2>E1 then D2=E1-(B1+B2). Cell D3 would be if B1+B2+B3<E1 then...
  13. J

    How many times each month appears between dates

    Hello; I need a function (or 12) that tells me for each month how many times it appears between two dates. So let's say I have the dates 1.1.2019 and 31.7.2020. The output should be: January 2 February 2 March 2 April 2 May 2 June: 2 July: 2 August: 1 September: 1 October: 1 November : 1...
  14. R

    Excel transpose how to do.

    how can I transpose the info in EXCEL <colgroup><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody> FROM excel in tab 1 code product Jan feb Mar April May June July August Sept Oct Nov Dec 31010054 3 49471 45847 53911 50423 53134...
  15. A

    Formula for counting data per month

    Hi I am trying to get a formula to calculate the amount of Y's and N's for one month i.e. April 18 per project and my dates vary from the beginning and ending of the month. My data is below: <colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col...
  16. L

    Formula to find an amount within a dollar range

    I am in need of a formula that will allow me to flag if they have a balance within a +-$1.00 range: For instance- Month: Client: Account Balance: August Bob 10.01 August Lucy 11.27 August Sam 9.56 Sept Bob...
  17. R

    Sumif month is aug

    column b has a date, column e has the amount. I would like to know my total for August (data only has 2018 dates)
  18. P

    AutoFilter using a vba generated array

    Hello, I'm trying to automate some of the updating I do within an excel 2013 workbook. Each month, I refresh the rolling-6 month data for the past 3 years and add a new rolling-6 months of data. to do this, I manually filter and delete the respective periods. As an example, if I'm doing the...
  19. G

    Creating Categories Based on Order of Test Completion

    Hi all! I have what may be kind of a complex issue. I’m currently working with a data set and wondering whether there was a DAX formula that will create a flag that will place students in one of six categories based on the order in which they completed a test. Essentially I would like to...
  20. A

    Automated Autosum

    Hi I would like to seek some advice on how I can do the following. I have a macro(I use a do while loop to check and insert the extra row) that sorts out data in a certain format by inserting a line(row) in between 2 rows effectively separating the data set. After running my macro, I am...

Some videos you may like

This Week's Hot Topics