macro - copy/paste

Hey guys so im struggling with making a macro: To start; i get inventory lists that don't have my data on it and have to go copy columns from multiple tabs. I was creating the macro below but the problem am having is: How can i make this work on any 2 workbooks i have (ex: this one is copying...

I volunteer for my local scout group and wish to create a report that shows which badges have been completed, which are in progress and which have not been started. This is to make building a program easier as we can see what badges to work around. Currently we use a system that allows us to...

Hi there Could you please help me here I need to merge particular sheet "Consolidated data" from the different work book saved in the same folder to another work book without formulas. Save as values.

Hi Excel Gurus, I'm working on an macro project and almost done. I'm just having a problem on this: I have 2 excel sheet, one is working file and the other is database. What the macro needs to do is to check the cell with blank category (in working file) and add below column data in the...

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