Search:

Type: Posts; User: Joe4; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 1.35 seconds.

  1. Re: Copy one whole worksheet into another whole worksheet taking too long

    Sounds like you found the proverbial straw that broke the camels back!

    I am guessing that you are probably using Excel like a database, which can be done, but is usually pretty inefficient to do...
  2. Replies
    3
    Views
    72

    Re: VBA Email notification

    Just note that they can get around this by disabling Macros/VBA when opening the workbook.

    What I have seen some people do is hide and protect the sheet so that no data is shown, by default, and...
  3. Re: Copy one whole worksheet into another whole worksheet taking too long

    So, that is roughly 25000 calculations, times 2 (2 sheets), so 50000 calculations.
    Are there are any other sheets or calculations in this workbook?
    How about any VBA code?
    Or links or hyperlinks...
  4. Re: VBA loop within a loop, to identify identical values

    Assuming that your data is in columns A and B, the header is in row 1, so the data starts in row 2, and "Mark" is in column C, put this in column C and copy down:
    ...
  5. Re: Copy one whole worksheet into another whole worksheet taking too long

    How many formulas are we talking about?
    What kind of formulas are they?
  6. Re: Copy one whole worksheet into another whole worksheet taking too long

    What if you temporarily turn off screen updating and calculations while copying, i.e.

    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual

    Sheets("Sheet1").Select...
  7. Replies
    1
    Views
    38

    Re: Count data between dates

    Take a look at using the COUNTIFS formula.
    See: https://exceljet.net/formula/count-cells-between-dates
  8. Re: Combine/Join 2 tables and get an output in 3rd table

    You are welcome.
  9. Re: Sumifs / sumproduct that contains multiple columns

    Welcome to the Board!

    If your data starts in row 2, place this formula in cell G2 and copy down to G5:

    =IF(A2="Red",B2,0)+IF(C2="Red",D2,0)+IF(E2="Red",F2,0)
  10. Replies
    3
    Views
    81

    Re: Clear Columns from "F" to the Very End

    You can use the reference number of the columns ("A"=1,"B"=2,"C"=3,...) to do it like this:

    Range(Columns(6), Columns(Columns.Count)).Clear
    Note that it is not necessary to select the columns...
  11. Replies
    5
    Views
    605

    Re: Help with access query expressions

    You are welcome.
  12. Replies
    1
    Views
    241

    Re: Database as weekly reminder

    Cross-posted here: https://www.accessforums.net/showthread.php?t=78813

    While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in...
  13. Re: Formula to convert currency cost into a percentage

    You are welcome.
  14. Replies
    16
    Views
    721

    Re: Updating Linked Tables to Back End Problem

    See here: https://stackoverflow.com/questions/15473263/update-an-access-linked-table-to-use-a-unc-path
  15. Re: Formula to convert currency cost into a percentage

    What custom format are you using, exactly?
    What does it show in those cells if you change the format to General?
  16. Re: Autofill goes past Last Row, Last row identifies correct Row

    You are welcome. Glad I was able to help!
    :)
  17. Re: Formula to convert currency cost into a percentage

    In order to do a percentage of something, you need two values (the amount you want the percentage from, and the total amount).
    So, if you wanted the percentage of the value in cell A10 and the total...
  18. Re: Autofill goes past Last Row, Last row identifies correct Row

    Welcome to the Board!

    If you are tacking on the row number manually, you need to get rid of the current row number, i.e.

    :=Range("L2:U" & LR)
    instead of:

    :=Range("L2:U2" & LR)
    Otherwise,...
  19. Replies
    1
    Views
    38

    Re: YTD Data from Monthly Input

    Duplicate: https://www.mrexcel.com/forum/excel-questions/1114437-tyd-data-monthly-data-input.html

    Please do not post the same question multiple times. All clarifications, follow-ups, and bumps...
  20. Thread: Date Difference

    by Joe4
    Replies
    8
    Views
    513

    Re: Date Difference

    You are welcome.
  21. Replies
    4
    Views
    97

    Re: Vlookup on multiple columns

    You are welcome.

    If you have a lot of data, and find that it runs slow sometimes, you may be able to speed it up by using specific range references, instead of entire column references, i.e.
    ...
  22. Thread: Date Difference

    by Joe4
    Replies
    8
    Views
    513

    Re: Date Difference

    If I am understanding you correctly, you should be able to do this in a calculated field in a query, i.e.

    DaysPassed: Date() - [DateField]
    Where DateField is the name of your date field.
    If the...
  23. Re: Run Time Error '13': Type Mismatch on time calculation

    "TimeCheckDelay" seems to be a variable of sorts, but I don't see it being defined or set anywhere.
    Is there other code that defines/sets this?
  24. Replies
    4
    Views
    97

    Re: Vlookup on multiple columns

    Here is one way.

    Let's say that your data of studetns and courses is in the range A1:B4.
    And let's say that they new table with formulas you are trying to build is in F1:H3
    Then, place this...
  25. Re: Excel - Summing Up Totals based on a rolling dates

    No, you cannot upload/attach file, but you can post images using the tools mentioned here: https://www.mrexcel.com/forum/about-board/508133-attachments.html

    Note that depending on how your data is...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4