macro - copy/paste

  1. U

    VBA Browse Multiple Files and Copy Data

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

    Macro To Comment Based on another Sheet

    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?
  3. U

    How to find last row and Add A Border

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

    VBA Copy & Paste values & Formats between workbooks

    '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...
  5. G

    Conditional Copy/Paste Macro

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

    Macro won't skip cells already copied

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

    Filter and Copying of Data on Another Sheet

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

    Grouping of Data based on Criteria

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

    Importing data to Master File that has a changing name

    Hi, I'm trying to copy and paste data from a selected workbook into my master file. One main problem I'm having is getting back to the master file, the reason being is that the name of the master file changes each month to whatever month it's being run in e.g. "March Master File" for this month...
  10. J

    Append rows from 1 wb to bottom of another wb based on column values

    I've used this site many times for tips so thank you, but never posted a direct question. I'm an excel hack and I can do this task with a few 'hacky' clicks but I now have to put it into a macro for an 'end user'. 2 open workbooks: Daily Despatch Report & Ready to Invoice I need to copy all the...
  11. S

    Excel macro - open files - copy data - rename worksheet close files

    Hi there I hope someone can help with a small macro. The macro is to: 1. Look inside a specified folder at all csv files 2. Look at column G of the csv file which contains a date and time in this format 28/02/2018 08:31:10 and take the date from this the second row and then create a...
  12. U

    Open CSV File and Copy the Data on Other sheet

    Hi Guys, Here's a snap of my codes but it automatically paste the CSV file data on the data sheet. I was wondering if you could help me find the codes for GetOpenFile whereas the path file directory will open. After I paste the address, the macro will open the CSV file and paste everything on...
  13. M

    VBA-Macro Copy & Value Paste all non hidden Sheets data

    Hello Everyone, I am looking for a VBA-Macro help . I already complete the macro by using macro recorder. But every time, I need to change that code when the sheet name was changed. Please, anyone kindly help. Here is description of my problem : 1. I have a excel macro enabled file which has...
  14. U

    VBA Code Query

    Hi All, Ive recorded the following macro which does the function I wanted. I know that excel adds a lot of useless lines when you do this and since im trying to learn VBA, everytime I code something I try to learn and understand the code. So basically all it does is go to a specific tab and...
  15. M

    Inherited code - VBA to copy multiple sheets from workbooks on Sharepoint

    Hi I was hoping someone could help me please. I have been asked by my bosses to complete a macro started by someone else as I'm 'a bit IT'. I was a COBOL programmer in a previous life and that was 7 year ago, so have no idea about VBA code! Apologies if my questions are very basic. I would...
  16. P

    how to Copy data from one worksheet to another worksheet..Data should be copied on new rows every time

    Hi, Please help me in this problem. I have my data in worksheet 1 with Row headers..Like Name, City, Assignment,Date. Now worksheet 1 is having list of 100 members in Column1 and they will be assigned 2-3 type of assignment on daily basis. Assignment will be entered on Column 2..Date will will...
  17. K

    Macro - Copy cormulas & range based on value

    Hi guys, im trying to create a macro that can copy formulas in one column (cells: A10:A20) and based on a value in another cell (Cell: A1) the macro should paste the formulas the same number of columns (cells B10:G20) as the value is in Cell: A1 . Lets say the value is 4 (January to April)...
  18. D

    Pasting to a location specified within an active cell using VBA?

    Hi Guys, I am attempting to finish off a project for the team and wondering if VBA can achieve an unusual task. Goal: to copy the contents of cell (M3) in worksheet 2 into clipboard; thereafter, to paste the clipboard contents into a location in worksheet 1 i.e., into a cell which is specified...
  19. M

    macro for special copy / paste

    Hello and I need some help with defining a macro to do the following. My excel file has 2 register; "export" and "archive". At the end of each month I want to copy each line entry from register "export" that has a date stamp within that month and paste it into the register "archive" below the...
  20. T

    Macro Partial Cell Copy and Paste

    I've looked all over, but I can't find a solution for my problem. When recording a macro, how do you copy text from one cell, and append/paste it after the existing text in another cell. Before: <tbody> 4600 PE 4606 PB2 4610 PEM </tbody> After: <tbody> 4600 4600 PE 4606...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top