macro - copy/paste

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

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

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

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

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

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

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

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

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

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

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

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

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

Long time lurker, first time poster, I created a form on "Sheet 1" that utilizes a VLOOKUP function to fill specific cells. This is my current code: Sub CopyIngredients() Sheets("Sheet 1").Select Range("B18:R36").Select Selection.Copy Sheets("Sheet 2").Select Range("B1").Select...

Hi All! First up, new poster, and VBA isn't my best programming language. So, apologies if I've stuffed up something stupid -- I'm learning :laugh: Now, I've got a database full of rows of different cases, and I'm trying to split the cases so that there is only one "citing judge" per row. Each...

Thanks in advance for your help. I am looking for a macro/function that does below: Column 1 : Has comments that I add in each day Column 2 : Maintain the history of all comments form the past When I add a comment in Column 1 , And when I press a button or automatically when I go away from...

Thanks for stopping by, First off, I am new to VBA so I feel like what I am trying to accomplish is probably way over my head. Also, I have searched for a solution to this but can not find exactly what I need. I have a workbook that has an overview (Monthly) worksheet with value headers in...