copy

Hi, I'm trying to create multiple tables from one master table. It concerns a training schedule where I want to extract lists per person. So the script should loop through the table and select each person and list their trainings. I found code on the web, but it doesn't seem to work. I get an...

I am trying to copy an entire sheet, pasting only the values and renaming the new sheet to the current date. This code allows me to input the date manually, but it copies formatting and the formulas too. Sub AddNameNewSheet1() Dim Newname As String Newname = InputBox("Name for new...

Good day experts, I need to fetch values from an identified column (DistanceToNext), across numerous csv files into a single worksheet. These csv files are indexed with numbers. The first csv file indexed 001 is to be pasted in first column of the single worksheet. The second csv indexed 002 to...

Hi all! I want to create a macro that will find a certain column, based on the value of a cell in that column, and copy/paste values the data from that column to another sheet. The reason why i need it to find based on a value of a cell is because i have "customizable"/"moving" columns and...

Hey guys, I am new here, and not an excel "expert" whatsoever, so I don't really have much knowledge of the code itself. I currently have a master file that is saved to our company's One Drive. This file contains 8 sheets in the workbook and at maximum goes from column A to column V. At the...

Good evening I have a sheet whereby there is a dynamic column A and B with dates that populate (as time goes on, more dates appear etc.). In the worksheet, there is some formulas in cells C:ZZ which use the data in Column A as an XLOOKUP. The formulas in the worksheet don't auto populate the...

Can someone please help me copy a specific range from multiple worksheet and paste it into one worksheet? The worksheets are formatted identically. I need the ranges B11:B24 and C11:C24 of each worksheet to be pasted on a new worksheet. Also, I need D5 of each worksheet to replace C11 in the new...

Good day, I currently have the following code and I'm trying to find an quicker way to copy / paste it. Sheets(1).Range("A2:B2").Copy Sheet1.Range("$B$2").PasteSpecial xlPasteValues Sheets(1).Range("F2:G2").Copy Sheet1.Range("$G$2").PasteSpecial...

Hi All. I'm doing daily gathering of data from multiple sources to a master spreadsheet. Most of the daily data is emailed automatically each day. For 3 out of 4 of the sheets I need, I've simply created a macro button. I open the excel attachment on the email, go to my master sheet, click...

I need to copy set of rows from SrcWrkBook to DestWrkBook if a condition is achieved. In Source workbook (SrcWrkBook) , if column B has a number in such a case that entire row excluding column K,N and O should be copied to destination workbook (DestWrkBook ). In some of the rows, column B has...

Hello There, I need some help to done my working. I have done some part of the coding. Can someone help me about it please.? I cant make continue. like I'm stucked. I have explained in the Main workbook what I want to do. Basically transfer datas from "data book" to "Main book". The problem is...

Hi All, I have a data analysis sheet that Im currently working on. I have a drop down list with different entries and I want my code to a copy specific cells (C102:G105) and depending on the drop down menu selection change the paste location of cell in different sheet. I have some of the code...

I have a case/call audit sheet in which I am trying to move the data between other sheets, yet having no luck. I keep getting the Run-time error'1004': Application-defined or object-defined error. When I debug, it highlights the following line: Range("A1").End(xlDown).Offset(1, 0).Select...

Hi everyone, I have a list of data which is all in one column, essentially I am trying to create a macro or formula that will move all the text from the column into the correct row. Row 2 shows how the data should look. Essentially I am trying to convert all of the data currently in column A...

Hi, I used this macro to copy data from each sheet in the active workbook, from the range A14:BB258 to the MASTER sheet, to the first available row. As you can see I am using a fixed range (A14:BB258). I would like to modify this macro to copy exactly same range (A14:BB258), but with little...

Hi everyone. Thanks in advance for any help you might provide. I'm looking to automate the creation of a PDF report which is based on an Excel file that I created. This Excel file (source file) generates figures which I intend to copy into another file (destination file) based on a condition...

Context: I am trying to set up a library of plants in Excel that I can select and see their state throughout the year, so I know what plants to add to make a good-looking garden. The moment I press the button, that I included in the Master sheet, I want the Master sheet to show the plants I...

I am a lead maintenance mechanic and trying to figure out how to create dated shift reports. Our naming system is (Master file is named "Shift Report.xlsx") Shift Report 7-16-2021 D1 Shift Report 7-16-2021 N1 Shift Report 7-17-2021 D1 Shift Report 7-17-2021 N1 etc... I have to generate these...

Hello I currently have a sheet with 3 tabs on, tab A has a list of information on, tab B has a breakdown of 3 select items from tab A if they're present. My issue is I need code to search through tab A to see if a certain word is in a table, and if so copy the data from tab B associated to it...

Hi All, I would like to know how to achieve this condition programmatically. The main idea is to collect the same "attribute name" for each row for each grouping (column 2) Note: Grouping will be more than 1. like : Logi1, Logi2, Logi3, etc From this : To be like this (result): I had...