redundancy

  1. C

    Please help clean up my convoluted VBA code. It seems very redundant and repetitive.

    This is some (poor) vba code I wrote in order to take multirow information and unpivot it for a table that will be used elsewhere. I know unpivoting can be done in power pivot or even just in excel, but in my situation, having a macro run this code would be a whole hell of a lot easier. Thank...
  2. E

    Clean up Code

    So I have this vba code, but it seems pretty redundant. I'm not that good at VBA yet, so could anyone could help me clean this up? Sub GetSheets() Dim Path As String 'FolderName gets directory of folder Dim FolderName As String With Application.FileDialog(msoFileDialogFolderPicker)...
  3. T

    Converting Horizontal Data to Vertical with Intentional Redundancies

    Hi everyone, I know there are some similar posts out there, but I’m terrible with understanding macros. Could someone tell me a macro for the following? Here’s an example data set: <tbody> A B C D E F G H 1 Date Status 2 ID First Last Service Group...

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