Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    20

    modify data based on range

    i want a macro that loops from column K in sheet I'll call "ABC" and checks the values against a data range called "filter" (which is in another sheet called "filter criteria")

    if it finds a row...
  2. Replies
    12
    Views
    122

    Re: making excel recognize it's 20XX not 19XX

    thanks for the rpely.

    ya i looked into this, but isn't this PC dependent? if my colleague opens this workbook on her PC, it would stills how 12/30/1945 for instance, right?

    NVM: Rick's post...
  3. Replies
    12
    Views
    122

    Re: making excel recognize it's 20XX not 19XX

    does the trick

    jsut fyi....it's no big deal, but the only way I can clear the dates is by highlight both of them then pressing delete (or I delete the entire row).

    if i just enter a date in...
  4. Replies
    12
    Views
    122

    Re: making excel recognize it's 20XX not 19XX

    thanks let me give this a try
  5. Replies
    12
    Views
    122

    Re: making excel recognize it's 20XX not 19XX

    yes exactly ..and
    only two columns ...f and g in sheets repo, retail , MBs abs prov , bill , and ba only
  6. Re: if date falls on weekend, roll to Monday

    is there a macro that will do this for me? actually, ideally, i want to keep the year number displayed as two digits even after the conversion.
  7. Replies
    12
    Views
    122

    Re: making excel recognize it's 20XX not 19XX

    date format is M/DD/YY
  8. Replies
    12
    Views
    122

    Re: making excel recognize it's 20XX not 19XX

    looks like it needs to a formula of some sort....so im seeking a macro to do that instead
  9. Re: if date falls on weekend, roll to Monday

    yes apolioguies guys
  10. Replies
    12
    Views
    122

    making excel recognize it's 20XX not 19XX

    is there a simple way to do this so that it's not PC dependent ? change the settings within the workbook? rather not use formulas
  11. Re: if date falls on weekend, roll to Monday

    for a date of 7/29/33, i'm getting 7/31/33, however 7/29 is a friday, not saturday or sunday. please advise.
  12. if date falls on weekend, roll to Monday

    eg if the maturity date was october 13, i'd want the maturity date to now be october 14 (monday).
  13. Replies
    11
    Views
    259

    Re: why giving me N/A?

    this works thanks
  14. Replies
    11
    Views
    259

    Re: why giving me N/A?

    ya not working for me...


    yah, i know N/A isn't zero, which is why i thought the original formula would work.

    in my original formula...i thought excel would be smart enough to decide that if...
  15. Replies
    11
    Views
    259

    Re: why giving me N/A?

    it's not text n/a but excels #n/a error
  16. Replies
    11
    Views
    259

    why giving me N/A?

    =IF(OR(G8=0,AB8>0),0,AB8)

    g8 is N/a....AB8 is 0.....shouldnt the if statement produce 0? it's giving me N/A
  17. Replies
    1
    Views
    50

    Re: change default font color

    i just selected all sheets (grouped)...then clicked the top left corner to select all cells...then change the font color to black

    seemed to do have done the trick...even when creating a new...
  18. Replies
    1
    Views
    50

    change default font color

    ok, so i redesigned a template, but what i shoul;d have done is use a new workbook because every time i type something in the template, the font color is red. is there a way to change it so that...
  19. Replies
    4
    Views
    101

    Re: delete all duplicates except one

    what is this scripting.dictionary? i semi understand your code
  20. Replies
    4
    Views
    101

    Re: delete all duplicates except one

    youre always so helpful...and the code worked! vba genius!
  21. Replies
    4
    Views
    101

    delete all duplicates except one

    im trying to delete all duplicates based on an ID in column F, except one (it doesn't matter which one I keep...ie it could be the first one, could be the last duplicate).

    trying to do this with a...
  22. Replies
    3
    Views
    82

    Re: pivot filter based on range

    it didn't work initially because my filter is a "report filteR" and not a "row label." however, i simply made it a "row label" isntead and the code works fine. i assume it didn't work initially...
  23. Replies
    3
    Views
    82

    pivot filter based on range

    right now i have this...




    With pf
    For Each pi In pf.PivotItems
    If pi.Name = "811" or pi.name = "911" Then
    pi.Visible = True
    Else
  24. Replies
    2
    Views
    104

    Re: advanced filter than copy and paste

    something like this..



    finalrow = cells(rows.count,"A").end(xlup).row

    range("a1:z" & finalrow).advancedfilter xlfilterinplace, criterarange:=range("caput_filter")
  25. Replies
    2
    Views
    104

    advanced filter than copy and paste

    ok i ran into something odd....so far when i do an advnaced filter via vba and then copy and pasted the filtered data....by default the code would only copy the visible cells even though i have the...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4