@jlgwhiz

  1. K

    Split text to multiple columns using VBA code

    Hi All, I would like to create VBA code for split a long text (items) into multiple columns as below picture (How to split the items) by using column button (Split Text) I used the code below but it didn't work while I was using it. Sub splitText() 'splits Text active cell using ALT+10...
  2. V

    VBA Macro to paste values from a list in multiple separate worksheets

    I have the an "Input" spreadsheet with a list of unique values. Then I have a series of worksheets that are identical templates. I want to past each unique value from the list on the "Input" sheet into the same cell within each of he separate worksheet templates. Ideally the macro / code...
    • Vlookup_Er_No
    • Thread
    • @jlgwhiz automate copy and paste loop macro multiple worksheets rename worksheet vba
    • Replies: 0
    • Forum: Excel Questions
  3. C

    VBA : Append New Data from one worksheet to another

    Hello, I was using JLGWhiz's code to append entries from a data source to to my target workbook. Currently, it looks from the bottom and removes the duplicates. How would I modify it to preserve the previous entries in the target workbook and add the new entries in order?. Dim sh1 As...
  4. M

    Copy the Workbook from userform i.e, load the workbook path and copy the output workbook path

    Hello All Hopefully one of you awesome excel experts can help... I have to create a userform with Commandbutton to navigate on (Get workbook path) selecting the "Abc" excel workbook, it should copy with all the sheets that are available in "Abc" workbook and paste that in different path as...

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