copied

Hi all, I am trying to insert copied cells into another spreadsheet based on the value changing in column A, if it changes the rows are inserted underneath the 1st value and before the 2nd value. What I have currently is the below however I am seeing some anomalies. The codes is activitate...

Hi all, So I am currently copying data from one sheet and pasting it to another. The data on Sheet 1 is pasted vertically and all over the place (ie: Rows 16 through Rows 19, then Rows 125 to Rows 130). Then I have different rows being copied under different circumstances. So continuing the...

Hi-- Major senior moment-- I need a macro to copy the last n rows of a range (A:I) to another worksheet. It needs to be dynamic (might be last 10, might be last 27, etc.) On the worksheet the data goes to, it should always paste to A3 so it will update/ overwrite the previous data. Ex...

I have data that is copied to a sheet called "Overaged Inventory") using a macro which copied the data perfectly once I copied would like a macro set up to create a pivot table in cell M1 onwards However when running the code, I get invalid procedure or call and rghe code below is highlighted...

I have seen a number of similar threads on this subject, however I have a variation. I have a sheet with 211 rows, each row needs to be copied and inserted multiple times. The number of times it needs to be copied is in a cell within each row (Col G). So The first row has the number 14 in Col...

Hi, I want to copy the pivot table data to a new work sheet along with values and formats and the new sheet should be a normal sheet.Later ones copied the pivot data to new sheet,the original pivot sheet needs to be deleted. I have tried many options but empty data is observing in the new sheet...

Hello, I was thinking about the VBA macro for exporting a range from Excel to Word document. Following macro seems to be doing it, although I have a problem with the pasted size. The data copied from Excel is too big for a Word document. Is there any way to adjust the copy/paste size, so copied...

Hi, I am using the below code to copy cells from a list in the active sheet if they contains the same value as "K1". I then call another macro (Sheet_Select) to select the sheet that is named the same as "K1". When the sheet is selected I am pasting the copied cell to "A36". This works but...

If Column C has a certain name I would like that name to be copied over to Column A. I am unable to just do a copy and pasta as I do not need every name copied over to Column A. So for example if Column A has the following number 12345 and Column C has the name Jane Doe than I would like to...

I have been working on a spreadsheet for months. This spreadsheet involved filling out information in a table, upon finishing, it would be copied to another table on another sheet, where further information would be added. Once this had been done, it would be copied to another workbook. The way...

I have following code to search through a column to find matched text string....value (in next column) is then copied into first available vell in column C Set mycell = Sheets("Sorted Data").Range("A:A").Find(What:="*ASDASTORESPLC*") While Not mycell Is Nothing mycell.Offset(0, 1).Copy...

I have written the following code to select files to be copied once I select a file it appears in the message box I would also like the file name selected to be copied into Col A from row 2 onwards on sheet "Macro" or e.g. if BR1 sales May 2019.csv is selected first, BR2 sales May 2019.csv...

I have a 2 files already open In file #1 , cell B3 contains a date/time: 5/4/2019 12:30:00 AM I want the data in cells B3:I40 of file #1 to be copied into the same cells in the second file and into a tab named after the date found in file #1 . So if B3 of File #1 contains 5/4/2019 12:30:00...

I have searhced a lot but have not found any vaible solution for this. I want to know if there is any macro for this I have a list of columns in sheet 1 like this Group a Group B 123 456 231 415 122 313 122 122 in Sheet 2, if cell A1 = "Group a"...

With using only cell formulas ... (the company does not allow files with macros) Is it possible to copy the value (text) in cell A1 to B1 ... if the value of cell F1 = 5. In truth, if F1 = 5, then the value of cell A1 needs to be copied to cells B1, C1, D1, E1. Thanks for any help. RJW

So I have hit a brick wall with my project I am working on in Excel. Here is my scenario for example I have a worksheet with a list of 17 questions with answers based on a validation list. My client would like to have the answers copied over to Sheet2 which is not a big deal however they want...

Happy Easter! I have a chart on one sheet and need to copy an image onto a second sheet. I copy the image into a cell and then want to nudge it slightly. My problem is being able to identify the chart I want to manipulate after the copy operation. I copied some code for a function that gave...

Hi, I have been using a sumproduct formula for some years, and although it works fine I was wondering if there was an alternative way of getting the same result. In C8 copied down =SUMPRODUCT(($A8>=$A$3:$A$4)*1,($B8<=$B$3:$B$4)*1,($C$3:$C$4)) to show how many are in each hour <tbody> Start...

I don't know how to write VBA code very well so someone has been helping me with this code. The code is meant to copy the rows from the table in the quoting tool to the table in the costing tool. Here are some specifics Quoting tool Table Name: npss_quote Sheet name: NPSS_quote_sheet Costing...

Hi, Apologies if this type of solution has been posted elsewhere - I have been attempting to use a variation of the solution provided under https://www.mrexcel.com/forum/excel-questions/873522-vba-copy-paste-row-while-replacing-2-cell-values.html What I'm trying to achieve is having excel look...