copy and paste macro

I would like to use the Master worksheet as the intake for new files to the department. Each technician has their own worksheet within the same workbook. I would like to run a macro which takes the data from cells A to G and use the number input from the cell in J and copy over into the...

<tbody> DISCIPLINE 1 25-Mar 26-Mar 27-Mar Team 1 205 197 195 Team 2 10 23 15 Team 3 267 290 293 Team 4 56 57 55 Team 5 2 0 4 </tbody> Need code that will allow me to copy/paste daily total (extracted data) for each team into another Excel workbook with a...

Hi all I am still new to Excel VBA as a whole, and would like to seek help from experts regarding a new issue I have. I would like to copy a column of data from workbook 1 into workbook 2, based on the data it has on row 1. For example, row 1 of column C in workbook 1 has text called "U.S...

Hi There -- I have a list of 4 values ("Auto", "Multi", "Tech", "Lifestyle") in a data validation list (cell I3, Sheet = "Opportunities"). I'd like the macro below to run / pull data based on that selection. Right now the macro searches through the Raw Data and pulls each of the categories one...

I am using code to copy over certain columns if two conditions are met, however, I would like for the code to replace what is already on 'Emerging' (the ultimate sheet). Any guidance would be much appreciated. [code] Sub Emerging() Set i = Sheets("Under achievement data") Set e =...

Hello everyone, I am new to VBA and I've looked for a lot of threads which could answer my questions but couldn't find any. Here is my code so far: Sub copyrows() Dim tfCol As Range, Cell As Object Set tfCol = Range("B36:B45") For Each Cell In tfCol...

The following code works for copying and pasting, but not for copying then pasting as comments on another sheet. Can anyone help? Dim mainWS As Worksheet, copyWS As Worksheet, fmAry As Variant, toAry As Variant, lr As Long, x As Long, main2WS As Worksheet, copy2WS As Worksheet, z As Long...

Earlier today I was able to get some help in editing my code for repeating formatting in all workbooks except the first two. I have two additional asks/needs: 1) I want to copy a range (F6:L11) from the first worksheet into all the following worksheets in cell C18. 2) I want the macro to...

Our company recently moved most of our files onto SharePoint in an effort to backup our files. A byproduct of this is some of the macros in place no longer work. In particular, I have one that copies and pastes a row of information (from lets call it the CM form) onto the next available row...

Hi, What I need is a macro that can copy and paste values back and forth and then work down a list of values. I cannot get some basic macros to do it and am stumped; VBA isnt my forte. I have 2 active sheets in my spreadsheet; Sheet 1 contains some formulae dependent on a certain cell that...

Hi, Using macro, I want to copy "customer order" data from one sheet to another but my original data contains blanks: separating each customer's order. Therefore after the space, is the next customer's name and order date. The original data has 9 columns and varying no of rows depending on the...

Hi everyone, I'm a little new to VBA. Wanted to know if there is an easy to learn and customize VBA syntax that can serve my purpose. My task involves copying and pasting (as formatted values - color, decimal etc.) from one workbook to another based on the following criteria. For simplicity...

I'll try and explain my requirement and what I've done so far and I hope someone can steer me accordingly. I have a spreadsheet with data in Column a:aa (the number of rows will vary each wee but is 5000+) What I am trying to do is to have a macro look at column a and depending on the value...

Hi everyone, I am new to writing macros and I have searched this topic but I can't find something that works. I have data in an excel file that is separated in sheets. Each sheet contains country names starting in A2:A201 and numbers for each country along the columns that start from year...

Ideally, what I need is a macro that copies the data from cells A2:A4, B2:B4, C2:C4 and paste it into a different sheet a specified number of columns to the right, dependent upon the vale that is in the corresponding cell A1, B1 or C1. So for example, if the data were: A1 = 11, B1 = 7, C1 = 9...

All, I am trying to find a method for converting all cells in entire workbook starting with the formula "=cc." to values. This is what I have so far. Sub Do Until IsNotFound Cells.Find(What:="=cc.", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart...

Hi, as my name suggests, I'm not that cluey when it comes to writing VBA. I have read through a huge number of posts and still can't seem to get the code I need. My scenario is: I have a workbook (AAA System File) that has worksheet (Master Summary) with data in it from B6 to AF6. The value...

I have 2 worksheets (WEEKLY SALES and GOALS). I need a macro to copy the sales from the WEEKLY SALES sheet and paste the values into the appropriate fields on the GOALS sheet- depending on the current week of the month we are in. The cells to copy on the WEEKLY SALES tab are in E:8 and G:8. The...