ect

  1. D

    Copy formula

    I have a simple formula starting in column AD6-AQ6 in AD6 i have =aa06 AE6 =aa07 AF6 =aa08 ect it stops in cell AQ6 then drops down to AD7 over to AQ7 then down to AD8-AQ8 when i copy cell AD6 and choose the rest of the cells (ae6-aq320) the formula changes from AA to AB how can i keep it all...
  2. D

    IF help

    I have a formula =IF(A6="","",B5) when i copy and paste it it changes the B5 to b6 b7 b8 ect how can i keep it b5?
  3. D

    how to sum two cells from different rows in filtered data

    Hi Guys, I have a formula adding (for example) a1+ b2, a2+b3, a3 +b4 ect ect. A B 1 3 7 2 10 14 3 5 11 4 13 2 5 4 6 if I filter column A in the above example to cells less than "10' the example would look like this: A B 1 3 7 3...
  4. I

    How to do Now + 1 second for range

    Hey guys, if I want to Increment the Range that I have setup below for Now + 1second and then Now+2s.. ect ect.. How do I do that? I tried Now + TIME(0,0,1).. and it gave a mismatch error. Sub Fixer() Worksheets("Default").Activate Dim lRow As Long lRow = Cells(Rows.Count, 3).End(xlUp).Row...
  5. S

    Adding rows with certain values in cell.

    I'm trying to figure out how to add rows to Range (I:O) if an certain number is present above it. Example if number 2 then add 1 row underneath it, if number 3 and 2 rows, ect, ect. This is a line of travel for driving and the numbers I am looking at is stops needed on that street. I have been...
  6. J

    Named Ranges do not Sort

    So Oh Holy ____! I wish i would have known this 75 hours ago when i started making this beast of workbook I have a list of 75 names in Column A and for each name there is a named range for that row <tbody> A B C D E F G 1 Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 2 John 10 12 9 13 15 7 3 James 6 5 7...
  7. R

    alphanumeric

    I am tring to delete alphanumerics that are < or > a given amount in a columb. An example of the values i am going workingwith are: (1 letter/ 4 numbers/2 letters) s1001pg, s1022pl, s1042hd, ect. I can not figure out how to delete anything > then ex: s1022pl
  8. W

    Macro to unhide a row based on a value in previous row

    I have several lines hidden but if there is a value >0 in B7 I need the Macro to unhide row 8. then if a value is in B8 I need it to unhide row 9 ect. can someone please help? Thank you for your time.
  9. AndrewKent

    VBA to rename a folder (not file)

    Hi all, I have a folder with multiple sub folders that are all "# Jan", "# Feb" ect. and rather than change these manually I am looking to write a VBA script that will loop through each sub folder and rename them to "01 Jan", "02 Feb" ect. Any advice? Andy

Some videos you may like

This Week's Hot Topics

Top