copy & paste

Hi, What I'm trying to do is to copy data from a sheet (named Data Source, cell K68) and then paste that data as a value into a second sheet (named Reference) in a specific cell based on an index match/match (indexmatch('sheet 2'O28:V63,match(sheet 1 H67,sheet 2 N28:N63,0),match(sheet 1...

I have some basic VBA code to copy my defined table range (Copy_Data) from one sheet to another. The table updates values based off of Cell A1 on Store Data tab. I have a list of every store number I would need to manually go through and plug into A1 so it can recalculate the table and then copy...

Hi. What I am currently trying to achieve is to copy specific cell values between dynamically named workbooks. I have found the following code which works to some extent, but I get formulas transferred in to the receiving workbook in stead of values. Sub import1() Dim sFilename As Variant Dim...

Hi all.. My first post here.. I need your help. I have a folder with hundreds of reports. Each report has the report name in cell A1 and all the column headers in row 4 (normally from A4 - CR4 but this can vary). I am trying to create a data sheet for all the column headers for each report which...

Hi and Happy New Year I'm trying to create a macro with the purpose as follows: Open a specific file based on a path in a list (Path, coloum B), copy data in the file from an area (A1:AO5000), paste it to a specific sheet in the Masterfile, sheetname comes from SheetName, coloum A, same row as...

Good morning everyone, I am making a new sheet to use at work so that multiple users can record any errors or issues on the production floor into a "log" that can be referenced later. Filling out the text cells and having them transfer, NO ISSUES whatsoever. Something I'm trying to implement is...

Hi everyone. I'm still new to VBA and running into an issue when trying to create two functions that take a parameter to find the defined range and then copy paste that range into a new sheet. Why am I being thrown this "PasteSpecial method of Range class failed" error in my copyRange function...

Greetings, Need some help with an automation script - possibly a loop with variant arrays? Couldn't put it in practice, but it seems to be the consensus for faster data parsing. I've got a convoluted 25 sheet workbook that we use to determine the price for certain products. The Product Names...

Hi! I'm stuck creating a macro to copy a range containing formulas and then special paste just the created values into a new sheet. I've run into a problem where the entire range is being copied but the "" values in the new sheet are being pasted and read as a value. So when I try to import the...

Hello Guys, Hope all is well. I have a sheet with more than more or less 100k lines. I need to trim the data first by omitting rows with "0" or blank as Value in Row R (Sheet 1). I found below code but it's taking much time probably because the file is too large. Sub DeleteRow() 'DeleteRow ot...

I'm trying to create a macro that will compile specific columns from all worksheets in a workbook into a single new worksheet. What I have so far creates the new sheet, and returns the correct headers for each column, but copies across all columns from the existing sheets rather than just the...

I would like to develop a VBA that automatically copies entire row info from specific row on Sheet1 and pastes it into next available space in table on Sheet2 based on date info in column G (any row where date is older than 60 days/highlighted in red). Table in Sheet2 is virtually identical to...

Hi, I have searched in many forums but don't get the best result the suit to my problem. I have two worksheets of a workbook. One is the "Data" and the other is a "Calculation". First Condition: When I select any cell in between Column I8:I1220 of the Data Sheet, the cell value is immediately...

I created a button that takes selected table, copies and pastes it into an email between a note & my HTML signature. Here is the code that was working yesterday but isn't today. ???? Sub Mail_Outlook_With_Signature_Html_1() Dim outlook As Object Dim newEmail As Object Dim xInspect As...

Hello all, Need your help. I am unsure why the below is not working. All I am trying to accomplish is to lookup a value in column A, find that same value in Column A on a different sheet, and copy the data from the first sheet in Column G:O to the same G:O range in the second sheet... When I...

Is it possible to copy a word from multiple cells to a new location, but only if that location is blank? Let me explain; Column C in the sheet is labelled Competition. If the selection is a football match, then the league is listed here, ie Norwegian 1st Division. If the selection is a horse...

Hi, I have been using this macro which is copying everything (formulas, formatting etc.): Sub Macro_1() For Each ws In ActiveWorkbook.Worksheets If ws.Name = "ß_PCF_1" Then ws.Range("B3:M100").Copy Sheets("ß_PCF").Cells(Rows.Count, "b").End(xlUp).Offset(1) End...

Hi Everyone, Would like to ask an easy way where I can easily list the information in rows into column list. Thanks! Current Data In actual, this composed of around100 data rows Note: Column A Column B Column C Column D Column E Column F Column G Column H Row 1 Order1 APPLE BANANA...

I am trying to create or find a VBA code that will allow me to copy row 1 on the sheet and paste the entire row in each blank cell in range A3:A177. I have data in random places throughout, so I can't put just every so many rows or cells. I need to run this macro after pasting the information on...

Hi Gods of Excel, how are you ? ? Guys, I took this formula from one place and try it works perfect. It can copy files from one folder to another, but I want to update it and add color in cells which were copied something as indicator ( fore example green color). Is it possible ? Example...