paste special

Hi All, I have scanned this forum a few times over the past few weeks and have found lots of handy tips to help me with a spreadsheet I've been working on for a Football Predictions League that we do at work. I am hoping that someone may be able to give me a bit of help with an issue I have...

Hi guys Hi pivot table and chart. I'd like to copy the pivot chart onto a new sheet and edit it (titles, and so on), as well as not have it linked to the pivot table anywmore - so if I make changes to the pivot table, this chart should not be affected. If I pase special using one of the...

Paste special "formula only" does not seem to work. When copying a column that contains data content for a formula and the formula it self to a new column, the paste special function pastes the formula and the data to the new location. I expect the paste special function bring the formula...

Hello, I have a worksheet that contains cells with VLookup formulas, however I need the actual values of the cells to be used by other formulas in the same worksheet. I decided to use FillDown to drag all formulas (including the Vlookup formulas) one line below and after that copy and special...

The following piece of code works. However, before performing the loop, I would like to select the range where I am placing the array formula and paste is as values instead of leaving the formula in the range. Sub Macro1() Range("A1").Select Do Range(ActiveCell.Offset(1, 0)...

When I copy/paste special/formula, I don't want a certain part of the formula to change. Column A Row 4 =(12500/Data!C$17)*(OFFSET(Data!C$19,(ROW(A1)-1)*9,0,1,1)-Data!C$17) Row 5 =(12500/Data!C$17)*(OFFSET(Data!C$28,(ROW(A1)-1)*9,0,1,1)-Data!C$17) For every row of column A I always want...

I'm puzzled. For some reason the "paste special" functionality in excel became permanently disabled. I can still see it but it is grey all the time. Can someone assist with some advice?:confused:

Hello, Could anyone help me with this one? I wans to copy all data from column H, then Past it as values to Column I, then next time i press the button for column H data to paste specail to Column J and so on - so it keeps adding the data to the next column automatically. Can anyone help me...

Using Excel 2000, WinXP. I want to write a macro that does a Paste Special Add or Subtract of a stored constant (1462) to a selected range of cells with dates in them. This is to convert between 1900 and 1904 date systems (i.e. Win Vs. Mac). Here's my simple effort (below). It doesn't work...

Dear Sir, I just like to ask, is there any way to paste speical (only value) with the help formula. we dont want to use mouse right click then select special paste. .we want to past only value by fomula, is it possible? pls help. Thanks

Heya, I'm trying to incoperate "paste special" in my VBA-code and used "macro recorder" to figure out how to do so. However, when I try to run the so developed code it gives an error :eeek: I have no clue why :confused: CODE: Sub Ooops() Sheets("JD").Visible = False...

Hi My Problem is Error 2015, I always get this error whether there is data to paste or not in the following code. Sometime ago I got a bit of help with this and thought I had it licked however I seem to have some further problems. Sub PastSpec() Application.EnableEvents = False On Error GoTo...

Hi All, I am trying this to paste formula as value but its not working as my data is filtered and its selecting a range. could you pls help me if i want to paste cells one by one in a filtered sheet. Sub Pastespecialvalue() Dim a As Integer Selection.SpecialCells(xlCellTypeFormulas...

This is a macro I found and I have modiffied it to fit my purpose with the exception that I don't know how to make it "paste special". I don't want to copy the formulas, i just want to copy the data. Sub HistoricalData() Dim TargetSht As Worksheet, SourceSht As Worksheet, SourceCol As...

Hi i have no idea where to start with this one... i need to open a specific word document from excel. Copy and Paste Special/Link from word back to excel Thus when the cell link in word is changed so is the excel document. I have to have it this way round as people will be editing the word...

Hello all. I'm working with lots of data (on a number of sheets) that I often need to do multiplication on. At the moment, I'm just typing, say, "100" into a cell and using paste special > multiply to change them all. Is this the most efficient way of doing this or is there an easier way that...

Hi All, I've searched all over the internet and not found an answer. I need a macro which will read the cell I have linked to, copy the formatting and paste it into the current cell. All cells in the sheet will be linked to another source. Each cell in the source is linked from multiple cells...

When I try to use 'paste special' I do not get the standard window with the two areas 'Paste' and 'Operations' and the option of 'Transpose' which is what I am wanting to use. Rather I get this window with the same title of 'paste special' but in the upper left it says 'Source: Microsoft...

I've searched the board and not found what I'm looking for. Here's my "Comments" issue. I have a single workbook with 4 worksheets in it. This is a dimensional report sheet. We measure stuff and report our findings. The first worksheet is the master sheet. The next three sheets are...

Quick question here: If I want to copy a cell (say... the input sheet, cell C4) and paste only its value somewhere else (say... the results sheet, cell B4), is there a better way to do it than [C4].Copy Sheets("Results").Range("B4").PasteSpecial Paste:=xlPasteValues, Operation:= _...