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
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
