copy and paste

Ok, so this is my dilema, I am trying to set up a template that can copy data from a sheet in one workbook and paste it in to another. So why am I failing. The code is below. The first part opens the workbook that is designated in cell B3. Next I need to copy the data from that workbook on...

Hello Everyone, I would like to ask an assistance, I am new in scripting VBA and I need help on how I can transfer all the data from multiple sheets to one Master sheet in the Excel File. I have 6 Sheets where I'll get the data and the data are in Range A7:K16 (this range applies to all the...

Hi, I've recorded the macro below. a) It selects rows 1:52, copies and pastes on the cell A53 (so immediately below the last row that is empty) b) Selects rows 53:104 copies and pastes on the cell A105 (same number of rows - 52 - starting from the cell immediately below the last row c) in the...

I am attempting to export my data from excel into word, but I need to paste it as formatted text (rtf). Does anyone know how to do this? I would also like to change the orientation to landscape, and set the margins to .75 on all sides. Any thoughts?? Sub printer() Const...

Hi all, Is it possible to Copy a cell value and paste that same cell value when the original cell is merged without the excess empty cells? The merged cell is 4 cells horizontally so when the macro runs, it copy and pastes the value of 1 cell value and 3 empty cells Thanks

Hello, I have a worksheet (Input) where users will update information. I then want this info to be copied and pasted into another worksheet (Output) at the end of the day, by click of a button. I have found the below code which copies the first row and pastes it into the first row of the Output...

Hi everyone, I am new to Macro and I hope you can help me out. I have 5 tabs "1,2,3,4,5" and I like to copy range B4:Y and paste it to "Total" tab. Each tab has different numbers of row. How can I do that with Macro. Please help. Thanks!

Hello All, I'm trying to copy a range of values from one sheet to another, and then filter out any NA() errors. So far, I have the following bit of code: Sub CopyExtQuery()' Copies the query for the extended report from the Calculations sheet. Filters out NA() errors after copying...

Hi all, I work for an oil company and have a master list of all of the leases that we service along with other information specific to each lease. Along with the master lease (which is on one worksheet), I have also created a template for each separate lease using individual worksheets within...

Hi! I came up with code that filters a set of data and then copies and pastes certain columns(Customer, Project Name, vs) into another worksheet (in columns N, O, and P) Is there a more efficient way to write this code? Im having to copy/paste the same code three times in one sub. Someone...

Okay all - this is driving me insane :banghead::banghead::banghead:. I am trying to come up with a VBA macro that will allow me to press a button and the following things will happen: Select a range in a (already completed) template. Copy the selected range. Switch application windows Go into...

At work, I am able to download a mailing list from our database, but it always comes out as a pdf. When converting the pdf to Excel, it makes a new worksheet for each page of the pdf. This sometimes results in an Excel workbook with 300+ worksheet tabs at the bottom, each with 50 rows. They...

I have written a code that enters information into one cell, populates an excel template I've made, then creates a PPT file and slide, pastes the template in, creates a new slide and goes onto the next data point in excel to populate the template with the new information. It is doing all of...

is it possible to open all files in a folder, have cells bj16:br16 copied and pasted to a new workbook, closed out and repeated through all workbooks in the folder? also if this is used with a macro button and I press it again after another workbook is added could I have it only add the...

The workbook that I am starting in is called "Rachael" The workbook that I am trying to copy into is called "Jessica" This workbook has two tabs that I need to paste into “Summary” and “Summary Fall” The range that I need to copy the information into is: X 8:61 - "Summary"...

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

Hey guys, so here is my code: Public Sub newcopy() Dim WSCount As Long, StartCellRow As Long, i As Long Dim sht As Worksheet Dim region As String WSCount = Worksheets.Count - 2 Application.ScreenUpdating = False For i = 3 To WSCount + 2 region = Sheets(i).Range("E1").Text...

Hi everyone, I am attempting to construct a code that will cycle through all sheets in a workbook (except for the first two), finding a range in each, copying that range and then pasting it to a specific workbook based on a case. I keep getting an error message. Public Sub newcopy() Dim...

I have several textboxes with buttons that populate several cells in a single column and then copies that column so that I can then paste the contents into a seperate company data entry program that is web based. I have enabled the enter key (for carriage returns) in the textboxes so that...

Hi all, I am relatively new to VBA and am trying to learn it's limitations. I have managed to create a user form that creates a new tab with the name entered in the user form text box. On this new tab, is there a way using VBA to have it equal to the values and formatting of an other tab at...