paste values

Hello, I'm fairly new to code but can usually problem solve my way to getting it to do what I need it to. I have been trying for days and have not had any success modifying scripts to get them work. HELP! This is what I'm trying to accomplish: 1. Copy "A4" and "B4" in sheet "DataEntry" 2...

Hi Guys I've encountered a problem which seemed fairly easy to resolve and has now resulted in me tearing my hair out! I have a worksheet which hides and shows cells based on user input, fairly simple, lots of code, but works well. At the bottom of the worksheet there is a button to "Copy...

Hello, I developed a template for my office that eliminated redundant data entry by referencing another spreadsheet. I've created more than 500 files from that template. My supervisor recently expressed concern about the files pulling incorrect information if the reference spreadsheet is moved...

Hi Excel gurus, I have an Excel 2010 spreadsheet with two main tabs "Input", and "(HIDDEN) RAW DATA". "Input" has a row of data (range = CA3:SY3), which I want pasted into a table in "(HIDDEN) RAW DATA". Cell "Input!BZ3" contains a person's name, which is variable (dropdown). "(HIDDEN) RAW...

Morning, I am trying to merge several worksheets from different workbooks into a master workbook. Because the users of the source workbooks aren't particularly skilled at excel, I like to use the paste values method to avoid copying unintended data into the master (like external links, named...

Hello All! This has been bothering me for a while. I work with many large, data-heavy models. Many times I need to paste in values from outside files into these models to keep them up-to-date. When pasting values into these models, some function perfectly fine when the Workbook Calculation is...

I am desperate need of assistance. In order to avoid a circular reference error, I need to copy/ paste special values from one cell to another cell if there is any change in the value of the original cell. For example: Copy-paste values from $P$32 to $P$23, if value in $P$32 changes. Some...

I'm using an Index/Match array formula to pull out results from a data table (based on three search criteria). The formula works great, except that it populates the results in the same order as the data table - I want to sort them based on another category. My data table is on Sheet 1...

Hi, im looking to create a something with VBA that will allow users to copy (values only) to the clipboard. I know all about Paste Values however Paste Values does not work in other programs we use here at work. (Lotus notes, Java forms, etc) I can easily come up with the code to "copy" the...

Hi all I'm running a macro in Excel 2010 that filters unique values, does v lookups and simple calculations then pastes a table from a temporary sheet into a permanent sheet. I am repeating this process 14 times in total. However, it will only work for a maximum of two iterations before I get...

I fell like this is an easy answer. I am copying cells from 1 worksheet to another if a condition is met. My code is working but it is pasting the formulas from the cell instead of the value of the cell. How can I modify this code to paste the values? Private Sub Worksheet_Change(ByVal...

I am having trouble creating a macro that pastes values after I have manually copied a cell/range of cells. The ultimate goal is to create a shortcut so I can select any cell, press CTRL + C to copy, and then go to any other cell and press CTRL + "macro shortcut" to paste values. I need paste...

I am currently working on a macro to move specific rows of data from various sheets in a workbook onto a data sheet in the same workbook. I'm using the below code that I lifted from an old post and modified slightly; Sub cpynpst() Dim sh4 As Worksheet, sh5 As Worksheet, lr As Long, rng As...

I have a workheet which I use "sumproduct" formulas to pull in new data every week. Within the worksheet there are also "sum" formulas that gives subtotals in certain sections. I want to create a macro that pastes values over the sumproduct formulas without pasting values over the sum formulas...

Hi I need to copy and paste the values of certain columns from one workbook to different columns in another workbook. See my code below.. I know this code is not efficient, I am new to VBA and would appreciate any help to make my macro more efficient.. I could start copying from row 2 instead...

All, I am trying to find a method for converting all cells in entire workbook starting with the formula "=cc." to values. This is what I have so far. Sub Do Until IsNotFound Cells.Find(What:="=cc.", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart...

Hi I've got some external data in cell M7 and need to copy the values to another cell. I've recorded a macro that refreshes the external data and then copies and pastes the values. When I run the macro it copies and pastes the old values while the external data is refreshing. The code look...

The code below works fine to open another workbook, copy data, then paste into the original file. However, I need to paste only values. I have tried a couple different ways of doing it after the fact (ie after pasting data formulas and all), but nothing has worked and I would prefer to just...

I have a column of dates pasted into my spreadsheet in the form of " 13APR12 AU" in Column A. I have used 2 helper columns with "=LEFT(A3,LEN(A3)-3)" in Column L and "=RIGHT(L3,LEN(L3)-3)" in Column M to get it into a format that Excel should recognize. I copy Column M and paste values into...

Objective: Multiply a subset of rows by a constant * Filter a wall-of-data to show a subset of rows * Copy (Ctrl-C) af static value in a cell * Paste Special Value Multiply ... the range of filtered data Result: Filtered-out values are also (sometimes? always?) multiplied. Is this a bug...