Over 1 million tech questions and answers.

Unable copy and paste column or row in Excel 2010

Q: Unable copy and paste column or row in Excel 2010


When I copy a column or a row and insert it, excel inserts it but it vanishes in a split second. When I copy a column and paste it (not insert) it does the job but it is overwritten that I don't want to do.


Thanks in advance

Preferred Solution: Unable copy and paste column or row in Excel 2010

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Unable copy and paste column or row in Excel 2010

Can you explain more?
Your explanation does not say anything about what and how you'rw doing it
Does it happen with every Excel file (new blank ones) or with one inparticular?
Do you have any special Add-Ins installed?
Have you been testing m,acro's that influence the right-click mouse buttons?
Please try and paint a complete picture so that the reader has information to troubleshoot and help.

Read other 3 answers

Excel 2010 (and 2007) VBA code copies and pastes ChartAreas without problems until a Range is copied. Then the ChartArea copy-paste code fails (Title & Axes do not change; PlotArea is blank). The same code works fine in Excel 2003. Help.

Read other answers

Excel 2010 randomly freezes during copy/paste function. Did not happen with earlier versions. Have to get to Task Mgr and shut down apps & lose any changes. dumprep is often running. Tried starting in safe mode, still happens. Work PC and can't change user. Notice that the clipboard is popping up in bottom right of desktop. Didn't use to with earlier versions. Could the clipboard or macro be causing it?

A:Excel 2010 freezes during copy/paste

