macro - copy/paste

I would like to create an excel macro where I can click on a button, and it will perform the following functions: 1. Open SAP Easy Access 2. Open IM33 - Display Budget of Inv.Prog.Position 3. Search terms laid out within specific cells 4. Upon displaying results, copy information displayed 5...

Hello Can anyone please point me in the right direction with some VBA? I want to copy and paste a worksheet ("Phase2_Timeline") onto a new worksheet (that hasn't yet been created), but for it to be called "TU Report " & Format(Date, "dd-mmm-yy"). I have been trying; Sub Create_TUReport()...

I would like to create an excel macro where I can click on a button, and it will perform the following functions: 1. Open SAP 2. Open IM33 - Display Budget of Inv.Prog.Position 3. Search terms laid out within specific cells 4. Upon displaying results, copy information displayed 5. Paste into a...

Hello Sorry this could be really simple but I've spent hours and feel like I'm going round in circles! Any help would be really appreciated. I want a macro to insert a new row below the current active cell, then copy and paste format and formula from row 8 into that new row. I have been...

Hello Excel Gurus, I was thinking of creating a macro based on below criteria: 5 Tabs will be created in running the macro: 1. New - New accounts that doesn't have any previous data (Copy Whole row) 2. Zero - Accounts that doesn't have any score currently but previously existing (Copy Whole...

I am trying import data from 3 worksheets in a specified work book. My code works to delete the existing data in the destination wb. When I the code gets to the import commands it does not import. I have checked the file names and they match. When the resource actuals wb opens it is read only...

Hello, I am working on a macro to find column names "Prov_Specialty" , add new column named "Specialty1" and copy data from the original column to the new column. Here is how far did I get: Dim Found As Range Dim LR As Long Set Found = Rows(1).Find(what:="Prov_Specialty", LookIn:=xlValues...

I have a few excel which has 23 columns and another few with 7 columns with headers which I get daily with new data. I have another excel which is the master excel where I have all the data updated. My master excel has only 12 headers and columns. The headers are not the same on the master excel...

Hi, I have two excel documents, "Book1" and "Book2". Book1 is exported from our business system. Book2 is a compilation of forecast from the businesssystem data that were exported. Today I have to manually put in the data from Book1 to Book2. I want to put a VBA Code in Book2 to import data...

Hi there, I'm trying to create a series of Macros in a document, that will enable us to import data from a sheet on another document, into a sheet onto the active document. Multiple people will have access to the document, at different locations, so the files the data is being imported from...

Hello, I have two folders with multiple files (daily SAP users). I need to open each and every file and copy values from col. C and paste it in a master file in col. A. The values from the next file (col. C) need to be copied in Master file (col. A) in the first empty cell, and continue till...

I have a macro to copy and paste information from one sheet into another, looped to cycle through the different drop down options at the top of the page (i.e. you end up with one separate tab for each drop down option) One part of the sheet contains text boxes linked to specific cell values...

Hi Guys, I have an open binary excel file (named "Masterfile"). I badly need the codes where the macro will browse from certain Source Folder and import multiple files onto the binary file. There are 3 files inside the Source folder namely: 1.) Survey.xlsx 2.) Checklist.xlsx 3.) CB.csv . I need...

Im trying to create a macro that comments based on another sheet I set up with the text in proper order (ie. A1 on Comment Sheet has Comment that should be in A1 for Sheet 1 and so on). I'm struggling with automating this one, does anyone know how to do this?

Hello Guys, I have workbook with Sheets 1 to 10. For each sheet, I need to find the last row, delete the excess vertical lines below it (just CTRL+DELETE). Below the last row, I need to add a vertical border by just copying the border that can be found on A3-AC3 across all sheets. Thanks in...

'My code is running through without error all the way to Msgbox. However the values are cleared from "WbRevDash" workbook and new values are not pasted in. The ranges are just blank. Any suggestions are helpful! i think it has to do with this part of the code but im a rookie and rely on the...

Hi all I currently have some code that copies and pastes rows, a variable number of times dependant on data in Supervisor Name field, to a new sheet. What I am looking for is a way of adding a cell prior to the pasted data, populated with 'Call 1, Call 2 etc. which references the number of...

I have a macro that runs through my source sheet "CleanData" and copies any row in that sheet to the active sheet provided the active sheet's name is in column A. It skips over rows that do not meet this criteria. So far, so good. The problem I'm having is that when you run the macro again it...

Hello Guys, So I have below data on Sheet1 with a range A4:BC. What if I want to Filter all those that returned as "FALSE" (in T/F Check Column) and copy those related columns namely "Inital Check", "Check', & "T/F Check" on another tab sheet named "Check" in range E1:G1. <tbody> A1 -...

Hi Guys, Can you possibly help me on creating a macro that groups data based on below sample criteria: Raw Data: <tbody> ID Team Name Status Date Type 1 Math Ana Closed <tbody> 9/21/2017 </tbody> <tbody> Critical </tbody> 2 Math Seff Open <tbody> 9/29/2017 </tbody> 3 Math...