cut data

  1. N

    VBA Excel - Keep only first set of characters in input

    Hey guys, I'm very new to vba, so I might be asking a stupid or obvious quesitons. However any help would be greatly appreciated. The task assigned to me is to format the data dump from a program to match excel entry format. I'm trying to keep only the first 10 characters in each entry...
  2. H

    Cut and paste whole rows into the right sheet depending on whether the row contains a particular word in any column

    Hello experts, I’m new to Excel, but I’ve grasped the concept of basic macros in VB. I’m now trying to create a macro that cuts and pastes whole rows into a different sheet depending on whether they have a particular word in any column. This is a little beyond my expertise, and I would be very...
  3. R

    select row if cell in column h is NOT blank

    I'm trying to come up with a marco solution that will select rows if the cell in column H is NOT BLANK. From there I think it will be rather easy to cut these rows and paste them in another workbook (that's filename does not change) at the end of the worksheet (in the first row that is...
  4. K

    How to...open a workbook and cut data selected by column title

    Hi folks, I work in health analysis and i am working on analysis of waiting lists. I have built an analysis sheet where the relevant data can be pasted, what i now need to do is to work out an easy way to strip the data from another sheet. This is essential as the tool will be make...

Watch MrExcel Video

This Week's Hot Topics

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
Top