here is a link on how to disable the clipboard from showing up all the time (but i don't think this is related to your problem.are you using Remote Desktop? - (there are reported issues using the clipboard with Remote Desktop.)how much are you copying to the clipboard? can you copy to clipboard in MS Word?sounds like a memory issue; since it's a work computer, can you have IT look at it (suggest a memory upgrade)?

Read other 4 answers

Hi y'all,
I'm about to start banging my head on the desk! I've asked this question in multiple forums but haven't received any answers.

I'm using the "Marlett check boxes" rather than the checkbox from the form toolbar. So, rather than doing an onclick or anything, I thought it would be easier to just search the column for the letter a, which is what you type when you want a checkbox while in the Marlett font. But the rest of what I want to accomplish may as well be Klingon, I cant make heads or tails of it.

I'm basically doing an auto-ish grocery list with coupons. I've got one workbook, tab A=Master List, tab B=Shopping List, tab C=Coupons. On Master list is a page full of categories/sub-cats (beans/grn bns, cereal/Cheerios, etc.) with a "checkbox" next to it. (A,B="checkbox", item). Shopping list is blank except for the headings & outline. Coupons is running list of all of the coupons we have available.

Ultimately, my goal is to have Shopping List insert items as follows: When I click a checkbox on Master List, it should automatically insert the item sub-category (Cheerios) into the item column on Shopping List. Once an item is listed on the Shopping List, then I'd like it to scan Coupons for the sub-cat (Cheerios); if a coupon is found for that sub-cat, I'd like the info to be copy/pasted into Shopping List. If there is no coupon, my Shopping List would just show Cheerios, but if there is ... Read more

A:Excel 2003 - Look for "a" in column, then copy/paste

If you change the font to say aerial from marlett that will show the "a's"

That might be a start


Read other 1 answers

I have a list of 39525 emails in column A and a list of 19909 emails in column B. If an email exists in column B that also is in column A I want it removed from column B. PLEASE HELP! THANK YOU!!!!!!

A:Solved: Excel 2010 - Remove duplicates from column B that exist in column A

Read other 9 answers

Hi Rollin_Again and everyone in this forum,

Hoping someone could help me in my problem.
I have a workbook in Microsoft Excel 2010 (Windows) of about 60.000 rows of words in different languages.

Some words have 5 different languages and some are only 4 or 3, all are written in Column A of the workbook.

Column A
English -------(in color Orange)
Spanish -------(in color Red)
Italian ------- (in color Blue)
German ------ (in color Black)
Papiamento ---(in color Green)

What I want is a Macros Program that can put all Spanish words (red color) in Column B, all Italian words (blue color) in Column C, all German words (black color) in Column D, and all Papiamento words (green color) in Column E.

Like for example:

Column A --- Column B ---Column C --- Column D ---Column E
English -----Spanish ----Italian ----- German --- Papiamento

Thank you very much in advance and I'll appreciate all the helps you could give me.

A:Transfer texts from Column A to Another Column, Excel 2010 (Windows)

Read other 9 answers

I have been using Microsoft Office Excel (2007) and the copy paste, copy Special paste functions have worked fined. Recently Copy paste does not work every time, the cell that I am copying from does not highlight and when selecting paste, nothing is pasted. When selecting Special Paset, I don't get all the options for copying All, Formulas, Values etc, I only get the option to Paste as Unicode Text or Text.

I tried the copy paste function in Word, this works but does not copy the format, only text is copied. I have restarted the computer, but this does not change anything. These functions have always worked in the past, this has only become an issue after I installed Firefox on my computer. I don't know if the two are related or just a coincident.

Before I re install MS Office, I would like to see if this can be resolved

Any support with this is appreciated.


A:Copy & Paste and Special Paste function in Excel does not work

I have moved this thread to the Office Forum for better results.

Read other 1 answers

I have office 2010 pro. I want to know if I can create a Line number column that will incrementally number my rows for me.

I often go thru excel to get a vendor invoice into a format that can be imported into my accounting program and one of the required fields is line number.

The spreadsheet uses row 1 as headers so the invoice data starts on row 2 but would be line 1.

I think I stumbled across it accidentally once but I didn't try to figure out what I did. Sigh!


A:Creating a Line Number Column Excel 2010

so if you put the number 1 onto row two - say A2
then in A3 you do
and copy that down - you will get and incremment all number
or just do
A2 = 1
A3 = 2
highlight the two cells and drag down should auto increment if excel set by default

can you attach a sample spreadsheet with dummy data showing what you need

Read other 2 answers

Recently when i go to Copy and Paste, it pastes the item I copied prior to the new one. This is rather frustrating as well - for example, I just copied an email address from my contact list and went to New Mail and pasted it into the TO mail BUT what appears is the item I copied the prior time - any suggestions? Windows 7 - Firefox - Outlook 2010.

A:Outlook 2010 Copy and Paste Problems

1. Do you use the keyboard shortcuts for copy, or is it happening even when copying by mouse/touch-pad?

2. Is it outlook only, or does it happen in other programs as well?

Read other 2 answers

Im really new to using Access so need some help. This is what im trying todo. I have a form in which the user would imput data either writting the info and/or choosing dropdown options. The idea is once all the info is entered the user will press a button at the bottom labeled "Generate Note", a window will pop up showing all the data in a box with every data section separated with "/" (foward slash). On that popup window it will have 2 buttons, one where the user would be able to copy the information in that box allowing to paste in a MS word doc, note pad or another notating program. (FYInce the Copy button is pressed the popup window will disappear therefore reverting the user back to the section in which the data was entered). The other button in the popup will be a Cancel button in case the user may need to return and update their notes.
Again i am really new at Access so please help me out here

Read other answers

In IE the desktop version, work one or 2 time to copy then paste into OneNote, but after that, it show PASTING... at 75% and stay like that.
It alway's come back, even after resetting IE. In chrome I have not that problem.

If I cut paste into Notepad, I don't have that problem.

Read other answers

I am not able to copy and paste text from a website into a new Outlook 2010 email. COPY AND PASTE ARE GRAYED OUT. CTRL C works within the web page. However, CTRL V does NOT paste the copied browser text into my Outlook 2010 email.

Outlook Help did not provide any means of restoring Copy and Paste to Outlook 2010. I sure hope someone can assist for a simple but VITAL need, copy and paste.

I have Windows 7 Professional x64, both FIrefox 3.7 and IE 9 beta.

Your assistance will be very appreciated.


A:Outlook 2010 not listing copy or paste

Hi 53texman and welcome to Windows 7 Forums

Works for me.

In this example, I have selected all of your post above and used Ctrl + C and Ctrl + V to copy and paste.

Here, I have made a selection from my home page and used the right-click copy/paste function.

It could possibly depend on the webpage and what you are trying to copy. Whilst Ctrl + C would appear to work, it doesn't necessarily mean that it has actually copied anything if the source doesn't permit such copying. The fact that you stated that Copy and Paste were grayed out would imply that this is the case. Copy will be grayed out if the source does not permit copying, and likewise Paste will be grayed out if there is nothing stored in the buffer for copying.

What is the site you having this problem with?

Read other 2 answers

hi ,
i want to create a button in excel that when clicked can copy a column say (from A1 to A25)and store it. now i can paste the same either in word or in notepad.
can it be created.

i think bomb #21 CAN HELP ME.

A:want to create button in Excel that can copy a column return the same when pasted

Read other 13 answers


I'm trying to use the Excel 2010 LINEST function with two columns of data. One of my columns contains blanks, so I receive an error. Can I run the LINEST function for these columns, but skip the rows that contain a blank?

I appreciate any help or guidance you can give me. Thanks!

A:Solved: Excel 2010 LINEST Function with Blanks in Column

Ahhh, if if use Slope(), Intercept(), and RSQ(), I get the answers I need without the blanks causing any problems.

Read other 1 answers


I’m trying to work out how I can look at one column in a spreadsheet and display the text in another field but without a load of blank cells in the results column. Let me give you an example.

On Sheet1
In column A are road names
In column B the number of building on that road
In column C the last date and work was doneon the road
In Column D is an =IF formula thatbasically gives a result of 1, 2, 3 or 4.
On another sheet I want four lists

Sheet 2
In column A is a list of road names thathave a value of 1 in Sheet1 column D
In column B is a list of road names thathave a value of 2 in Sheet1 column D
In column C is a list of road names thathave a value of 3 in Sheet1 column D
In column D is a list of road names thathave a value of 4 in Sheet1 column D

I can do this with a simple IF statement in columns A,B,C & D on sheet2 and drag it down but there are a couple of problems with this method.
1, If the value in sheet1 doesn’t match I get a blank cell on sheet2 (as there should be) but this leaves a large number of cells with no value. I need a list in each column A,B,C & D onsheet2 without any blank cells.
2, I’m going to be pasting different data into columns A,B & D on sheet 1 a number of times and the number of rows in will be different each time.

I remember seeing something before thatinvolved using the IF and COUNTIF function in a formula but not sure how.
Any help would be appreciated

A:Excel 2010 separating data from one column to multiple columns

should be able to use an array formula - so use control + shift + enter key and the formula gets { } brackets


where you change the red =1
to =2, 3, 4 for different columns

does that work out

see attached

if it works we can extend the range and cleanup the errors

Read other 3 answers

Excel 2010 - created a worksheet with 2 different pages. When trying to compare or adjust column widths, different units of meansurement are in place;
Cannot discover how to make both the same so I can compare apples to apples.
Have searched both my Excel reference books and read for hours in Help for Excel. Nothing pertinent to my question and no solution evident. This is totally simple/basic, but I don't know how to handle this. Please help.

A:Solved: Excel 2010 - problem with column width settings

Read other 6 answers

Hi Guys,

I need help creating a dynamic macro that could save me alot of time in the future.

In a nutshell:

- "Name" value in Column A
- "Yes" or "No" value in Column B
- "Name" value in Column C

I need:

- Every cell in Column C to be crossed referenced with Column A
- If there is a match, I need the value in Column B to be changed to Yes


------Column A ------------------------------ Column B ------------------------------ Column C -------
-- Jen NO Jen --
-- Jane NO Jane --
-- Sarah NO Sarah --
-- Mike NO James --
-- Mitch NO Fred --
-- Joy NO Lee --


------Column A ------------------------------ Column B ------------------------------ Column C -------
-- Jen Yes Jen --
-- Jane Yes Jane --
-- Sarah Yes Sarah --
-- Mike NO James --
-- Mitch NO Fred --
-- Joy NO Lee --

Thanks for the help,

A:Need Help - Excel 2010 - Macro - Find, if Found Replace Text In Another Column

As just a Formula, put this in column B ' =IF(A1=C1,"Yes","No")'

As a Macro -
Sub MatchReplace()
Dim LastRowColA As String
LastRowColA = Range("A65536").End(xlUp).Row
For i = 1 To LastRowColA
Range("B" & i).Select
ActiveCell = "No"
If ActiveCell.Offset(0, -1) = ActiveCell.Offset(0, 1) Then ActiveCell = "Yes"
End Sub

Read other 2 answers

How do you copy and paste a sheet or area from one file to a new file including row height and collumn spacing? If I do a regular copy and paste or special paste I don't get row and collumn height and spacing.

A:MS Excel Copy Paste

Read other 6 answers

I've been having this problem for a while and can't find an exact match for my problem doing a Google search. I'm assuming it's a Windows 7 problem, but I'm not sure.

I copy some text from Word 2010 and paste it into my Yahoo email, but some older text is pasted and not what I just copied. I don't know what is causing this. Would appreciate help from people more computer savvy than me.

A:Copy and paste problem from Word 2010 to Yahoo email

how are you selecting the text to copy it?
I am assuming---click in front of text to copy--drag cursor to highlight text--right click--select 'copy'--right click in yahoo mail window--select paste--is working perfectly here--I cannot duplicate your situation

Read other 6 answers

Afternoon everyone!

As the title suggests, I have some issues with formatting the x-axis of a column graph (the graph is to show air consumption rate over a period of 30 minutes) in Excel 2010 (the file in question is attached). As you can see in the attached picture, the graph currently has the x-axis formatted such that it starts in the middle of the ticks. Ideally, I am looking for a way to start "0" from the y-axis intercept without shifting the graph as is currently the case when changing the horizontal axis options.

Could you possibly help me sort this out? I need to present it for a university project and I'd like to have the graph presented in this manner. It would also help if I could learn the method so I can do this in future. Thank you for your help in advance!

A:Solved: Problems fixing horizontal axis on column graph in Excel 2010

Read other 6 answers

I am looking to create a macro to copy cell contents in A1 and paste in cell A2 without losing A2's contents. Then move to B1 copy different contents, then A1 and paste in cell B2 without losing B2's contents. Every group has different content, I need this to continue for a specific row range...


A:Excel Macro: Copy/Paste

that's called concatenate.
You could record a macro that does that for one line so you can see what it does, then edit it for the range you require.

BTW welcome to the forum

Read other 1 answers

I'm using Excel 2002 on a Windows XP machine. When I try to copy anything from Excel into a new message in Outlook 2003, I do the copy and as soon as I open up a new message window, Excel just quits. No error message nothing. Just quits.

Has anyone had this issue before?

A:Excel XP quits during copy paste

Hi, welcome to the board!

No, I've never heard of this. It certainly isn't a native feature (). I would check any add-ins you may have installed, start Excel up in safe mode (and trying the same behavior), closing all other apps and trying it, and then run a very thorough virus scan on your computer. If you run hijack this, post the log in the security forum (they are much better at reading those than us here in business apps..)...


Read other 3 answers

Quick question, should be easy but I have been struggling with it.
What I am trying to do is, copy the data from Row 2 and copy it into J1, and continue down the list until there are not more records.


1 ab ab ab ab ab ab ab
2 ba ba ba ba ba ba ba ba

Then delete the 2nd row, and continue on down.

1 ab ab ab ab ab ab ab ba ba ba ba ba ba ba ba

and continue down the list until the last record.

I have attached a sample sheet.

Please help!

A:Excel - Copy/Paste Macro

Read other 6 answers

Is it possible to make a macro that copy predefined cells in a selected row into new row/cell ?
For example : I select row 4 push the 'macro button' and it copies A4, B4, C4, D4 and E5 to D21, D22, D23, D24 and D25.

If this is possible , could someone please write me an example to this and if not write and example how this could be done ?

In advance , thanks!


A:Excel copy and paste macro

Hi, welcome to the forum.
In principle, everything is possible with a macro as long as the code is correct.
You could start by recording a macro yourself and follow the steps that you have explained above.
Once you're finished you stop the macro recording and take a look at the code.
This will show you more or less what it could look like, the only difference being that recoding a macro translates the coordinates to an offset R1C1 or similar instead of select Cells(2,3) (that is row 2 column 3) which is the same as Range("C2")

Try this out and see if you can work it our from there.
One important thing you should remember that you should always mention which version of Excel you're using,just a question of good habbit and complete information.

Just holler if you get stuck

Read other 1 answers

Hi. Newbie here so please go easy.
I have an excel spreadsheet with some INDIVIDUAL cells I need to copy and paste anywhere on the spreadsheet and need a macro to do it. Can anyone help? Its for classroom assignment.

So for example. Cell B1 is clicked on once and this initiates the copy of the cell contents and colour.

Another cell is clicked on anywhere on the same sheet and this delivers the paste and continues todo this on any other cells I click on until I select (for example) B2 which has another cell entry and colour.and then the process starts again.

Can anyone help me on this? I did search for previous posts but none I could find answered this specific question.

Many Thanks

Read other answers

have done a "search" to see if anybody else has had this prob -- to no avail

I am preparing my master thesis by participating in a new dictionary to be published; they require strct formats: word in font x, siz 9 - grammar definition in foont y, grey, italic and so on...

set up excel , each column to its one requirements - fair enough. finished the A and copy/pasted to word . format maintained only had to correct a few spaces.



Yes, I have gone into "paste special - unformated", it removes all teh required fonts, etc!!!!!!!!!!!!

what is going on? I have NOT altered any configurations, first time round I didn't bother with ANYTHING, purely a copy/paste did the trick!

any pity on me out there?? am in despair!

ps: Word 98 + Excel 97 /Office 97

thanks for everything, always

[ ]


A:copy/paste from excel to word, not the same as it used to be......

Read other 6 answers


I'm trying to work out how to copy a data range to another worksheet when a condition is met and i'm failing as i'm a bit rusty on the whole VBA thing

When a user enters "Y" in column U i need the relevant rows data from cell range A:C copied to another worksheet.

I've attached an example of what I'm working with and how it's laid out.

I'd really appreciate some help with this.

Read other answers

1) Category Base Worksheet has a list of Vendors in Column A.
2) In Column B are expense categories to match the vendors in column A
Example: Column A cell 1 is "McDonald's", so in Column B cell 1 will be Restaurants
3) I use the Index/Match formula in an Expense worksheet to match the categories of expenses to the vendors based on what is listed in my Category Base Worksheet.
Somehow when I now use copy and paste formulas, the category listing in B1 and paste down the column, B2, B3, etc all show the category in B1 as if B1 were fixed and not free to change.
What must I do to correct this?

