Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: if sheet name is taken, add number at the end

    Okay Everyone, I was able to get it to work. Sorry for my extreme newbyness, the little things always mess me up!

    Thanks everyone who replied and helped me on here, I couldn't have done it without...
  2. Re: if sheet name is taken, add number at the end

    Yes that is working fine, it's creating both sheets for me with the correct number at the end, even if I keep doing it over and over

    The line I get the error on is:...
  3. Re: if sheet name is taken, add number at the end

    Having the same problem as with the previous one, i get an error that references:
    Sheets.Add(After:=Sheets(Sheets.Count)).Name = my_new_sheet_name
    Any ideas?
  4. Re: if sheet name is taken, add number at the end

    I got a "Runtime error '1004': Applicatoin-defined or object-defined error

    I tried to update the name to sName, but it's not working for me. Tried some different iterations, but i couldn't figure...
  5. if sheet name is taken, add number at the end

    Hey everyone,

    I have a macro that creates a data table on one sheet and a pivot table on another sheet, and the problem I'm having is that i can only run the macro once and then I have to change...
  6. Replies
    6
    Views
    226

    Re: Need help with AVERAGEIF formula

    As far as I can tell from research, you cannot averageif in a non-contiguous range. Meaning they all have to be next to each other. You can average in a non-contiguous range, but not with criteria....
  7. Replies
    6
    Views
    226

    Re: Need help with AVERAGEIF formula

    Where is your range of cells to average?
    And with so many criteria, you have to use =AverageIfs() I believe
    Which will need your average range, and then criteria range, criteria, criteria 2 range,...
  8. Re: Excel File Size Question - Why is my file 36Mb with minimal Data in it? - Excel 2016

    Sorry I'm a noob, but once I made a macro that kept making my file too big.
    The reason was it was copying everything to the last row of the sheet somewhere, instead of a defined range.

    One thing...
  9. Replies
    14
    Views
    458

    Re: Name of PDF From Cell Value

    Don't worry about it buddy, It is my pleasure to help you.

    Have a good day
  10. Replies
    14
    Views
    458

    Re: Name of PDF From Cell Value

    You could create a folder for every customer code
    and then add a variable like
    CustCode = [H6]

    and then update your folder path to

    CurrentPath = "C:\Users\xj\Desktop\Invoices\" & CustCode &...
  11. Replies
    14
    Views
    458

    Re: Name of PDF From Cell Value

    Change From:
    wFile = [H6] & [H3] & Format(Now(), "mm-dd-yyyy HH-MM-SS") & ".pdf" 'must be hypen

    To:
    wFile = [H6] & " " & [H3] & " " & Format(Now(), "mm-dd-yyyy HH-MM-SS") & ".pdf" 'must be...
  12. Replies
    11
    Views
    195

    Re: weekdaty Average IFs formula

    No problem :)
  13. Replies
    14
    Views
    458

    Re: Name of PDF From Cell Value

    I'm not sure I always have to mess around with paths to get them to work, you could try it like this

    Adding these in your code
    Dim wFile As String, DateTime As String
    DateTime = Format(Now,...
  14. Replies
    14
    Views
    458

    Re: Name of PDF From Cell Value

    It's possible to name the pdf based on a cell, you could include the time as well, to avoid having duplicate files overwritten or skipped

    I used something like this (where L5 is the Name of the...
  15. Replies
    11
    Views
    195

    Re: weekdaty Average IFs formula

    If you need to keep it the same you can use these 3 formulas and just drag them to the right
    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color:...
  16. Replies
    11
    Views
    195

    Re: weekdaty Average IFs formula

    Meaning can you set up your secondary table like this(Vertically instead of horizontal-transposed)? because then you can just use 1 formula and always drag it down and over, rather than having 3...
  17. Replies
    11
    Views
    195

    Re: weekdaty Average IFs formula

    what about the blanks?
    For instance C3? Should that be 0%? because the formula will skip including it in the average

    Also, would you be able to set it up like this? (it will make it one formula...
  18. Replies
    11
    Views
    195

    Re: weekdaty Average IFs formula

    So for John-1 you want to average all the numbers in column c if they have a 1 in column a?
  19. Re: Project Plan with successor and predecessor dates

    Hey there, I was having trouble understanding what exactly you are requesting. I'm not sure what predecessor date you are referring to. Can you explain it differrently and possibly show what you want...
  20. Replies
    2
    Views
    139

    Re: Excel Crashes

    does it also happen with smaller files?
    How many KB is your file?
  21. Replies
    2
    Views
    106

    Re: Percentage Question

    You could try something like this(but with your ranges filled in)
    =SUM(COUNTIF(INDIRECT({"A23:A34","A3"}),"a"))/SUM(COUNTIF(INDIRECT({"A23:A34","A3"}),"<>xxxxxxxxxxxx"))

    Not sure if the full...
  22. Re: Linked cells not keeping conditional formatting

    In cells P5:Q31 why don't you change the formula to
    =if(B5+C5+D5+E5+F5+G5+H5+I5+J5+K5+L5+M5+N5+O5=0,"--",B5+C5+D5+E5+F5+G5+H5+I5+J5+K5+L5+M5+N5+O5)
    or a simplified...
  23. Replies
    5
    Views
    144

    Re: Save Backup Workbook With Macro

    Thank you Xenou!
    That's really cool how the original file doesn't get saved and only the backup file will get the edited parts, that's how I was trying to set mine up, but couldn't figure it out....
  24. Replies
    5
    Views
    144

    Re: Save Backup Workbook With Macro

    Hey thanks a lot for helping me lrobbo, your code helped me find exactly how to do what I wanted!
  25. Replies
    5
    Views
    144

    Save Backup Workbook With Macro

    Hello there,

    I'm trying to find a macro that I can add to my quick access toolbar to be able to save the file as, with the current file name and the date and time added.
    to this path...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4