paste as values

I have a small range of cells that have a custom validation that prevents entry when another cell is true. I have users copying from a web page and pasting into these cells and therefore overriding the validation. I've spent hours reading forums and trying various codes, probably in the wrong...

I have this problem. I want to create another workbook and paste the values of specific starting cell and select down to the end. Then, I want to copy the values starting at cell AP41. the sample output was shown in the picture output1. in my source file, I have 100 sheets, I want to loop on the...

1st time I've posted a question anywhere, so please excuse any lack of info or etiquette. I have 2 worksheets, the first is a form to fill out, the second is an order history. The second sheet will capture all the data filled in on the first form. There's a list of job numbers on the order...

Hi all, I have a macro that is doing exactly what I want, however, I've become aware that Activating and Selecting is bad practice, and I want to do this right. I believe this section is also causing screen flicker and a 'disappearing' userform when calling this from my userform. I'm...

I have a form on one sheet that I'd like to copy the values only of these to another sheet named "New Log" Problem I have is I've named all the ranges that I'd like pasted and I need to paste all of these into the log at the same row then move down 1 row ready for the next submission I can...

Hi, This is my first time on this forum, so maybe I’m posting an issue of which the solution is too simple for words. I sincerely hope that this is the case ?. I made an Office 365 Excelfile in which a person has to register some data. Because I put some formulas in the file (worksheet) he/she...

Good afternoon, I am struggling with a pivot table that I am running - the source data in it's original format is a set of index/match arrays, with an IFNA to tidy things up a bit (eg {=IFNA(INDEX('Learning Data'!$L:$L,MATCH($B2&F$1,'Learning Data'!$G:$G&'Learning Data'!$K:$K,0)),"")} I have...

I have a workbook that is used daily to keep track of new data coming in each day. The "Summary" sheet uses formulas determine the day and then pull relevant data from other sheets in the workbook to track historical data, going all the way back to 2016. To prevent the formulas from slowing down...

Sheet1 contains a source table (its size changes every Qtr) and sheet2 contains an index table, containing 'ProfitCenter Name' and 'Analyst email' headers. (1) I am trying to filter the source table in sheet 1 each time according to a specific 'ProfitCenter Name', then (2) copy the results and...

Hello, I have always used the following keyboard shortcut in Excel 2016 to copy cells and 'paste as values': Copy - CTRL + C Paste as Values - Right-Click button on keyboard + CTR + S + S + Down button to select 'Values' + Enter This shortcut is deeply ingrained in me. Suddenly this shortcut...

I am working on a macro that needs to be able to pastedata into a table. The macro does several different filters and after eachfilter the results should be copied and pasted to a table. The issue I amhaving is the table it is copying to starts on B17 (there are blank rows andother tables above...

Hello all. I have a "Model" tab with data starting on row 101 and running down to a row which depends on what data remains after a previous Macro deletes out superfluous data. On a "Summary" tab I have a template that needs specific columns value pasted out of the Model tab into columns on the...

Here is my whole code. A lot of it is very similar, just using different variables, but I kept it in for context. It's dealing with around 210,000 rows, and 11 columns, 7 of which are in-macro formulas (see bottom of code) which are copied then pasted as values. Basically, it was fairly fast...

Please help I have searched the web and tried every solution I have found, none worked. I am trying to copy a range of cells, say T2,AB5 to another sheet. Problem is I don't know where this well appear so have to set a variable. It may appear several times throughout the data sheet. each...

I was using this code which Andrew Poulsom posted back in 2002. http://www.mrexcel.com/forum/excel-questions/63213-visual-basic-applications-code-copy-worksheets-paste-values.html It works great, but I want it in my own Personal Macro workbook. When I place the code in Personal it no longer...

My setup: (2 Workbooks) Workbook 1 "Line Audit Workbook", Workbook 2 "Data" Workbook 1 has 2 worksheets - "1st Shift" and "2nd Shift" Workbook 2 has 1 worksheet - "Data". In workbook 1, both worksheets are set up identically with 13 columns. Each shift (1st Shift and 2nd Shift) gets information...

Hello everyone, I am facing an issue with copy/pasting a formula as values which results in my pasted value being incorrect according to me. This is what I did: value 503 in A1. value 1.14 in B1. value 573.42 in C1 (outcome from sum A1 * B1) Value 0.42 in D1 (outcome from sum A1 * B1 - C1)...