Read other answers

Hey, I'm using Excel 2002 SP3. When trying to record a macro, I can copy from one cell but I cannot paste it to another....the "Paste" command is grayed out when either clicking Edit or right clicking the mouse. What is the correct method for doing a Paste while recording a macro?
Thanks, Vic

A:Copy and Paste in Excel Macros

Read other 6 answers

Does anyone know of a way to make excel not convert a cell entry to a date when copy and pasting? For example if I want to copy and paste scores of the New York Yankees games from a website where the score is listed 2-1, it would show as 1-Feb in excel. If I try and format the cell after I get something like 38749. Is there a way to make it stay as
2-1? Thanks

A:excel copy and paste question

format as text first and then try paste special and past in as text

Read other 2 answers


I want to copy/ paste this formula 5 rows down from where it starts, and then five rows again from that, and again, again, etc.

However, when I simply copy and paste, Excel tries to do the work for me by assuming I want all cell references to also move 5 rows down. Therefore, using above formula, where it references B31 it becomes B36; B30 becomes B35.

What I want is where it references column E to move down the appropriate 5 rows so that the new formula will reference E36 but where it references column B it only moves down one cell - so that B31 becomes B32, etc.

Any suggestions of how to do this without manipulating the formula after pasting every time?


A:Looking for Copy and Paste Excel Shortcut

