Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: VBA Copy & Paste Values of three specific sheets into new file, then save file with variable name

    need one more edit.
    there are a number of tabs that are colored black, that i would also need to be included as one of the tabs that gets carried over into the new file...

    are you able to do...
  2. Re: VBA Copy & Paste Values of three specific sheets into new file, then save file with variable name

    Hi Dante. Thanks again for the help.
    Sorry i didn't mention, the YYYY, MM, DD data will be referencing cell A1 in Tab1. (in that cell, i change the date every month, it currently reads "9/30/19"
  3. VBA Copy & Paste Values of three specific sheets into new file, then save file with variable name

    So File1 is a macro-enabled file. <br>

    It is named "S Form MMDDYY".<br>
    It is saved on a network drive in this path: "Reg/Reg Reporting YYYY/MM-YY/In House/Form S"<br>

    1. Copy Paste Values...
  4. Re: losing References in tables when change links

    still don't understand why I'm losing the references...even when I have the files I'm linking open...if I change the source to an identical file, with a different name....it takes forever to...
  5. Re: losing References in tables when change links

    only way i don't lose the references is if i have the files open and hit Save As and then change the file names, but that's not practical. i've never seen this problem before when changing links
  6. losing References in tables when change links

    I have two files that are linked to each other.
    File 1 contains formulas that links to the data in File 2. File 2 contains data in Tables and the formulas reflect these table names. These files are...
  7. Re: vba to add fields to pivot table, needs work

    not sure what that means?
  8. Re: vba to add fields to pivot table, needs work

    hi Dante,

    i am able to, maybe i should clarify...

    it's kinda working, but in an odd way...
    i'm able to press the buttons, and the fields will be added or be hidden, but the error will pop up...
  9. Re: vba to add fields to pivot table, needs work

    Hey Dante, I added another pivot table to the sheet, and when i use the buttons now, i'm getting this error:

    "Unable to set the Orientation property of the PivotField class"

    do you know why?
  10. Re: vba to add fields to pivot table, needs work

    wow, beautiful...thanks so much Dante.

    i noticed you code very cleanly, was wondering if you had any youtube videos to recommend?
  11. Re: vba to add fields to pivot table, needs work

    i have 3 pivot tables on my worksheet. is there a way i can get identify, by name, which pivot tables are affected when i press each button?
    or, is there a way i can indicate for the macro not to...
  12. Re: vba to add fields to pivot table, needs work

    oops...didnt see that post. sorry. let me try now
  13. Re: vba to add fields to pivot table, needs work

    can anyone help?
  14. vba to add fields to pivot table, needs work

    hi, i'm using the below code to add fields to my pivot table. it works great, but my problem is it only works for one pivot table on each page.

    can someone help me edit this so that if there are...
  15. VBA - Delete Rows based on Date criteria from second sheet and Paste in New Rows from third sheet

    i'm new to macros but I'm decent at understanding so have gotten a fair amount of simple stuff done recently. mostly off amending recorded macros.

    let me explain my file. i don't know how to add...
  16. IF formula comparing to numbers, and allowing for rounding

    I have three cells.

    A20: 38.2
    B20: 39.3
    C20: contains IF formula to tell me if A1=B1, then "Good", if not, then "Check"

    To clarify, columns A & B contain numbers with decimals, row 20 would...
  17. Re: want to see if a range doesn't contains any values other than this

    looks like it's working properly with this:


    =IF(COUNTIF('[Working Paper 083119.xlsx]Raw'!$G2:$G2222,"GT 1 YEAR")=COUNTA('[Working Paper 083119.xlsx]Raw'!$G2:$G2222),"no","yes")


    not really...
  18. Re: want to see if a range doesn't contains any values other than this

    when i click on evaluate formula, it shows me the countif is coming out to 756, but the counta shows as 757..the counta always comes up with one count more no matter how much i toy around with...
  19. Re: want to see if a range doesn't contains any values other than this

    i mean two files.

    only needs to look at maybe 2000 rows
  20. Re: want to see if a range doesn't contains any values other than this

    Hi Peter,

    thanks for helping.

    i tried the formula in a new workbook and it worked fine, it's not working in the file i actually need it in...not sure why. at first i thought it was cause i...
  21. Re: want to see if a range doesn't contains any values other than this

    hey Mike, thanks for the response.

    tried applying this formula, but not really sure how it's working....doesn't seem to accomplish what i was looking for.
    can you explain what your formula does?
  22. want to see if a range doesn't contains any values other than this

    hi,

    can't figure this out.

    I want to create a formula that will check all of column A, to see if it contains any values other than "October".

    So here's an example:

    Column A
    October
  23. Re: hyperlink using a cell with a date in it to complete the link url

    weird, i guess i didn't hit submit when i replied or something.

    anyway, sorry for the delay:

    1. Proper Excel date. it is custom format: "mmm yyyy"
    2. "08" signifies "mm". so the folder...
  24. hyperlink using a cell with a date in it to complete the link url

    hi,
    so i'd like to include a hyperlink in my file that will take you to a folder.

    the url is this "\shared folder\08-Aug\main folder"


    i have the date in cell A1 as "Aug 2019"

    is there a...
  25. Re: how to find if any unique values in two columns for each value in one column

    perfect. thanks Eric.

    In the case of column D, value "10". Since this doesn't exist in column B, is there a way I can have it return text other than "true"
Results 1 to 25 of 149
Page 1 of 6 1 2 3 4