copying

Sub CopyTables() Worksheets("SHMM Sections").Range("A3:G300").ClearContents Dim lastrow As Long lastrow = Cells(Rows.Count, "G").End(xlUp).Row Range("A2:A" & lastrow).Copy Sheets("Sign-In Sheet").Select Range("A2").Select Worksheets("SHMM Sections").Range("A3").Paste...

I have a large (200k rows) data set that I need to filter for different items and split those out to a different tab. Is there VBA method for finding multiple matches in a large data-set and copying out those rows that is more efficient than using the autofilter and copying the filtered data...

could anyone correct my function. tired of copying and pasting this formula over and over. Trying to get it to work in a script. cell D3 is an example of what id like to input. Thanks https://docs.google.com/spreadsheets/d/13Dr8cFYFE9xNTGSYyFbAY4_vKjANavSa7GcSd-6hRhk/edit?usp=sharing

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

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?

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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