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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top