Welcome to TSG!

No easy way to do it but this might be the easiest.
Copy and paste the formula down 5 rows as many times as needed, then move, not copy, the following cells:
B36-B40 to B31
B41-B45 to B32
B46-B50 to B33
and so on.



Read other 1 answers

This is my first post and i'm very new to macros so be gentle

I have an excel workbook that i would like to input a name in a cell and i would like the macro to search for that name in another sheet (within the same workbook) and copy and paste specific cells from that data sheet into specific spells on the original sheet.

Basically i want the macro to find the text thats entered into cell D2 of sheet 1, and i want it to look for that text in all of column C in sheet 2. If it finds a match for that text, i then want it to copy the data thats in column B and G of the same row. I then want that data to paste in cells D3 & D4 on sheet 1.

I hope that makes sense. Thank you for your help. i have been trying to find an answer for this for days and cant seem to find exactly what i'm looking for.

A:Excel - Find, Copy paste ??

Read other 9 answers

I have Antispyware 2010 on my laptop and it has caused a lot of problems. IE will not open and I cannot transfer any files from the computer to removable media of any kind. Malwarebytes Anti-Malware will not run, it keeps giving me a run-time error '372' saying that the version of vbalsgrid6.ocx may be outdated. SUPERAntiSpyware did not work either. I've tried FixExe which ran but did not fix the problem of IE not opening. Oh, and the taskbar is missing. Is this fixable?

