copy & paste

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

Hello Everyone I am attempting to copy a specific region's contents and copy the Current Region back to a summary page. I have unfortunately run into a bit of an issue with pasting the data back to the summary sheet. Desired Outcome: Maintain Merged Cells Maintain Cell Highlight Colors Cell...

Hello. So I have two workbooks here. I have attached screenshots of both. One is Pickorder. Column A lists the dispatch times. Column B has route codes. Column D has the dispatch areas. Column E has the dsp taking the route. For example, CX19 dispatches at 6:15:00, at STG.A01 for HIQL. I then...

My copy/paste in the "problem line" below is returning a run time error 1004 Method 'Range' of object '_ Worksheet' failed. What am I doing wrong? I know that the If statement is true for the first time at row 3045 and that the msgboxes return the correct sheet names when I have those lines...

hello everyone, Fairly new to VBA. I'm only using simple macros. Just wanting some help with a VBA. I want to copy and paste items from the same cell which I change, into the next line after. Here's what I use so far. But I don't know how to loop it so it does the next line down. I hope that...