copy & paste rows

Hi all, I'm hoping I can word this clearly because it's a bit of a muddle in my head. I'm building a spreadsheet which has two sheets with a table on each sheet. At the end of each month, the user needs to be able to copy specific information from Sheet1 (called Planning) to Sheet2 (called...

Good day everyone, Trying to have a button ( or multiple if needed ) that when clicked will be able to copy A2:F6 ( for example ) and paste in different range. But i also need it to be able to then select the info associated to the next name in column A and copy paste that one. The tricky part...

I have a report which I have to update from time to time. The combination (Concat) of the values from two columns is unique, so I have a "code" which identifies the row. So, for the example: Sheet 1 has 1000 rows, Sheet 2 has 1200 (The previous 1000 are included in this) I want to copy over to...

Hi everyone, Long time lurker, first time poster - I'm not great with VBA to begin with and I'm at my wits end, so I'm hoping someone can help me. I am trying to create a button on Sheet1 that, when pressed, will search for "X" in Column F of Sheet2 and copy the full contents of that row onto...

Good Day, I am trying to copy data from Sheet1 (which meets the conditions of an IF statement) and then paste the relevant cells for said row into Sheet2 of the same workbook. Initially I managed to use the following code to simply pull in the relevant rows: Sub Copy_to_Sheet2() a =...

Hi there MrExcel community, this is my first forum post! So I have just recently started a new job and blagged that I could do some basic VBA and ...well... let's just say that I am on a steep learning curve :) I have a basic repetitive task that I am hoping one of you could help me with. I've...

I am brand new to anything to do with Excel programming via VBA. My issue sounds simple but I don't know how to fix it. It is for my job and I feel there is an easier way to do this. I have a workbook that has 177,000 records. The example below doesn't show all the columns on the original and...

Hello, I am having a bit of trouble getting my code to copy/paste everything (formula and formatting) from the "Template Tasks" worksheet - opposed to just values. I think it should be a quick/easy adjustment, but I haven't been able to figure out how to modify. Any assistance would be...

Hello All! I am working on an excel file for work, one that tracks the performance of the company and individual employees on specific jobs. The file has a master sheet, 1 sheets per employee of interest, and other sheets with relative unimportant functions in this context. Individual jobs are...

Hi all. Long time listener, 1st time caller. I am still learning a lot every day with VBA, having only recently returning to a position that requires me to use it again, and I didnt know much before! I have a UserForm which is populating data entered into 'row 2' on 'sheet 1' which I need to...

Hey all, As i don't know much about VBA i hope i can explain what i need to you guys. I have a workbook with daily results. Now i need to copy these results daily using a button into another sheet. Lets say Sheet Calculation range A31:E31 into Sheet HistoricalData range, new row, while adding...

Hi All, Can someone please help me with the following issue: VBA will open file Kenneth.xlsx. In this file the filtered data has to be copied into. This file has several sheets (all sheets have a unique name). Based on the filtered data from “working”file “In Macro V 1.xlsm”, data has to copy...

Hi Forum. I have a journal entries in a table. In cases of emergencies, a tipline might have to be created and someone is in charge of compiling all of the tips and deciding what priority they are. My table headers are as follows starting in row 5: TIME, PHONE, NAME, TIP, PRIORITY. I have 4...

Hello, I have a workbook that has two sheets. On the first sheet is a list of approximately 30 text strings (i.e.: customer is not happy, not negotiable, no one cares, etc). The second sheet has multiple columns from A:EF and approximately 785 rows. The data I am searching for is in column...

Greetings MrExcel forum members. I'm a beginner when it comes to writing macros and have used this source before, but I'm having trouble with a new macro. Any help this amazing community can provide will be greatly appreciated. My boss wants a monthly report listing all personnel that are...

Hi, excel 2010 here again. Been searching for similar issues but it's both difficult to describe in google the problem and understand different solutions, but it's something like this: In sheet A, B and C the cell E1 has a value, let's say "abc". This value is also located on sheet D, and I...

I'm very new to VBA, so I'm not sure how to do this. I have a Sheet1 containing names and such. In the 6th column there numbers and #N/A's scattered across. I'd like to be able to remove all the #N/A's and paste them to a separate sheet for analysis on them without having the filled cells in...

Hi Everyone.. I have a workbook named "Klaus", with a number of worksheets.. The first sheet it named "Ark" further I have a number of other worksheets with the same structure as shown here: (The solumns are A to C..) <tbody> ID Year Weight 134 2004 20 123 2004 17 543 2004 13 247...

I have an excel spreadsheet. (Tabs: Everything; CourseCatalog; Old) In the CourseCatalog I need anything from Everything in Colomn C that is marked as GA to copy over the entire row. When it is copied over to CourseCatalog I will hide some colomns. This will need to be something that happens...

Hi I am new to Excel and I need some help in writing the code for the following problem: I would like to transfer a block of lines/rows from 1 worksheet and paste it to another worksheet. The Range of interested: "A200:A297". Stop copying when it reaches the 1st of two consecutive empty...