A:Antispyware 2010 has disabled most programs (including IE) and copy/paste functionality

Hi,Welcome to Bleeping Computer. My name is m0le and I will be helping you with your log.Please subscribe to this topic, if you haven't already. Click the Watch This Topic button at the top on the right.

Please avoid installing/uninstalling or updating any programs and attempting any unsupervised fixes or scans. This can make helping you impossible.

Please reply to this post so I know you are there.The forum is busy and we need to have replies as soon as possible. If I haven't had a reply after 3 days I will bump the topic and if you do not reply by the following day after that then I will close the topic.Once I receive a reply then I will return with your first instructions.Thanks

Read other 2 answers

I have the same problem, I cant copy and paste with the right click mouse or the keyboard. I'm currently using IE 8 and I cant do anything. So whenever im on IE not even the right click from the mouse works, which brings up the Menu for Back, Forward, Save Background as... etc.The weird part is that I can copy and paste from CHROME but nothing from IE8? My notepad works fine too, but it's just when im on IE. I've tried Tool,Internet options. security, custom level, drag and copy or paste,but enable was already checked off. Please help thanks.

A:Unable to copy/ paste

I've had this problem for two weeks. I cant copy and paste with the right click mouse or the keyboard. I'm currently using IE 8 and I cant do anything. So whenever im on IE not even the right click from the mouse works, which brings up the Menu for Back, Forward, Save Background as... etc.The weird part is that I can copy and paste from CHROME but nothing from IE8? My notepad works fine too, but it's just when im on IE. I've tried Tool,Internet options. security, custom level, drag and copy or paste,but enable was already checked off. Please help thanks.

