copy & past rows vba

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

Good Morning Friends, I have an employee training spread sheet that lists out the employee and all the areas that they are trained in. However, the row is super long because their are a lot of areas across different departments that they could be trained in. My row currently goes all the way to...

i've been playing with this all morning but no progress. Any suggestions would be helpful. I'm reading in a xls file looking at column I. When I find multiple entries in col "I" separated by a comma, i need to create a new row for each Item I find and insert it into a new row. Right now I have...

Hi, I need to transform a raw extract into a new sheet for a pivot source. The raw extract has transactional information + check-in and check-out as shown below: <colgroup><col><col span="2"><col><col><col><col></colgroup><tbody> LISTING'S NICKNAME CHECK OUT CHECK IN SOURCE ΣTOTAL PAYOUT...

Hey everyone, this is my first post here since I'm new to VBA. I'm not good at coding but I will provide you with all the information I have right now. Summary: My goal --> Macro Step 2: Trying to create a macro to consolidate data from multiple workbooks / Suppliers into one Master-File...

Hi. I am beginner to excel vba. I would like to ask simple question that I've been stuck for few days. So far, I have two columns, for example column L and M. I have to loop all column L and find the blank cell. If there are a blank cell, then, it will copy next value in column M. Roughly, the...

Hi, I have been searching for a solution to this issue for quite some time with no luck, some findings get me a portion of the way but not quite what I need. I do not have any VBA experience but I am very competent with formula writing. I need to pull data ranges from closed, excel sheets...

hello I have a spreadsheet with various columns/rows of data. what I am trying to do is if a cell in column A has a string of less than 4 characters (this could be either alphanumerical or symbol) I need to cut & paste the values from columns G,D,E & F only to a new worksheet (in the same...

I have a workbook (BoardTime.xlsx) tracking board member time. Each board member will send me a CSV file with their information for a period of time (CSVExport.csv). I need to copy the data from columns A through E from CSVExport.csv starting in cell A2 to a worksheet in BoardTime.xlsx named...

Hi, I'm trying to create a macro that looks up the word "Insert" in column E2, copies the contents from A2:G20 and pastes in the row directly below (A3:G21). I'm hoping to loop the macro because there's the possibility that more rows need the same argument. <tbody> A B C D E F G 1 SKU...

Hi Community The following is an extract of my code. Basically, I'm copying rows of data from source workbooks to a mastercopy workbook. All fields copied over are fine except for the date files. It went from 07/03/2019 (Source) to 03/07/2019 (Mastercopy). Is there a value that i can fix this...

Hi Team, I am looking for some help in copy and paste the data based on some criteria. For example, I have 175 columns in sheet2 and this might increase or decrease. I have 25 columns in sheet1 this may increase or decrease based on the requirement and all these columns has the same names (99%...

I am trying to do something relatively simple and can't seem to get the copied rows to show up. I would SINCERELY appreciate ANY HELP!!!!:confused: 1. I have 10 sheets in a workbook (I inserted all of these based off of the same macro enabled template) 2. I am trying to copy the highest...

Hi Team, I need some help, I have 7 columns data in sheet1 and this is the reference of original data from Sheet2 (through the formula) both data sets are same. I am not sure if this can be done via worksheet change request. If I change the cell value in any rows then that entire row till...

I hope you can help me with on requirement, I have 10 columns data in Sheet1 and during my working, I can change any data in these columns...but usually, these changes anywhere in the row...same data in Sheet2 and whatever changes to in sheet1 should automatically replace the values in Sheet2...

hi guys, I'm new here so please forgive me if I have not posted accurately. the source is table format. I'm currently working on some code to copy paste an entire row to archived sheet based on a single column being filled in column I after the table headers from row 8 I have got the code to...