copy and paste

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

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

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

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

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

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

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

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

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

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

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

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" +...

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

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

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

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

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

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

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

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