macro - cut/paste

  1. B

    VBA - How do I cut and paste a row to another worksheet when 2 cells both say Yes

    Hello, I am very new to using VBA and don't really understand much at the minute. I am trying to get it where when the word "Yes" is selected in both drop down boxes in columns V & W, that row is then cut and pasted into the worksheet "Delivered". I then obviously want it to paste to the next...
  2. W

    Copy cell to text box

    I'm sorry in advance if the answer is painfully obvious, but I am not very knowledgeable when it comes to macros. I am attempting to copy the contents of cell "C2" and paste it a line above the first line in "textbox2" or a line below the last line in "Textbox 2" while keeping the text that is...
  3. M

    Automatically move a row to another sheet based on cell value

    Hi there. Complete VBA and Macro novice here and I have trawled the internet trying to find a solution. I have a basic spreadsheet with 2 sheets, titled 'Active' and 'Complete'. In Sheet 1 (Active) I have data in columns A - I. Column I shows a status as either Active or Complete. I want...
  4. M

    Copy and Paste a Range of Cells to another sheet based on a Cellref and then delete the row

    I currently have multiple sheets for storing records of payments (things to be Pay and CantPay). I am trying to write a macro that will copy and paste Cells A:M on every row where column T = "Resolved" on the CantPay sheet (where the next empty row is the next row where "a" & row-number = blank)...
  5. P

    Macro for copy paste alternate rows

    Hello, I have row of data in many columns. I am looking to copy values from alternate columns of this row and paste in next row. Is there any macro written to do this? Thanks!
  6. S

    Move Data across worksheets based on cell input

    Hi, Can some excel genius help me out? I have multiple worksheets, lets say Sheet1 to Sheet 10 Depending on the Value in Column A, the whole row should be moved to the first empty row in the respective sheet. E.g: Value A --> Sheet 1 Value B --> Sheet 2 Value C --> Sheet 3 ….. However...
  7. E

    How to cut and paste to new column based on data in another column

    Hello, I saw this post by DK340; I need a macro that will loops through each value in column (K:K) and if the value, for example K1, is equal to "Credit Card", it needs to find the value in column B of the same row (in this example B1) and copies this value and then pastes this into cell A19...
  8. E

    Moving Cells from rows to column

    Hi, I'm looking for a code/macro to modify Data1 in such a way so that it resembles the final result as shown in Data3 below: Data1: <colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="6" style="text-align: center;"></colgroup><tbody> A B C D E F G H...
  9. F

    how to run a macro on a group of files and merge results in a masterfile?

    hey, I have a macro that creates a diagram and copies it to another file.. my code looks like this one: 'create diagram: ActiveSheet.Shapes.AddChart2(227, xlLine).Select ActiveChart.SetSourceData Source:=Range( _ "'Tabelle1'!$F$3:$F$722")...
  10. R

    Drop Box Macro Trigger

    I have a workbook that has a running master list of job candidates. In the master list there are columns such as candidate, recruiter, location, and other general information. One of the columns contains status information such as "offer extended", "offer accepted", "reneged", "declined", etc...
  11. C

    VBA ammendment to code. Column Heading Changes for different Workbooks

    <tbody> down votefavorite I hope you can help. I have a some code below which works fine. What it does is opens up a dialog box allows a user to select an excel file, once this file is selected. The code looks through the column headings find the Text "CountryCode" then cuts this column puts...
  12. M

    Macro to seperate tables based on column b

    Hi All, I have a table from columns A to K with no specific number of rows as this can vary. Row 1 is the header of the table. In column B, row 2, I have a name and the cells under are blank up to the next name and so on. I would like to seperate the table based on the intervals in column b...
  13. B

    Copy & Paste Range Using VBA Macro

    Hi Guys, I was wondering if anyone can help me as I dont know if this is possible. I was wondering if anyone knows can use VBA to : 1. Copies values from Sheet 1 A1,A2,A3,B1,B2,B3,C1,C2,C3 into E11:E14 2. Then Copies this range E11:E14 into Sheet 2 A1:L1000 3. But each time it did copy...
  14. T

    Macro to search entire worksheet using keyword from another sheet

    Hi all, I really new to macros and I'd like to ask for assistance in using macro in Excel. I'l like to be able to search all the columns of a worksheet using keywords from a column from another sheet. If it gets a hit from the list it would move the whole row to a new worksheet so that...
  15. A

    Macro to Paste beside a certain date

    Hi All, I have two sheets, Weekly Sales and Yearly Sales. Column A on Weekly Sales has the 7 days of the week running from cells A10:A16, On the yearly sales the dates run from cell A3:A368. The idea is that the weekly sheet is populated and then a macro copies all data from the weekly sheet...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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