cut and paste

  1. M

    If value in column B = 1, then copy and paste content of Column A to another sheet.

    Hi all. I am little new to Excel coding and would really appreciate some help. I am writing an excel sheet for my students but getting stuck, essentially they will fill out a sheet scoring themselves from 1 to 5 in certain areas, Col A will have 50 skills, they will rate themselves 1 to 5 in...
  2. S

    Code to cut data and paste as values, then delete specific range of row when the cells in column D is blank

    Hi I am a new VBA learner. Need help for code, to cut data and paste as values, then delete specific range of row when the cells in column D is blank Eg. I have a quotation table in my sheet (=Quote!$A$10:$AL$265). I would like to first cut of (=Quote!$A$10:$K$260) and paste as value...
  3. K

    Extract/Move row based condition

    Hello Everyone, I have searched this forum and others for several days but can't find what I needed so I took a stab and trying to code myself and it was an epic fail.... I have two workbooks wb1 (has master data in it) and wb2 (storage data). Here's what I'm trying to do... -If column AA in...
  4. D

    I need help writing a Daily Average Formula

    Howdy, I have a problem that I can't figure out, and I'm hoping someone here can give me a hand. For the past several years I have been keeping a record of how far I walk/run/cycle each day via Excel. It has worked great for letting me see my average year by year. However, I have one Excel...
  5. T

    Shifting a selected range of cells to the right or left

    I have a spreadsheet that needs to shift a selected range of cells one column to the right or left using an "Advance" or "Delay" button. Here is the sequence of operation: 1. Activate a button 2. Select the cells beginning 2 spaces from the button's originating cell to 10 spaces from the...
  6. Roderick_E

    Easy Cut & Paste to duplicate sheet

    My company uses a lot of spreadsheets where there are 2 tabs; one for "active" and another for "completed". The user typically will cut and paste a completed row from the active sheet to the completed sheet. Both sheets have exact same headers. To automate this, I created code so that the user...
  7. D

    Find Text, Cut & Paste It In Another Column

    Hello, I'm using Excel 2013. I want to find a particular text, cut & paste it in a column of my choice within the same row. This text may be present in any column. I have gone as far as the code below which works fine. However, the code stops half way though there is more rows to be searched...
  8. Carlo22

    Cut and paste values only? to avoid copy>paste values> select initial cells>clear cells

    Hi, I'm looking for a way to easily move only values from one cell selection to another. The formating of both the source and the destination cells are to remain the same. So far I couldn't manage to find a solution in this forum or elsewhere. Does someone here have a solution? Thanks!
  9. M

    Text not going in to cell correctly

    This is probably really easily soluble as it seems a very stupid question. When I cut and paste text into some cells the text goes into the cell, fits in at the width that I've already selected for the cell and expands the cell downwards so it all fits. However sometimes, the text appears on one...
  10. S

    Macro: Coding Macro to Select, Cut and Paste Row from one sheet to another (Excel 2010)

    Hello! I am needing to code a macro that can select a row of information, cut it and then paste it into a different (already labeled) sheet. To elaborate I would like to select cut the information from "Sheet 1" and then paste it into "Sheet 2" in an identical format without pasting over any...
  11. A

    Search ".xls" files and then CUT and PASTE to new location

    I have a folder with many subfolders and I want to search ".xls" files from these subfolders and then cut and paste them to new location. There is a code available over interned for searching files in folder but apparently it does not work in newer versions of Excel.
  12. A

    Copy and Paste work but not Cut and Paste in vba

    Hi, I am new to vba programming. I have written the following codes. The codes work for Copy and paste, but when I change to Cut and paste, it won't work. I am trying to cut a row on one spreadsheet, and paste the row in another spreadsheet. I can't figure this out. Can someone help me? Thanks...
  13. K

    Cut Cells Marked "Closed" and Paste to New Sheet

    1 Workbook 2 Spreadsheets - "Complete Backlog" & "Closed Jobs" If Column K in "Complete Backlog" says "Closed" then cut that row and paste it into the next available row of "Closed Jobs". I have this code below but there is an error with it. It currently cuts all of the items marked closed but...
  14. K

    Macro to Cut Closed items (rows) from One Sheet and Paste into Another

    I'm using 2003 (company computer :( ). I need the macros to manipulate cells not entire rows So here's the algorithm: If a cell in Column K of the "Complete Backlog" spreadhseet is equal to "Closed" then cut cells A?:K? of the same row and paste into the next available row of the spreadsheet...
  15. R

    Cut and move rows - loops

    Hi, I'm trying to cut rows with the word "FBO" in column B, and move them all to a new sheet, title that sheet "FBO Accounts", and delete the rows on the original tab where the FBO accounts were and would now be blank. So an example: There are 100 accounts, 62 have FBO in the name which is...
  16. M

    VBA Cut and Paste keeping same number of rows

    Hey, So I am relatively new to VBA and am having some issues. What I am currently trying to do is to remove or clear a row that has been formatted with strikethrough. My list must remain at 1000 rows with the same formatting (color, size etc). One way I have been going about this is clearing the...
  17. T

    question: cut and paste VBA using the subtotals of data

    Hi, I have a huge list of data and what i would like to do is be able to sort out the data using the subtotals that equal 0. basically it looks like this: <TABLE style="WIDTH: 812pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1079 x:str><COLGROUP><COL...
  18. B

    How to prevent somone from Changing the Name Range

    Hi, I have a excel workbook which has a number of name ranges within it which are regonized as part of a macro when it run. The problem i have is that when people fill it in they sometimes Cut&Paste cells over the named cell/range which causes the named range to be edited by the cell that...
  19. S

    Cut and pasting data into new work sheet

    Hi Experts I'm a newbie to VB and I am trying to figure out how to cut and paste data from the first work sheet into other work sheets. Here is the catch however: Sheet 1 has 10 tables that is cascading. therefore i need to figure out a way to cut and paste each table into a new work sheet...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top