copy & past rows vba

hello everyone, I have little knowledge of the VBA language despite my efforts to learn more and more, but in this specific case I have no idea where to start and I hope you can help me. Suppose you have a normal sheet that contains some data: my goal would be to select a variable number of...

I'm trying to create a Macro to copy the values from a table T1 of sheet1 and paste them into the bottom of table T2 of sheet2 if the value in cell G (key) of sheet1 does not exist in in cell G of sheet 2. If it exists, just replace the values of cell M of sheet2 by the values of cell M of the...

Hello, In order to compare data, it's necessary for me to copy rows based on the number of networkdays (which is calculated). So if networkdays is 2, another additional row is needed below the original row. If networkdays is 10, there are 9 additional rows required below that specific row (or...

The module successfully copies all rows from the source sheet to the destination sheet that have 'Fletcher Bone' in row B. How can I edit my code to copy the values from the source, yet keep the formatting in the destination? Any help you can provide is greatly appreciated! Set wsSource =...

Apologies if this has been already discussed and resolved. Unfortunately, I could not find anything close to what am trying to achieve. I have attempted several ways and have not been successful. It should be noted, am a complete novice in VBA. Here is the use case, am looking to resolve in form...

I got data in sheet1 and sheet2, which i want to copy and paste in sheet3. That is already done. So next i want to match rows, by checking column C, D, E, H and I. The C and H column value is integer and the rest is text/strings. If two rows match, then i want to copy and paste one of the lines...

Hi, im new to VBA and i want to access a path on my Windows computer. Tha path contains the master workbook and two workbooks with information in sheet 1 (in both of them). The two data workbooks contains 3 columns with an id in the first column, date in the second and nominal ind the third. I...

Hi There, I am looking for a VBA code that can copy all the rows (Incl Headers) based on criteria in specific column. Scenario :- I have a File with 8 different sheets and different information. Commonly, every sheet has a "Status" column. I want to filter the status column and check for...

I've been having a bit of trouble trying to get some code to work. I have a workbook with multiple sheets. Each sheets has a bunch of rows of data, and I want to organize the data onto specific sheets based on the contents in one cell. So any of the rows that have the word "BASE" in the A column...

Hi there, I'm stack in a loop where I think I cannot find any further answers myself and I hope to get some help here. I have a worksheet with two sheets 1 being the source of data where I have job information and the other - sheet 2 - is my target sheet which must be a form with all the job...

Hello guys! Hope u are good! Could someone please help me with this code I'm trying to edit an reach my goal? Goal: copy rows from a Sheet1 to a Sheet2, that meet a criteria, with a Date and time record! for example, all rows that have yellow as text in the colum G of sheet one, after I click...

I'm trying to copy rows from one sheet to another worksheet based on a number of criteria (currently from a dropdown). I am currently able to do this for non-dynamic (non-changing) criteria using either an excel formula or VBA coda (which is much faster). However, how can I set up my macro so...

Hi guys, Sorry actually I'm not so familiar with VBA code. I want to transfer data from worksheet 'Register' to worksheet 'Database' in same workbook. I would like to have Transfer button. So, when I click the Transfer button all data from worksheet 'Register' will paste on next blank row in...

Dear all I NEED SOME HELP PLEASE i want to copy rows to the branch sheet based on the branch name in the sheet PROBLEMS EXAMPLE if the branch in the sheet PROBLEMS is "OKAIBE" copy the entire row to the sheet "OKAIBE" can you help me?

Hello, I'm very new to VBA and I've seen that there are many similar questions to mine, but none fits exactly my needs. I have a workbook with several sheets; my main sheet "Final" has in column A all the names of all the other sheets (e.g. 18MP2, 23ST4, etc). The sheets with such names all...

Hi, I have a similar issue to the one in this thread: <VBA> Copy rows to multiple worksheets based on a condition Only I have a different condition: I don't want it to copy the same rows from the master sheet and paste it at the first blank row. So either it has to: Not copy over the same...

Hello, I am new to VBA and have successfully used the below code to copy a row based on unique identifier ,column 15 as I have multiple duplicate data. The row is copied into another worksheet “flag list” at the bottom based on having Y in the unique column. However I cannot figure out how...

Good Afternoon, I've been working on a file that has been automated in the past with simple formulas or just by linking cells to other sheets. In this case, I'm having trouble programming a macro, by using a button, to copy a specific table in between ranges. The ideia is to click the button...

Good Afternoon, I've been working on a file that has been automated in the past with simple formulas or just by linking cells to other sheets. In this case, I'm having trouble programming a macro, by using a button, to copy a specific table in between ranges. The ideia is to click the button...

Hej. Jeg har et problem, og jeg kan ikke lure, hvorfor den melder fejl. Jeg er ved at lave en VBA-kode, som kan åbne en excel fil, kopiere et bestemt område, og derefter lukke igen.. Denne del virker vidst optimalt? Det næste er, at jeg skal kopiere et område i et ark og sætte det over, hvor den...