macro - cut/paste

  1. C

    Copying data from an an excel file at sharepoint to a local workbook report

    Hi, Lately, I've been studying basic macros through the "record macro". However, I'm having difficulties in this one. We do have sharepoint site wherein u can export the data into excel. Those data are used to update my report. So, to save time. I would like to create a refresh button wherein...
  2. N

    Variable Replace

    I have a simple macro I'm having difficulty with. I'm trying to complete a copy and replace using text from a row. For example, in the code below, the replacement is "BC", which is fine if that's the heading, but if the heading changes to "BD" I need the replacement to be "BD", but I can only...
  3. G

    Help - macro needed to iterate and copy

    Hello Everyone :) Thanks for taking the time to view this post. I am familiar with macros but the language is sometimes confusing to me sometimes and I can get overwhelmed. I have a raw data set that includes Categories and SubCategories. *************************************** Here is an...
  4. L

    Excel Challenge: Macro based on cells background color - cut/paste and copy down

    Hi awesome Mr. Excel community! I am currently trying to create a rather complicated macro, and as you might have guessed by my user name, I am a bit lost right now. This is how my data is currently shaped: I have one column which contains the data of owners (turquoise background...
  5. C

    Pasting Formula's While Recording Macros

    I would like to know the easiest way to paste a formula while recording a macro - I have tried referencing the formula from another cell and pasting it in that way and it does not work. Also tried pasting from text file which does not work either. I've tried various methods from other threads...
  6. T

    Macro for If/Then Cut/Paste (without VBA code)

    Need assistance on creating macro to check cell content, IF it equals cell above THEN cut a range of cells in that row and paste into row above and to the right. Can this be done WITHOUT VBA code usage. I'm just a beginner macro user and so far have only used "point and shoot" macros,... no...

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