copy & past rows

Hello everyone, First time poster to the board and fairly new to VBA macrosfor excel. Please bare with me on this post if it is confusing. I have managed to Frankenstein together code that allows fora worksheet to be created based off of a template sheet, followed by adding anadditional...

Good Morning! I'm very new here. I'm working on a project for work and I'm totally stuck. Here are the details: I have a very large workbook containing quoting information. There are 28 different sheets representing different vendors. Each sheet contains quote numbers and quote...

<tbody> A B C D E F 1 John Doe 2 235 west street 3 Anytown 4 CA 91001 5 555.555.1212 6 7 111 North 8 Jill Doe TX 9 SomeTown 10...

Hi everyone, I'm new to vba so will really appreciate any help ;). After a long unfruitful search I can't find why my code won't work. To explain the problem, I have an Excel File with a bunch of data sorted by an index called Prod.Type in column A <tbody> Prod.Type Name Price Nb.Stock 2...

Hi, I am looking for a code that will help with what I want to achieve. I have a table where I have to split a column using text-to-columns. The number of columns created after will vary time to time. What I now want to do is copy the rows to a certain column and then for each of the columns...

Hello friends, I have a code which is working good for column1 criteria, but i need to drill down further for column2, column3 filtering.. and then copying those filetered records into another sheet(sheet2). my query is to filter custom rows based on criteria of columns like column1...

hello i have a workbook titled 3 months and in this wb i have Sheet1 which contains data i need copying to a new wb if cell in column D is 0.1 or less, this could be 1 or 200 rows. this new wb would need to be saved in a different filepath. i'm assuming this is possible but i am not sure how...

Dear Sirs, Wish you all a Happy New Year! After doing 2 days of searching I'm here for you kind help! Requirement: I want to copy a row range of data to other worksheet. For example- Range(A1:H1) from sheet1 to sheet2. Im am using this code below to do this Sub CopyData() Dim nextrow As...

Good morning all, I seem to have stumped myself on a bit of VBA coding and was hoping someone might fancy a challenge! I have a tab call 'MasterSheet' which is fed by a userform. I need to be able to transfer snippets of rows into different sheets; which my formulas run off. In MasterSheet...

Hi, this script copy the entire row into another sheet based on text value in a cell. Copy works fine. However it also delete the row copied from original sheet, and I need it to stay! I need the row to stay and be copied, not copied and deleted. How can I get rid of line "Cell.EntireRow.Delete"...

Hi all, I'm looking to write a macro that looks a two sheets (Sheet1 & Sheet2). These sheets each contain a table of data. I'm hoping to run code that looks down column U in Sheet1 and see if that value exists in column U in Sheet2. If it does I want to copy the corresponding row from Sheet1...

Hello I have a spreadsheet with multiple columns that after filtering column G I want to copy those lines onto another spreadsheet. My hurdle is that those lines vary, it could be one, ten, etc. Without getting into too much detail here is part of the code. Essentially I want to copy any lines...

Dear Forumers, I can't tell you all how happy I am to be a part of this forum and such great minds. I am not new to excel but to VBA. I would request all to help me with a macro that I am unable to create using record macro. I know thats very basic, but I am new to VBA and eager to learn. I...

Good evening, Can someone help me with the following please? I have a workbook with a number of worksheets that are filled from a userform. I'd like to be able to copy the filled cells from several worksheets into one (same workbook). Sheet1 is filled from columns B:O (from row 9 and down)...

I would appreciate your valuable help. I have a sheet that contains a 3 columns every column contains a value A1:TOKEN, B1:CHIP & C1:DATE, the token value can be repetead any times but i need that if this ocurrs copy the same DATE of the first TOKEN that aparece. For example: <tbody> TOKEN...

Hi Guys I hope you are all well. I was just wondering if anyone could help me. I receive a report and I am trying to automate the emailing of this information out ( which I think I have managed to do) but I am unsure about how to automate the Copy and Paste Side of it. Would anyone know...

Hi, I'm rather new to Excel VBA, but I manage to make it work with the help of the recorder and the help of this forum and others like this one. So, thanks for all the work! I have a database with a lot of information on people. Each person has an employee number assigned, so I've used this as...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; min-height: 13.0px}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #011993}span.s1 {color: #011993}span.s2 {color: #000000}</style>Hi, I...

I am creating a workbook for asset history where each asset has its own worksheet. This is continually updated as assets are utilized.<o:p></o:p> For of data entry I would like to have a single input table where usage and values on multiple assets can be entered. I am looking for a VBA code...

Hi I need a macro help to do work on copy level. Need Help in Macros to Copy a particular 2nd row from different workbooks. All these workbooks will be in a particular folder. In all workbooks sheet "DATA" is common, from this "DATA" sheet i need to copy 2nd row & paste one after one in a...