copying

  1. J

    VBA to copy same sheet from multiple workbooks, paste as value in separate worksheets in new workbook

    This thread (replay #7 , specifically) nearly does what I want it to do with two exceptions. Code copied below for expediency (Thanks, Bertie for writing this code!) https://www.mrexcel.com/forum/excel-questions/715760-loop-through-folder-copy-worksheet.html This code copies a particular...
  2. S

    Combining multiple columns into one data set

    Hi everyone, I am trying to get the area highlighted in yellow to appear and refresh automatically when adding more data as I continue to add data in the future, while also not copying any blank spaces. https://imgur.com/cf6kvJu Is there a way to do this with a formula?
  3. N

    Offset referencing only working for formulas, not copying? [VBA]

    I have two 'with' statements that select first visible cell and it's not selecting visible cells in column in order to copy+pastevalue. I just want it to: select first visible cell in column AR=>select down to last visible cell in AR=>copy=>pastevalues I used this exact structure for RC[-1]...
  4. K

    xlDown Macro copying 1 million+ blank cells

    hello, I have a database workbook with about 10 pages of VBA code. The purpose of most of the codes is to filter through a table and find unique parts and paste them into another table. I use the "xlDown" code a lot when copying the given range of the table needed to copy, but I've come to find...
  5. W

    VBA Copy and Paste Question

    I want to copy the contents of a range as long as the number of cells in the column have data. Starting from Column D1. Here is my code: Worksheets("DATASHEET").Range("D1:BD" & LastRow).Copy However, the code is copying from A1 vs D1, any suggesting please? Thanks.
  6. cgendron

    Formula not copying

    Hi all, my formula in column D is not calculating correctly. I'm just dividing column A by B but its just copying the results from the first line when i drag the formula down. I feel like there is something simple that i need to do to fix it but cant figure out why it just starting doing this...
  7. T

    Copying and Pasting Between Different Workbooks

    Hi all, I have a 'holding' spreadsheet, which basically holds all my necessary macros. A lot of these macros, involves copying and pasting between different different workbooks, on a monthly basis, and the file name of the book includes the month I'm working on, and is often dynamic from month...
  8. A

    Copying from one spreadsheet to another....

    I am copying some formula's from another spreadsheet that has the numbers in "accounting" format. I like using "currency" instead of accounting and changed the cells to display currency. However, when I go back and double-click on the cell to see the formula, the cell changes back to...
  9. S

    Copying specific data from one workbook to another

    Hello, I've two workbooks and one of them is a stock workbook that has new stocks once every week. In the stock workbook It needs to copy starting from (A2:J2) to the other workbook sheet1(A2),then (A3:J3) to sheet2(A2) and all the way to sheet100 (A2). However, if by any chance that copying...
  10. G

    Quick Way to update Multiple Graph

    Hi, I and a colleague are a bit stumped, trying to create a heck a lot of graphs, by copying an pasting. These are all in the same sheet, looking at tables for data. They are being copied and pasted to the same location in relation to each table. The graphs links remain as absolute to the...
  11. N

    Application.EnableEvents not working on a second workbook

    Hi All - I wrote a sub that copies certain formulas from one workbook to another blank workbook. I've set Application.EnableEvents to false - this seems to work fine if I'm copying code to another sheet in the same workbook, but if I'm copying to another workbook, events are triggered and I...
  12. gheyman

    Copy from one tab to another - code not working

    This is copying what's in columns C:G and pasting them correctly but its not copying the second piece (L11 & LstRw) Sub Grab_BOEs() Dim LstRw As Long Sheets("54_TPL_01_02 Consolidate").Activate LstRw = Range("C" & Rows.Count).End(xlUp).Row 'WBS Number, WBS Title, Task Start, Task End...
  13. C

    Selecting text

    The formula =IF(RIGHT(F510,6)="Avenue","Avenue") works fine copying Avenue into L510 The formula =IF(RIGHT(F509,6)="Street","Street") works fine copying Street into L510 But when I put them together I get #VALUE ! =IF(RIGHT(F510,6)="Avenue","Avenue"),IF(RIGHT(F509,6)="Street","Street") Can...
  14. Z

    Formula ? on scrolling down

    Hi I am trying to scroll down all 3 at once and only change the number going from 8 9 10 11 leaving the letters the same. I cant figure out a way to do this and been copying and pasting and taking forever. =IF(Data!I8=0,TEXT(Data!I8,""),Data!I8) =IF(Data!J8=0,TEXT(Data!J8,""),Data!J8)...
  15. J

    Insert Blank Lines Based on Cell

    Currently using .Range (G4) to determine number of blank rows. However, what I need is for the range to be entire column G:G (that are not null). A better way? With ws Set NBOFROWS = .Range(G4) ActiveCell.EntireRow.Offset(1).Resize(NBOFROWS.Value).Insert Shift:=xlDown End With...
  16. L

    Help with copying cells from a different worksheet.

    I'm looking for help with pulling cells from another worksheet. I have a few hundred rows in worksheet2, and want to change how they appear in the worksheet1. See attached. There are 5 cells that I want to continue to copy, but when I do, it changes the cells from 1 to 5, and not from 1 to 2...
  17. K

    Workbooks to tabs

    Hey guys, Is there a macro for selecting multiple workbooks and then bring them to a new workbook in tabs? I have about 2000+ workbooks that I am currently copying and pasting and renaming each tab and it’s a pain! Any help is appreciated
  18. S

    Can you change the size of Graphs in Excel when copying in to Word?

    Hi all, Just a quick question: I automated a load of reports here at work and the one thing I can't figure out is to configure the size of a graph when copying from Excel to word. I know you can use the copy as picture function, but that requires more 'thinking' than a simple copy and paste...
  19. I

    Copying all the data from first column from 5 tabs and pasting it all in one colmun

    Hi Guys how is everyone I have an excel task where I need to automate a task which involves copying data from the first columns of 4 tabs ( column A:A from sheet1,sheet2,sheet3 and sheet4) and pasting all this data in to the column A on sheet5 Stacked one after another, is this possible...
  20. F

    Spending an hour+ a day copying and pasting

    Hello, I have a the below table with x's (only mine is 100x300). <tbody> Adam John Fred Frank Apples x x x Pears x Bananas x x x Grapes x x Oranges x </tbody> I spend an hour+ each day copying and pasting into the below format by copying sheet...

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