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


    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