Read other 4 answers


I am unable to copy and paste files on my laptop that has had XP SP2 re-installed. Whewn I try to paste the option is inactive. My laptop is a Toshiba Tecra. Can anyone help please.



A:Unable to copy and paste

Read other 13 answers

I am very new to VBA and have a scenario that I could use some assistance with.

At work, I have 300 individual excel files, and I need to copy certain cells from each of those files and paste into a summary file. Since it is extremely time-consuming to do this manually, I was wondering if there was a macro that could open the file, refresh pivot tables (I have formulas in the 300 workbooks which are linked to pivot tables in the summary file), copy cells and paste values in the summary file (in the next available row, not to over-write previous data) and save workbook. Then repeat this process for the rest of the files in the folder. I would prefer not to have to write specific file names, as there are 300 of them and growing.

I am using Excel 2007.

I have attached the Summary file and 2 property files as examples. I need to make sure that the formulas in the Qtr1 & Qtr 2 workbooks (column D) are updated with the pivot tables in the Summary file. Then I need to copy cells B2727 from 'WS' worksheet and paste values to the next blank row in the range P2:R4 in the Summary file, and also copy cells B3131 and paste values to the next blank row in the range S2:U4 in the Summary file. Then save property file and close. Then open next file in the folder and repeat.

Please let me know if you need more info. I appreciate any help or feedback!

