paste 2 sheet or wrkbk

Think I am losing the plot... Simple - select a cell, copy - selct another cell in a different worksheet, paste.... Easy.... Origin cell has formaula in it (=SUM(A1:A5) It copies OK but when I paste, I just get #Ref error - it is pasting the formula and not the value (so the cell now contains...

Please provide me a VBA code that will run and do the below task automatically. I would be grateful if you provide me a solution. I am having around 100 to 150 excel files having different file names. I mentioned the exact requirement in Steps: Step:1 Sample 100 files are listed here but this...

I have some code that a lovely contributor on here was kind enough to make for me, and it takes a list of excel paths (which can be a long list or short), opens them, is supposed to copy all the rows that have data (because some will have more data than others) and then add them to the bottom of...

Hello, I am perplexed with this code and read many threads and can't seam to get it right.:confused: what I am trying accomplish is this: take 3 columns of data (A,C,&D) from sheet2("job1"), then match by exact text of columns C&D to columns C&D in sheet1("overview"). If there is a match...

Hey Mr. Excel I have this Code seen below. The point of the macro is to past data from my source sheet to sheets with matching names with some cell values. I have the following sheet setup <tbody> R (Sheet names) S T U V W 5 Overview 2014-4 1 1 6 9 17 6 Overview 2015-1 6 0 3 12 21 7...

Hello all that read this thread. I'm very new to posting this sort of problem, or indeed any problem over the internet. So apologies if I dont quite get across what I am looking for. I'm also have only basic knowledge of Excel, so please be patient if I don't seem to quite understand. Problem...

Can I ask 2 quick questions. I selected a range of columns and copied. When they paste into the new sheet however they don't paste in the order they were selected they paste in order of occurrence. here is my code. How can i paste as selected. Dim WS As Worksheet Set WS = Sheets.Add...

Used to do this all the time and now that I've been away, I've forgotten why this won't work! Really need it to extract from 1 WORKBOOK to a different WORKBOOK but out of desperation, I'm testing 1 workbook trying to simply extract from SHEET 1 to SHEET 2 for simplicity using an INDEX (look up)...