paste as values

  1. C

    Pivot Table reading blank cells as populated...

    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...
  2. J

    VBA to select rows before today's date and paste as values

    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...
  3. A

    Filter a table using a different name each time and paste the results as values in a new file to be emailed

    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...
  4. M

    Paste as Values Shortcut Not Working

    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...
  5. L

    Find and paste data into first blank row in table

    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...
  6. A

    VBA to Copy Specific Column on One Worksheet and Paste Values to Specific Column on Other Worksheet

    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...
  7. J

    How to speed up a macro handling a large amount of data?

    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...
  8. L

    copy past range using variable for start cell address and 2nd variable for end cell address

    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...
  9. R

    Copy/Paste Values entire Workbook

    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...
  10. K

    Copy rows from one workbook to another workbook if certain criteria is met

    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...
  11. B

    Paste as values changes the outcome of formula...

    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)...

Some videos you may like

This Week's Hot Topics

Top