copying and pasting

Hi, I need to copy a row and insert x number of times below (thus shifting down the below rows). The x is a value from another cell. I am struggling with my code as all I managed to succeed is copying the row and pasting x number of times but it overwrites the below row, it doesn't shift down...

New to excel/vba, not too familiar with coding, & many other generic openers you've seen. I'm using a loop to copy an entire row to another sheet if a criteria is met but my code keeps pasting the data into the same row, overwriting the previous entry. Not sure if the EntireRow.Delete argument...

Hi I've currently got a data sheet similar to the one below. The data sheet gains multiple rows each month as each new reporting month is added. The column positioning also changes each month. However the title for each range is the same each month. I want to be able to use VBA to search for...

Hello, I can't seem to get my module 8 to paste the values of Sheet1 (workbook where the VBA code is) onto another workbook's cells, I will briefly explain my code: I have three workbooks, one workbook (with Sheet1 being the "Operator" sheet) where the VBA code is written in, and another two...

Hello, How can I quickly copy the date of birth for a person who is in multiple rows? I basically have more than 6000 individual records to go through. Column A Column B Albert Ross 29-Mar-1980 Albert Ross Albert Ross Ben Davies 20-Nov-1985 Ben Davies Chloe Bart 3-July-2000...

Hello everyone, I'm going to complete my simple application relating to creating new workbook, copying data sets from the workbook where I run my macro, pasting the set to the new one with possibility to point out a path. Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As...

Hi I need to loop through a column and based on whether the value starts with a number, copy this value to the cell to the right of it and append any cells below it which are not numeric and then repeat when you find a cell where the first value is numeric again... to get the results as per...

Hi All, Need a help in copying the formula from database sheet cellAA3 to all the sheets in excel workbook in cell AA1 1) I have VLOOKUP formula in cell AA3 in databasesheet. 2) Need a macro to copy the formula from Cell AA3from database sheet and paste in all the sheets available in...

Hi guys, I have data from multiple sheets that i need to compile together and need to paste onto a Master copy. I need only the data of column O from each sheet. i want to paste all the data including the blank cells as the cells in the first 2 sheets are blank but i still need to display it on...

Hi, Thank you for taking the time to look at this. I really appreciate it. I've inserted the code I used from TheSpreadsheetGuru below (I only changed the worksheet and the ranges). It all worked perfectly, initially. But then I changed the range to include columns E through X (not just...

Hello, What I am trying to do is copy a "Set" of data from one workbook ("SourceWorkbook") to another workbook that contains an invoice template sheet ("TargetWorkbook"). I will now define what I believe is necessary in order to understand what I am trying to accomplish. SourceWorkbook -...

Hi, I have lots of word documents in a file structure. They all have the same layout which consists of three text boxes on the first page. I would like to be able to copy the text from the third text box of each word document into excel along with the file name. Alternatively if it is easier it...

I want to create a workbook for bank reconciliations. The first worksheet is a summary sheet, then I would have a worksheet for each year I am reviewing for bank accounts, and a worksheet for each for credit cards. I want to have a macro that prompts to ask how many accounts for each worksheet...

Scenario: 1. I paste a number of text lines in Sheet1 starting in A1 (only one column) 2. In Sheet2, in Cell H1 I use a COUNTA function which tells me how many lines I added to Sheet1 3. I have a formula in Sheet 2 cell B1 that looks at line 1 of the text I added in Sheet1 and returns a...

I have a set of code working but it can only copy a column at a time, as shown below: x = Range("A" & Rows.Count).End(xlUp).Row x = x + 1 Sheets("CSV").Range("B" & x).Copy Sheets("Sheet1").Activate Range("A1").Select ActiveSheet.Paste Application.CutCopyMode = False So i was wondering if the...

Hi all! Another day, another problem.. Here is what's going on: I have an excel where there are two sheets. Sheet 1 contains Phone numbers in Column X in the following format: 050-7080-6030. I need to copy this to Sheet 2 while at the same time removing "-" (I achieved this by creating a table...

Hi Everyone, So I have a series of columns. One contains a time stamp for a data point, the next is the data point, the one following that is a conversion from decimal to binary for that data point, and the remaining columns are that binary string split into each bit. It looks like this: Gyazo...

Hi All, I have a data sheet with various project Managers names nearly 100 project managers.I want to write a VBA code to filter the data for each project manager and create a new workbook and copy the related data of the project manager to the created work book.And please make a note that the...

Hi, I am looking for some help with developing VB code for the following steps for a financial model: (1) inputting a number into a cell which defines a scenario of assumptions (there are 5 scenarios i.e. scenario 1,2,3,4,5) (2) running a procedure to calculate the Interest during calculation...

I need to know how to copy pictures (that will be changed often) from one main worksheet to other worksheets within the workbook. Everytime I try the pictures name changes so the marco fails or copies the picture over the other one, need to know how to delete before pasting also.