Help Cutting/Pasting Rows within Same Sheet

mkyp27

New Member
Joined
May 20, 2014
Messages
3
Hi,

Should be a pretty simple code, but I am not very experienced with VBA.

I have a list of stock holdings with various data (cost, ticker, etc.) in B1:K50, which is sorted alphabetically. I want them to stay alphabetical based on Column b (stock name), but I would like to cut and paste the row labeled "USD" to the bottom of the list. I was trying to use VBA to find the row with "USD" in column b, cut this row and paste it after the last stock on the list (aka the first empty row in the same sheet), with the now blank row being deleted. The number of stocks is likely to change so instead of selecting a specific row to target, it needs to find this based on the text "USD" in Column B.

Is there a quick way to do this? I am trying to incorporate this into a macro I have already built that cleans up the data and adds a few formulas I need, but I am unsure how to do so. I tried recording a macro, but I was unable to figure out how to alter it to make it work.

Any help is greatly appreciated. Thanks
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Forum statistics

Threads
1,226,735
Messages
6,192,733
Members
453,752
Latest member
Austin2222

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