paste special

Hi, I'm sorry if this has already been answered - I tried searching but couldn't find an answer. I found a macro on the internet that automatically pastes images from a folder into column A of my workbook. (I work in publishing and am creating a catalogue with ISBNs in Column B, all the images...

I can not seem to be able to copy & insert/past. I also can not seem to copy a set of rows with formatting & formulas, then when I paste to a another row, it drops the formats & formulas. When I attempt the paste special, it only gives me the option to paste text. The only option I know of...

Hi everyone, You were recommended to me for help solving a really frustrating problem affecting myself and some of my colleagues. Thanks in advance for your help! Basically, the Paste Special menu is greyed out on our spreadsheets, in whatever file we open, so you can only copy and paste in...

Hello, This is an Excel 2007 and Excel 2010 question (I use both, and guess the answer will be basically the same for both): In the same way I can paste a value into formulae with "paste value", is there any way to paste a cell reference? For example, I've attached a simple example below...

I have "lost" the normal 'paste special' feature in excel 2007!!! When I click on the paste special feature it presents a dialog box allowing paste as "unicode text" or "text" ... rather than pasting formulas or numbers or transposing. Any suggestions to get back to normal ?? Thanks

I'm doing a ton of corrections for mixed up information. Is there a function that will cut and paste a cell's contents and automatically push the destination's cells contents to the original cell that you cut from? i.e. - Swapping contents... if that does exists, I'd assume I could assign a...

Hi, I encountered problem when using code to copy&paste charts as enhanced metafile from one sheet to another. Programme is not responding for quite long time then it diplays 1004 error. I suppose problem is in the line: ActiveSheet.PasteSpecial Format:="Picture (Enhanced Metafile)"...

Greetings, I have a spreadsheet in which we sometimes need to insert a row right in the middle of a bunch of filled-out rows. I'd like to have the inserted row contain the same formulas and conditional formats as the other rows, but not copy the text/values. I've tried a few things but...

Hello, I have a group of cells that I can't add a value to using the paste special add value function. I have reformated the cells from text to general also to number. I have tried text to columns and nothing seems to work. I can do it to other cells on the same sheet. The data and formating of...

i have multiple excel worksheets (12) 11 of which use data queries 1 for a master list. the Master list is programmed with 4 VBA buttons, 1 to clear the list, 1 to extract the data from the other sheets making a new list, 1 to format the list, and the last 1 to add formulas (IF functions...

I have a multipage work book (xlsx) and a single sheet powerpoint document. I have pasted data from the workbook into the pptx using paste special/paste link/object. Having saved both in the same location, once I reopen the pptx and click "update links" I receive the following message; "Some...

Hi All, I have been searching this and other threads to find a solution, but could not find exacly what I am looking for. I have data as shown below (Sheet name : "Input") : <TABLE style="WIDTH: 336pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=448...

Hi there, I have a standard template in PowerPoint (A4 sized) which I populate with a series of tables and charts generated in Excel. I tend to copy then paste special to create an excel linked object which is fine. The problem is that when I paste the item PowerPoint tends to resize it...

I have 3 excel workbooks. I am attempting to link a chart from workbook1 to workbook2 by the paste special method. Workbook2 already has a linked chart in it from workbook3 and works perfectly fine. But when I link a new chart from workbook1 to workbook2 only a blank object appears. The...

We recently installed Office 2007 (from 2003) and many of my colleagues are having the same 'paste special' problem: - In 2003, we could color code excel data (e.g., blue, red, green) and then paste an enhanced metafile into powerpoint and the chart would show black and white text, as desired...

I have been kindly supplied with the following code that allows the Document User to define the number of rows to be inserted in a Worksheet. Currently this code copies row 3 and pastes it the defined number of times beneath the last used row. However I would like to tweak the code so that...

Hey Guys, First time post, Not sure what is going on, Happens all the time but usually just drop it and try something else... I am trying to copy a range of cells and Need to transpose the values. Easy Enough? When I right-click and paste special, it gives me a new window with an array of...

Hi all, I've got a complex workbook with lots of linked data - on one sheet there are 8 fan charts showing financial data. When I paste the charts as pictures into Word 2007 , everything is fine. This is all on XP. However, when I try to paste special them as linked Excel Chart objects, 4...

Hello, I'm using Excel 2007, and I'm looking to create a macro that searches P4:P542 for all values which include an integer greater or less than (but not equal to) zero. For each value it finds, I would like it to copy and paste special the contents into the cell below it. I'm fairly new at...

I am trying to copy a set of filtered data into a PPT presentation. I am copying the selection, then using Paste Special to create an object in PPT. When I open the object, most of the data that I copied isn't there. It appears that the rows in the object are still filtered, but there's no...