copy & paste

Hi, I have been using this macro which is copying everything (formulas, formatting etc.): Sub Macro_1() For Each ws In ActiveWorkbook.Worksheets If ws.Name = "ß_PCF_1" Then ws.Range("B3:M100").Copy Sheets("ß_PCF").Cells(Rows.Count, "b").End(xlUp).Offset(1) End...

Hi Everyone, Would like to ask an easy way where I can easily list the information in rows into column list. Thanks! Current Data In actual, this composed of around100 data rows Note: Column A Column B Column C Column D Column E Column F Column G Column H Row 1 Order1 APPLE BANANA...

I am trying to create or find a VBA code that will allow me to copy row 1 on the sheet and paste the entire row in each blank cell in range A3:A177. I have data in random places throughout, so I can't put just every so many rows or cells. I need to run this macro after pasting the information on...

Hi Gods of Excel, how are you ? ? Guys, I took this formula from one place and try it works perfect. It can copy files from one folder to another, but I want to update it and add color in cells which were copied something as indicator ( fore example green color). Is it possible ? Example...

Background: This is my first time dealing with macros. I will have two workbooks that I’ll be using. The first workbook (will call it Source) contains data source which is downloaded daily and workbook name changes, but the worksheet name remains the same "HOTT Detailed Module". The second...

Hi, currently I have some data in sheet name "From Text" that I want to copy to the table in sheet "Source" but the problem is I want to copy all the selected data to the last row of the table instead of overwriting the existing data. i tried to google around but none of the code fit my...

Hi Everyone, I need help with my current situation. I'm stuck on what I needed to do. So basically what I need is to cut/copy and paste a row of data from one sheet to another with a condition. In Sheet "AR Format" if Column A have "x" value on that cell it should select the range (A2:L5) then...

This code works fine except the worksheets end up a different order in the Destination. Any way of stopping this? Private Sub Jobcard_Templates_Click() TurnOff Dim wkbDest As Workbook Dim wkbSource As Workbook Dim ws As Worksheet Dim wsDest As Worksheet Dim...

I have a Excel file with Header from A1 to H1 in sheet "RAW DATA" In the Column E of RAW DATA sheet I need to filter the data and paste into different sheet. There are 25 type of data in column E and I have 25 sheets with that matching Text as sheet name Presently I am copying data from Raw Data...

I have a number of excel files that have two different named sheets (let's call them "x" and "y" for simplicity); so file1 has two sheets "x" and "y"; file2 has two sheets also named "x" and "y". I want to combine all of the worksheets named "x" onto a master file with a similar name such as "x"...

I'm very new to writing Macros in Excel, and have done a bit of looking around to try and solve my problem, but I haven't found a solution yet that works. I'm trying to write a Macro to do the following: From Source A (sheet YYYYMMDD, workbook YYYYMMDD.csv) based on Tank_ID values (in 2...

Ok, so I would really appreciate help as this has been driving me mad for over a week. Basically I have a raw data table where a customer can choose up to 3 different courses, data is in 3 columns. But I need to be able to have a complete table where if a customer selects 3 courses, her details...

i have a userform in which i want to copy textbox1, 2, 3 data multiple times as per the combobox1 values to sheet1 as follows: combobox1 value = 1 - copy textbox1 values in cell C3 , copy textbox2 values in cell C4 , copy textbox3 values in cell C5 combobox1 value = 2 - copy textbox1 values...

I have a code that opens various web pages, copies (Select-All) the information on the web page and then pastes the information into an excel using match destination formatting to ensure that the worksheet replicates the column formatting within the web pages. The code below has worked for...

Hi All, I am quite new to this and I have gotten so far but I can't seem to find a structure to do what I need to do. Below I have attached Workbook1 and Workbook2. I can move data from both workbooks, but I was to paste to a row/column that has a specific value in Workbook2. In my code, I...

Would be very grateful to anyone who can provide assistance. I use a program that exports data to an xlsx file in a particular directory. The code below will open the most recent file in the hardcoded directory. Sub NewestFile() Dim MyPath As String Dim MyFile As String Dim...

Hi, I am quite new to VBA and enthousiastic about it, but run into a problem. I am trying to copy two worksheets and create a new workbook. I want to copy just the values of the worksheets and next to that I am trying to protect the new workbook with a password (not able to change values or...

Hello - I have two sheets, Sheet 1 and Sheet 2. I would like to copy and paste the values from each of those sheets onto a new sheet, Sheet 3. All rows in Sheet 2 need to be duplicated for each cell in Sheet 1. Sheet 1 just has one column, with multiple rows. Sheet 2 has multiple columns...

Hi All, Can someone help me with below requirement. I have two wrokbooks wk1 and wk2 in the same path as my macro workbook. in Wk1 in sheet1 i have my dump from column A to AX. in Wk2 in sheet2 i have headers from column A1 to S1 what i am looking for is to copy respective data for each...

Hi Gurus, Do you have any thoughts on how to code this. I have a binary file with data ranging to 1 million lines. I am planning to copy the data in xlxs version. The header to be use is same with what's in the binary for all sheets. Example: Open Binary File that contains 1.05 Million lines...