copy and paste

  1. A

    Copy data validation to new workbook

    Hi, Can anyone help? I am trying to replicate a rather large worksheet in a new workbook. I need it to be identical in every way. I have copied the formulae by replacing "=" with "zz" then doing the reverse once pasted into the new book. This way the cells don't refernce the old workbook...
  2. R

    macro to copy and paste data between two data cells that varies in counts of rows

    When the macro was recorded, CTRL + SHIFT+DOWN was used to select the blank rows between two data cells within the same columns. It successfully copied 21 rows, however the macro is set to recorded 21 rows but the blanks between the start point and end point of the two data cells varies for the...
  3. C

    Need to update this code to FILTER data by "x" >> before << COPYING it to the other sheet

    I'm using this code to perform a lookup, match, copy/paste to another sheet within the same wrkbk. It has come to my attn that there are a couple scenarios where this won't be able to handle a couple of tricky scenarios - hence the need to adjust the code with a filter quickly... (this code is...
  4. F

    Copy and Paste Filtered lists - Visible cells only

    I maintain an add-in with handy macros that we use at work. I would like to add one for copy and pasting filtered lists on the same sheet, e.g. a filtered list in a2:c9 should be copied to g2:i9. Only visible cells should be copied. I know this can be accomplished by: 1: selecting the ‘paste-to’...
  5. D

    Copying cell formats

    I've been given a piece of code which was exactly what I was looking for (more accurately what I asked for) and worked brillantly. I have pasted below. I can quite openly say I don't understand most of it but I would be grateful if someone could provide a small amendment. In effect the...
  6. J

    Copy and Paste format issue

    Hi Lovely People of Mr Excel, HSBC won't let me download more than 90 rows of transactions in excel format. This is an issue when I want to get every transaction for 2013 from my current account. So what I have done it view my previous statements which load up in the browser in whatever format...
  7. D

    URGENT Cell's Format Immune to Copy and Paste

    Hey all, We are currently using an excel spreadsheet to upload data to a database. We formatted our cells to "text" so that the 0's in front of our numbers don't disappear. However, when you copy and paste something into that cell it changes the formating and the zeros disappear. Is there any...
  8. D

    VBA Copy and Paste Not Working

    Issue: Everything works fine with this code, but the last section which is marked not working. Objective:To copy the value from one worksheet to the other. Private Sub CommandButton1_Click() Dim text As String Dim i As Integer For i = 0 To Me.ListBox1.ListCount - 1 If...
  9. M

    Copy and paste contra copy and paste special

    When I mark some cells (a table) in an Excel file, copy it and then try to paste it to a Word document; I sometimes get the opportunity ”paste special” which I want, but sometimes I only get ”paste”. I cannot find out why I sometimes only get ”paste”. Does anyone have an answer how to ensure...
  10. T

    Problem searching, copying and pasting between sheets

    Hi. I am working on a programme I can use to plan status in shops. I have created 2 userforms. The first one is for adding shops to the database sheet. The database sheet contains all information of the respective shops. This userform works fine. The second userform is for planning status. I...
  11. C

    Copy and paste

    Hi, I have a macro running on a large number (600,000) of domains. It's going to take about a month to process all of them. The macro makes use of copy and paste. The problem is, I can't use the copy and paste functions elsewhere while this is going on. Whenever I copy anything, by the time I...
  12. J

    Copy and Paste Loop

    Hello, I need to have a macro that can copy two cells and paste them onto a separate sheet. Here's what I have so far, but nothing happens when I run it: Sub T() ' ' T Macro ' ' Keyboard Shortcut: Ctrl+Shift+T ' Let i = 1 Let j = 3 Do While Not IsEmpty(ActiveCell) Range("A" +...
  13. J

    Quick Macro Help

    Hey all I need some help. Just discovered macros and need to use one for a big file. I have a set of data like so: <tbody> date time number number </tbody> which has 25 numbers for each date/time. i need to copy and past, then transpose to this format on a separate sheet: <tbody> date...
  14. M

    Macro Copy rows to Another Sheet based on Heading

    Windows 7 Excel 2010 There are 13 columns in sheet ‘Raw Data’ Copy data from 'Raw Data' to specified sheet name in column A But only extract those columns that Match Headings in the output sheet So I would need a macro to Copy paste rows from sheet ‘Raw Data’ If value in Column A = sheet...
  15. J

    Copy and paste from cell below

    <tbody> Hello everyone, Copy and paste from cell below -- Excel or Access version: Excel 2010 Computer operating system: Windows 7 Sample data: No sample data Formula(s) right now: Not applicable Current result(s): I know that CTRL + " results in copy...
  16. 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...
  17. B

    Cut and Paste Filtered Range

    Hi, I am new to this forum and a (relatively) new user to VBA. I am currently trying to implement a macro that, amongst other things, filters a table on one worksheet then copies the result to another in the same workbook. I had this working fine. Now, for some reason it does not work and I...
  18. G

    Need Help Creating a Macro for Monthly Use

    I need help creating a macro that will grab information from an new sheet after it is added to the work book and paste it on a master page and sort it according to the account number. This is what I have so far but I need to find out how to make the Macro loop every month with each new sheet...
  19. D

    Copy and Paste Cell Based on Conditions

    I am not really sure the best way to go about this: I have data in columns A and B. If the data is in column A it will not be in column B. My objective is to move the data in column A to column B, as long as it is not a number with the color yellow in the cell. The data displays as follows...
  20. D

    How to add to rather than replace using this code snippet

    How to modify this code so that it actually adds to the list of results rather than replace: Sub EncID_IP() '.:: Extract EncID ' Dim lRow As Long ' East to West Dim bCount As Byte '1,2,3 Dim sServiceHit As String 'Service used to find EncID Dim rRange As Range, rCell As Range...

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