A:Help with Macro to copy & paste between Excel workbooks

Hi, welcome to the forum.
The Qtr1 & Qtr2 workbooks column D are unclear to me, but the B2727 and B3131 okay.

I put in a vba module with a macro and a funtion the macro Update will ask for confirmation of the Excel sheet and if you answre yes it updates the date.

Nothing with the pivot tables just the two rows into P-R and S-V

test and tell me if this is a beginning of what you need.

Read other 1 answers

This is my 1st time. I am trying to obtain the macro code for my spreadsheet. I want data to be copied from worksheet TASKS to worksheet COMPLETED based on data entered in a cell. Both worksheets have the exact same layout.Utilizing Rows A-H. I would like for all data in row to be deleted from TASKS tab and moved to the COMPLETED tab (under the same section) if Column F equals 100%. See example of layout below (have to use .... to seperate).Tab = TASKS (to be copied & deleted from)Task..................................Start Date.........Proj Compl.........Actual Compl..........%........Resource Req.............Notes Section = MEETINGS Name of Meeting..............02/08/10...............02/09/10.............02/10/10.............100%.......None.......................NoneTab = Completed (data to be moved to - under the same section) Section = MEETINGSAlso...If I need to insert rows in the future for new tasks, will the macro apply to these?Hopefully this makes sense.

Read other answers


I have an Excel worksheet with data in columns A-D. When scanning down the worksheet I note certain rows that need to be duplicated. I would like to have a macro that would, when activiated, insert a blank row below the identified row and copy the data from the identified row into the newly created blank row.

Currently using Office 2003.

Thanks in advance MBInDe

A:Solved: Excel Insert Copy Paste

is this part of the solution required for
or a different issue

Read other 1 answers

I am trying to format a play list for a flash player. The first sheet is a list of songs from 1960. The 2nd sheet is a list of commercials/drops. After every 4 songs, I want to insert a drop from the drop worksheet. I need a macro that insert the row and paste the drop row. Once it has cycled through the drop list, it needs to start over from the first drop. The number of songs and drops vary per year.
The only thing I have found is a way of inserting the rows. I have no clue how to format the rest and hope someone does. It will save hours from having to do it manually.
Do While Not IsEmpty(ActiveCell)
ActiveCell.Offset(5, 0).Select

A:Excel Macro Insert/Copy Paste

Read other 11 answers


I'm really new to writing code and I'm trying to develop some stuff in Excel 2007.

I want to record a macro for a command button that when clicked, will copy the data from Cell A6, and past it with formatting and everything into whatever cell I selected.

I can get it to copy and paste, but only into a certain cell.

Help required!



A:Solved: Excel Copy and Paste Macro

MacShand, welcome to the forum.

Try This:

ActiveCell.PasteSpecial Paste:=xlPasteAll
Application.CutCopyMode = False

What the code does is it copies the contents in cell A6 to whatever cell you have selected at the present time. So, make sure before you run the code the correct cell is selected or you may copy over needed data.

Read other 3 answers

Referencing cells: I have a spreadsheet with sales tax in D1, net amount in D2 and the total in C3 and the name in B3. What I am trying to do is copy and paste the contents of C3 to C1 & C2 and repeat for contents of C6 to C4 & C5 and so on until all rows are processed

A:Copy, Paste, Repeat macro in Excel

