pasting

My overall goal is to transfer Data from Spreadsheet A that has been filtered into Spreadsheet B that has also been filtered. Copying and pasting refuses to cooperate given the filtering, I've also tried using an equation to make the cells equal to one another but I can't drag and drop that...

I wish to copy data from a from a multiple of workbooks located within a specified folder. Each file has data in cells C1, C2, C3, G1, G2, G3 This data needs to be copied into cells A2:F2 I then need to copy data from row A7:J7, to the last row of data located in column A The data in A2:F2...

Hey guys, First things first here is my code: Option Explicit Public Sub CopyDataLoad() Dim WSCount As Long, StartCellRow As Long, i As Long Dim sht As Worksheet Dim region As String WSCount = Worksheets.Count Application.ScreenUpdating = False For i = 3 To WSCount region...

I've got this working on a couple of other similar sheets but I must be missing something here. In short I'm opening a workbook, copying a range, pasting the range in to another Workbook. However, now when I paste it is pasting an image file not the actual cells. :confused: My code is here...

I was so proud when I modified the VBA code from JLGWhiz' reply to "VBA: Copy all rows with data from one sheet and paste on bottom of another" from this forum in order to copy/paste the rows from ten sheets, and it looked at first glance like it worked! On closer inspection, I found that the...

Hello, I'm having some trouble with dragging an array formula. Before... When I dragged the array formula, in the new cells the formula was correct and there was no need to do Ctrl+shift+enter again in each new cell. Suddenly, out of nowhere, today I opened the file ... and it is now needed to...

Hi guys I'm from India working in a financial firm. In our process the most tedious laborious work entails copy pasting customers a/c nos from excel into our software. then again copy the data from excel and paste it into the software.We at times receive hundred's of these. Is there some...

I am trying to copy all the visible cells from a sheet, then paste everything but the formulas into a new sheet. My current code works fine, except it does not paste the charts onto the new sheet. Is there a way to do this? Sheets("Original Sheet").Cells.SpecialCells(xlCellTypeVisible).Copy...

Hello, I'm having one of those days where I can't seem to see the minor error that is completely stopping my entire workflow. Whenever I run the following code, I get an "Object does not support this property or Method" on the "Template.Sheets(1).Range("A1").Paste" line at the bottom...

Hello everyone, I have an issue in excel 2010 where it will not fully paste the information I'm trying to copy/paste. Sometimes less than half the data is transferred over, as if it doesn't recognize the other pieces of data. (I'm copy/pasting in between workbooks, sheets, and directly from the...

When copying and pasting MS Excel (Mac 2011) into PowerPoint, receive error "Not enough memory available to read worksheet". I saw a similar post in 2010 with no responses. Thanks for any advice

Hi, I have values on the same workbook that I need to copy from (horizontally) B15:Y15 to (vertically) B99:B122. What formula would be best for accomplishing this? Thanks for your help! Matt

I need vba code guru's help to figure this out. We have a excel sheet that has column headers MIC and Version. Sheet1: <tbody> SCRNHYF1 SCRNRBF1 SCRNEBF1 MIC Version Lower Limit Upper Limit MIC Version Lower Limit Upper Limit MIC Version Lower Limit Upper Limit 50015357 1 95 100 50015357 1...

Hello, I was just looking for some help with some issues I have encountered with some VBA code I have. Unfortunately I am not at all familiar with VBA and I have simply taken bits and pieces of code from various places on the internet and now I need some help sorting some things out. My first...

I have a data like below <tbody> Dealer name Location 12-06-2013 13-06-2013 14-06-2013 J.k Agencies Ambur No issues No issues Sri A.J & cext Ambur CC problem MJ agencies tambaram not visited due to rain not done gt store chennai...

When pasting data including long text or dates, from Access, the default in Excel is to put word wrap on each pasted value (not the column headings) and to format dates as dd-mmm-yy. This is inconvenient to me, as I generally don't want random row heights for pasted data and I never want...

I have a list of email addresses in an Excel 2007 file. I need to copy and paste those addresses to send an email. The one email program I use, uses commas between each email address to send to more than one person. The other email program places the email address below each other in...

Hi there, First post on the board and all that jazz so if I don't do it correctly please let me know. I need a macro that opens two workbooks (APC1) and (APC2), selects all the information from (APC2) and pastes it after where the data ends in (APC1). This should be fairly simple but I keep...

I am using Excel 2011 for Mac. In column B of my new workbook, I want to link to a value in Column B of my old workbook. This works fine. But when I copy forward the link to Columns C, D, E, etc... in the new workbook, it still gives me Column B from the old one, and not Column C, D, E. I...