hundreds

  1. J

    Preceding Zeroes

    Hi All: I have a weekly file that spits out numbers stored as text. It breaks out the hundreds and thousands amounts in different cells. In thousands cell:205 In hundreds cell:87 = 205,087 I currently use a concatenate formula to combine these two numbers and have to...
  2. Geo1126

    SUMIF Prior 3 months

    Greetings Excel Wizards. I'm trying to figure out how to make a SUMIF formula work based on the prior 3 months of the current month (excluding the current month). I have hundreds of parts with hundreds of shipments on my source data sheet (a shipping log). on a separate table I have a...
  3. D

    VBA or Formula to fill down sequentially every 15th row

    Hello everyone. I have spent 2 days trying to figure this one out but I feel like I'm at a dead end. I need a VBA or Formula to fill down sequentially from every 15th row. In this case I have a list of IP addresses I'm trying to generate and it looks like this: Column E Row 3 -...
  4. R

    Use VBA to parse out undesired strings from each cell in a column, then group column results

    Column C has cells containing dozens to hundreds of control identifiers, with a comma delimiter. Each control has two letters, a hyphen, and numerical identifier. I have VBA script that alphabetizes the contents of each cell, but I need to parse out all the controls in each cell that don't...
  5. M

    Convert Data Columns to Rows in Excel

    Hi I am trying to convert the following data from a column into a row Example <tbody> People Area 20 449 20 787 20 875 20 3555 20 3711 20 3760 20 4382 20 4558 20 4866 20 6344 20 6506 20 7218 21 621 21 723 21 2117 21 2229 21...
  6. P

    Renaming Multiple Tabs

    I have hundreds of tabs in an excel file all labeled with #1 and so on. How would I go about renaming all the tabs in one go to just getting them numbered such as 1, 2, 3, ...
  7. V

    Using VBA to AutFilter When Values Not Known

    Hello, I'm looking for a way to use VBA to AutoFilter a column for any value that is 90 or above. The column is column A, there are hundreds of values and there is no fore knowledge of which values will be present. How can this be done? Thanks
  8. U

    Anyway to get around "Cannot change part of a merged cell" in VBA?

    Hello, I made a macro to go through a long worksheet and clear out all the entries in certain cells, using the following example code <Code> Range("G297").Clear Range("R297").Clear Range("D298").Clear Range("L298").Clear Range("S298").Clear Range("D299").Clear </code> I did this for hundreds...
  9. J

    Resize Pictures At Once

    How can I resize hundreds of pictures to the same size at once?

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