Sub test()
For Each Cell In Range("C1:C" & Range("C" & Rows.Count).End(xlUp).Row)
If Cell = "" Then
Cell.Value = Range("C" & Cell.End(xlDown).Row)
End If
Next Cell
End Sub

Read other 1 answers

My situation is this:

I have 2 instances of Excel 2007 open, one with the worksheet to copy from, the other with the worksheet to copy to. I highlight the desired cell in the source workbook and copy to the destination workbook. Everything works fine for a number of runs. Then, the paste attempts only paste blank cells, without any error message.

You can continue to copy and paste within the worksheet, and in all other programs, but any copy and paste that spans the two instances of Excel will yield blank cells. Once I save the documents, even after a reboot to ensure clipboards are cleared, the problem still exists.

Any idea what could be causing this?

Read other answers


I know nothing about programing an excel Macro but I need help createing a macro to do the following:

file 1
col a ffffcol b
1 ffffffffff48
2ffffffffff 26
3ffffffffff 53
4 ffffffffff8

File 2
col c fffffcol d

I want to fill the rows in col d in such a way that 1 coresdponds to 48 and so forth.

Also, the file has over 7000 rows of information so doing it by hand is not a viable option

A:Solved: Excel Copy paste macro

Read other 6 answers

Hello guys!
I have a problem, and although I thought the solution was simple, it turned out to be not at al.

I have an excelfile, it contains multiple worksheets, (approx 20)
All these worksheets have a different layout, so the columns have a different size.
When I make a report I have to copy every single worksheet in excel and then have to paste them one by one as a picture in word. This takes a lot of time ofcourse..

So I thought let's make a macro.
I started to paste all the data of the different worksheets into one worksheet and then I could use 1 simple paste and copy into word and voila..
But this didn't worked out because the columns have a different size, so some of the text became unreadible.

Then I made a macro which copies one worksheet and then puts it into a new document in word and saves it, that worked out, but I don't know how to write the code in order to make the macro, after it has copied the first worksheet and pasted it into word, to make it copy the second worksheet and paste it into word and so on for all the worksheets

This is the code to make it copy ONE single worksheet and paste it into word,
but could someone please help me with the code so that it also copies the second worksheet and pastes it into the same word file?
Sub proWord()
Dim varDoc As Object
Set varDoc = CreateObject("Word.Application")
varDoc.Visible = True
Sheets("Rapportgegevens").Range("... Read more

A:(Macro?) Copy Paste Excel to Word

Read other 9 answers


I need help in Excel copying columns and paste it in rows.

Ex: I have Columns A and B.
Column A Column B
5.78% 4.51%
23.60% 32.50%
14.17% 16.41%
32.12% 54.16%

Now output should be in one row.

Row1 5.78% 4.51% 23.60% 32.50% 14.17% 16.41% 32.12% 54.16%

A:Copy columns and paste in rows in Excel

sub test()
dim rng as range
dim i as long
dim col as long
dim nextcol as long
dim lastrow as long
lastrow = range("A"&rows.count).end(xlup)
set rng = range("A2:B"&lastrow)
nextcol =col+1
for i=2 to lastrow
range(cells(i,1),cells(i,col)).copy cells(1,nextcol)
end sub

Read other 1 answers

I have an excel sheet that shows what tools are needing calibration for each person in our lab, and when they need to be calibrated.
I have a second sheet (in the same excel file) that displays certain info from the first sheet for our calibration facility.
I would like to create a button next to each row on sheet1 containing owner data, that will be copy only the following data: Manufacturer / Model / Description / Serial number / & Owner (This one is a reference for me and out of the print area), from the first sheet, and to paste them in the appropriate boxes on the second sheet.
I already gave it an attempt, creating buttons, and a Macro, but I must be missing something key to get it to work.
Your mission should you choose to except it, is to help me fix my (Probably Crappy) Macros, and or the buttons which should be clicked to perform this function.

A:Excel: Buttons for Copy Paste Application

hey, you may want to delete that attachment and put up something that doesn't have your name and employer on it.

Just a thought.

Read other 2 answers