Computer Support Forum

Simple Copy and paste in Excel

Question: Simple Copy and paste in Excel

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

More replies
Relevance 100%
Preferred Solution: Simple Copy and paste in Excel

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

Relevance 80.77%

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.

Thanks
vhappy

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

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

1 more replies
Relevance 78.72%

I have been doing spreadsheets for years and suddenly my mind has gone blank.
Problem:
The values of 'A, B and C' are totalled in column 'D'
I insert a formula in 'D' and it totals A. B and C'
I then copy the formula in 'D' downwards and receive the message "Data on the clipboard is not the same shape and size as the selection, do you want to paste the data anyway"
My actual problem is more convoluted than above but has been shown to simplify the situation.
Reason???

Answer:Excel, Copy formulae and paste - Will not paste!!!

Update:
I tried to copy and paste on other tabs on the same spreadsheet with the same result I then opened a fresh spreadsheet and tried the copy and paste within in that - the same result. I looked on the web for others with the same problem and despite there being a fair number of posts relating to the problem there did not appear to be an answer.
However I shut down and then restarted Excel and lo and behold all is working as it has done for the past 20+ years!!
How?

5 more replies
Relevance 78.31%

hey,
I am trying to learn how to write macros so we can do some engineering analysis. im an intern at my job and was just thrown an excell book and told to figure it out. any helpw ould be great.

Soo i have this idea where you just enter in data on the first worksheet and then then the macro is used it sends it to the second sheet where all of my formulas and analysis goodies are. any ideas for a simple macro for this. My boss wants to make it where if you enter two sets of data it makes two worksheets. is that possibe?
 

Answer:Solved: a simple copy and paste macro help

8 more replies
Relevance 78.31%

I'm trying to create a batch file that will copy from a source and paste into a destination. I need it to add the date and time to the file name as well.

So far, I have it successfully adding the date with the following code:

ren <file> <file>%date:~4,2%-%date:~7,2%-date:~10%.doc

This works....but I cannot seem to add the time as well.
Any help?

 

Answer:Simple Copy and Paste Batch File

See if this thread helps?

Or, just copy the files and use a utility like Rename to do the file name changes after the fact.
 

1 more replies
Relevance 77.49%

I'm a VBA newbie and would much appreciate any assistance in creating a macro to carry out the following task:

I am analysing several funds. I have spredsheet which calculates certain statistics for each fund when the fund is selected from a drop down menu.

I have an output table with the fund names in the first column, Statistic 1 in column 2 and Statistic 2 in column 3. In order to populate this table I have to manually select each fund and then copy and past the calculated statistics into the table. I would like to a macro which automates the task of selecting each fund in turn and copying and pasting the results into the table. To illustrate the issue more clearly I have attached a sample spreadsheet with some dummy data.

Any assistance would be much appreciated.
 

Answer:Solved: Help needed with simple copy and paste macro

7 more replies
Relevance 77.49%

I want to copy and paste an image to another on adobe photoshop. I dropped the original photo, then tried to paste another on top of it but it doesn't allow me to. I know I'm missing something simple so I would really appreciate some help! Thanks...
 

Answer:Simple Copy and Paste photo in new layer? (photoshop)

I open both in PS ... select the source layer(s) you want to move ....
And drag n drop to the target with the move tool.
 

1 more replies
Relevance 75.03%

Hi Team,I am facing issue in copying data from one excel to another.I cannot do paste,where as paste special works fine for me.I am having MS 2007.To clarify: If I copy from an excel spreadsheet/workbook. Then open a completely different spreadsheet workbook, in other words I opened another session of excel, then the copy and paste will not work.If I open multiple excel documents will in the same excel workbook, it will copy and paste correctly.Could you guys help?

Answer:Unable to Copy & Paste from one Excel to another Excel 2007

Generally as long as both are open, it should work.Request that the question is moved from the Windows 7 forum to the Office forum for best results.You have to be a little bit crazy to keep you from going insane.

2 more replies
Relevance 72.98%

In Mac's Excel how can I paste data from different rows (for example, A4, D4 and M4) into another sheet keeping the same distance (to A4-D4-M4 on another sheet)?Thanks for help.

Answer:Copy/Paste on Mac's Excel

re: how can I paste data from different rows (for example, A4, D4 and M4) A4, D4 and M4 are all on the same row - Row 4.They are, however, in different columns.As far as I know, the Copy/Paste feature is no different on a Mac than on a Windows based machine.Unfortunately, you can't paste non-contiguous cells in Excel, keeping the same distance between them.In order to use Excel's built in Copy/Paste feature, you would have to select the entire range A4:M4 if you want to keep those cells the same distance apart.If you want to get into some VBA code, it could be done, and it might also be able to accomplish your goal with formulas, but you'd need to be very specific about what you are trying to do.

3 more replies
Relevance 72.98%

I'm trying to copy and paste the Sky channels from click here into Excel. The problem is the data extends over several columns, no matter how wide I make column A. Can I manipulate this data so it is in only one column; or better still, two, so that column A= '101', column B= 'BBC ONE', etc.

Answer:Copy and Paste from Web into Excel

The columns are separated only by spaces.Cut and paste into your Wordy processor, then search and replace spaces with tabs. That might do what you want. Some clever wordy processors can search digit space, I think. If so that will overcome the problem of spaces between words. Otherwise have to do a confirmed replace operaton.Have fun. Just think of all those Sky TV programs you are missing while doing that.

10 more replies
Relevance 72.98%

I have been using excel spreadsheets for years Suddenly I can't use control+c to copy and paste from one cell to another Normally control +c will highlight the cell with a shimmering frame . This doesn't happen and no data is entered into destination cell on pasting.
more important I can't link cells in separate spreadsheets using copy and paste special using icons at top of spreadsheet
Please can someone tell what I have accidentally done?

Answer:excel can,t copy/paste

If you have Skype Click-to-Call add in that causes the problem. See ClickHere
Other than that have you done a Detect and Repair? Excel -> Help -> Detect and Repair

4 more replies
Relevance 72.98%

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.
 

Answer:MS Excel Copy Paste

6 more replies
Relevance 72.16%

When I want to copy a range of cells in Excel, there exists a "marching ants" dotted line around the copied area during and after I've pasted it.Should it still be there after I've finished pasting, and what should I do to stop it? My way of getting shot of the lines is by hitting escape but that doesn't seem to be the way I'd plan it if I'd designed the process. What am I doing wrong?

Answer:Excel copy and paste poser

just click elsewhere in the sheetjohnny.

7 more replies
Relevance 72.16%

Hi,I have a column of data (4600 obs). I clicked copy and then paste them into another column in the same spreadsheet. Some of the obs were automatically deleted during this process! The pasted data were only around 4200 while I didn't do anyting to them. I tried to copy something from another spreadsheet and the same thing happened. It doesn't work with neither .xls nor .xlsx.Can anyone help me to fix this? Thank you!Wendy

Answer:copy&paste problem in Excel

What is it that you were copying? Text, numbers or formulas?

2 more replies
Relevance 72.16%

I have a simple Excel 2007 spreadsheet and I'm copy/pasting bits into a PPoint slideshow. I'm only copying small sections of a sheet (8 rows x 3 columns)which have a simple thick line outside border, thin line between cells and a some coloured fonts. I did this yesterday with no issue at all, using paste special and pasting as enhanced metafile picture, but for some reason today when I do this, all the fonts are black when pasted(Colours gone) and 2 out of the 4 thick outside border lines are missing. Anyone come across anything similar. I've tried pasting special with ALL available formats, non give me a true image. I have no clue if I've altered something inadvertently or why this is happening. I've restarted both XL and PP, to no effect, tried repeating some blocks that have remained untouched on XL and are already pasted OK in PP, they now refuse to give same result.Either I've done something dumb or it's strange glitch.Any ideas folks?

Answer:Copy/paste Excel to Ppoint

I can work around it by editing picture in PP and changing it to drawing object, but it wasn't happening yesterday, so stumped.

4 more replies
Relevance 72.16%

For some bizarre reason I find that I can no longer copy an entry from a single cell in Excel to multiple cells.
e.g. copy a formula from one cell applied to all the other cells in that column.
I's happily worked before, but now the error message says "Data on the clip board is not the same size and shape.....".
What on earth has happened?

Answer:Can't Copy & Paste to a Range in Excel

Had the same problem see http://www.pcadvisor.co.uk/forums/1/helproom/4130955/excel-copy-formulae-and-paste--will-not-paste/
I have found the problem intermittent, I discovered it works if you restart Excel again, although not every time. I initially thought that it was the particular file, but I now believe that the programme is the problem. Googling for it has not produced as far as I can see a satisfactory answer.

2 more replies
Relevance 72.16%

i currently have 7000 mp3 files stored in my docs/my music etc. to make it easier to find out whether or not i have a song, i thought it would be a good idea to compile a database in microsoft excel but, i don't fancy having to retype all the .mp3 file names into excel. is there a way of using the copy and paste function to transfer said data to excel or do i need to start typing?? thanks muchly!

Answer:copy and paste from "my documents" to excel

Have a look at this click herechange this lineMyFile = Dir(CurDir() & "\" & "*.*")to MyFile = Dir(CurDir() & "\" & "*.mp3")

3 more replies
Relevance 72.16%

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
 

Answer:Copy and Paste in Excel Macros

6 more replies
Relevance 72.16%

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?
 

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

http://forums.techguy.org/54-malware-removal-hijackthis-logs/
 

3 more replies
Relevance 72.16%

I've developed a Timesheet for my staff to use and I've acquired some VBA to copy the worksheet within a workbook and paste it into a new worksheet so that we can look back from one pay period to the next. I would like to include in my VBA to copy and paste to also move a staff members New balance for Sick Time, Comp Time, Vacation Time, etc... to the Previous Balance column. Basically, in the process of copy & paste, i'd like to move the date in G25 to D25, G26 to D26 and so forth. Here is the VBA that I'm using to copy and paste the worksheet. Sub Test()Dim ws1 As WorksheetSet ws1 = ThisWorkbook.Worksheets("Timesheet")ws1.Copy ThisWorkbook.Sheets(Sheets.Count)End SubI would appreciate and assistance you can provide.

Answer:How can i copy and paste cells using VBA in excel

Sub Test()
Dim ws1 As Worksheet
Set ws1 = ThisWorkbook.Worksheets("Timesheet")
ws1.Copy ThisWorkbook.Sheets(Sheets.Count)
ws1.Range("G25:G30").Copy
ThisWorkbook.Sheets(Sheets.Count - 1).Range("D25:D30").PasteSpecial _
Paste:=xlValues
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

14 more replies
Relevance 72.16%

Excel Crashing when copying cells. If I highlight a section of cells with data and do a command C, Excel crashes. Excel 2008 was continually crashing for any operation using Mac OSX 10.6. whatever the last update was. Thinking that the crashing may be caused by an operating system to older software issue, I upgraded to OS 10.7.3 (lion) and purchased Excel 2011. Everything was working fine on large spreadsheets until this evening, when I tried to copy paste on a small worksheet and then every time I hit Command C, Excel would crash. Would appreciate any assistance, as this is going to adversely affect completing a project. Additional fact, the worksheet that the data was copied from was an older Excel file (circa 1996 +/-) , brought forward to Excel 2008 and then into Excel 2011.

Answer:Excel crashes when I try to copy & paste

Does Lion come with any free technical support?Even if it doesn't, call Apple and tell them what's happening and see if they have any suggestions.You don't have to tell them that it's a 1996 file. Just tell them that you recently upgraded to 2011 and Lion and that Command C crashes Excel.Can't hurt to ask...Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 72.16%

Hi.

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.
=IF(ISERROR(B31),"",IF(AND(B31<>B30,ISTEXT(B31),E31<>B31),B31,IF(AND(B32<>B31,ISTEXT(B32),E31<>B32),B32,IF(AND(B33<>B32,ISTEXT(B33),E31<>B33),B33,IF(AND(B34<>B33,ISTEXT(B34),E31<>B34),B34,IF(AND(B35<>B34,ISTEXT(B35),E31<>B35),B35,""))))))

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?

Thanks!
 

Answer: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.

HTH

Jerry
 

1 more replies
Relevance 72.16%

I am on XP, have Windows7 with Excel and have a problem when I try to cut/copy and paste-to word, to excel-to anywhere! The error message of "Excel not responding? is set off, 98% of the time I have to close everything that is open,sometimes the paste takes, sometimes it doesn?t. Previous posts have identified this as a Microsoft programming issue, andI do not know what to do. It?s a huge time killer. Previous posts have also said reinstalling didn?t help.

Answer:Cannot copy & paste from Windows 7 Excel

This should be in the Office forum here: http://www.computing.net/forum/offi...

4 more replies
Relevance 72.16%

i want to use macro for my work as follows :I have selected a range to copy to another range as follows:1. move cursor down, there may 2, 3, 4 or some rows. For example 5 times to moving down cursor.2. At this cell I have to paste the selected range by hit enter3. Then, the next step is waiting my respon to moving down cursor4. select a cell and hit enter to paste.Thank you so much

Answer:Need Excel Macro To Copy & Paste

When posting in a help forum such as computing.net, please use a subject line that is relevant to the contents of your post.If everyone used a generic subject such "Macro in 2010? we wouldn't be able to tell one question from another.I have edited your subject line to make it more relevant.DerbyDad03Office Forum ModeratorClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 72.16%

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
 

Answer:excel copy and paste question

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

2 more replies
Relevance 72.16%

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!

-risanger
 

Answer: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
 

1 more replies
Relevance 72.16%

Hi helpful gurus!New to VB and have question.I have spreadsheet with text values in Col A (Laptop, Desktop..etc) mixed in with other text(Ex: Column A could say Laptop, it could also say "Brand New Laptop"...etc)Based on finding the text value "laptop" regardless of case anywhere in Col A, I want VB to copy/paste that row into a secondary spreadsheet called Laptop.I have a VB that does this if EXACT match for "Laptop" in Col A. How do I tell it to look in Col A for "laptop" wherever the word comes inside the cell in Col A?Thanks so much!IhsahnI have:Sub JimMacro()'' JimMacro Macro''Set a = Sheets("SOURCE081711")Set b = Sheets("LAPTOPS")Dim xDim zx = 1z = 2Do Until IsEmpty(a.Range("A" & z))If a.Range("A" & z) = "Laptop" Thenx = x + 1b.Rows(x).Value = a.Rows(z).Valuea.SelectRows(z).Copyb.SelectRows(x).PasteSpecialEnd Ifz = z + 1LoopEnd Sub

Answer:Excel-VB to copy/paste a row if Certain Text

actually, I figured it out, it's a matter of using LIKE and then a wildcard character *, and enclosing this within "" for a specific search and return.So I amended my code to this, hope it helps somebody else!Sub JimMacro()'' JimMacro Macro''Set a = Sheets("SOURCE081711")Set b = Sheets("LAPTOPS")Dim xDim zx = 1z = 2Do Until IsEmpty(a.Range("A" & z))If a.Range("A" & z) Like "*Laptop*" Thenx = x + 1b.Rows(x).Value = a.Rows(z).Valuea.SelectRows(z).Copyb.SelectRows(x).PasteSpecialEnd Ifz = z + 1LoopEnd Sub

2 more replies
Relevance 72.16%

I cannot paste a formula that I have copied. I copy the formula then try to paste it, and it just pastes the calulated amount from that cell. This function used to work fine, and in fact I have used it often, but now it just doesn't work. I have tried changing options, but cannot get it to work

Answer:I cannot copy and paste a formula in excel

Are you pasting it into the cell or into the formula bar?I think you should be using the formula bar.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 72.16%

I am trying to make a simple calender like spread sheet of the days/hours that my wife and I work each week. If my wife and are not working during the same date/hour, I have the corresponding cell show blue, if either one of us is working the cell shows red.If she works from say 6am to 8am on monday she puts a "1" in the corresponding box. If I work 10-11am on monday I do the same in my area. Then the third weekly calender shows blue in any time block we both are not working. As seen here ---->http://i826.photobucket.com/albums/zz188/ttimblin/excel1.jpgI used a conditional "Formula is" format for cells J3:J22. Seen here for cell J3 ----->http://i826.photobucket.com/albums/zz188/ttimblin/excel2.jpgHow do I get the formula to be copied over to the rest of the calender??!?!? Every time I highlight and drag the + cursor over the rest of the cells it does not change the column assignment. Eg. from "=$B$3+$B$27=0" to "=$C$3+$C$27=0" for Tuesday, and "=$D$3+$D$27=0" for Wednesday and so on.It will take me forever to format each cell individually. Please save me! Thanks!

Answer:Copy and paste problem in Excel

=$B$3+$B$27=0Using the Dollar Sign Anchors that column or row. If you want the column to change but not the row, when you drag try: =B$3+B$27=0If you want the row to change but not the column, when you drag try:=$B3+$B27=0MIKEhttp://www.skeptic.com/

4 more replies
Relevance 72.16%

I am having a problem with cut & paste, and copy & paste. I lose the formatting when I paste. Also, the cut does not cut but just works as "copy". And when I select the cell and do cut or copy, it does not highlight the cell. And paste special only has a couple of selections. please help

Answer:Hi, i cant copy and paste in excel windows 7, please help,

Try running a Diagnostic:Running Microsoft Office Diagnostics from within Excel/WordClick the Microsoft Office buttonClick on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)Click on the Resources button in the left hand paneClick on the Diagnose button in the right hand paneClick ContinueClick Run DiagnosticsRunning Microsoft Office Diagnostics from the Start MenuClick on the Start buttonClick All ProgramsClick Microsoft Office folderClick Microsoft Office ToolsClick Microsoft Office DiagnosticsClick ContinueClick Run DiagnosticsWhile your at it, check your Cut & Paste options in the Advanced section.MIKEhttp://www.skeptic.com/

3 more replies
Relevance 72.16%

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.

ie.

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!
 

Answer:Excel - Copy/Paste Macro

6 more replies
Relevance 72.16%

I have a MS-DOS aplication generates data about past horse races. I want to copy from the app into excel and cant do it. The app output has the appearance of spreadsheet, ie. column x row .. but appears even worse than this see below in word, excel recognizes each row but no columns. I really dont want manually input. Is there a fix? I have spent considerable time trying to format after in word but have been unsuccessful. I looked for converting utility, but am running win98 which is apparently as good as it gets. Can anyone help?

-+-----------+---+--------+------+------+-----+------+------+------+-- 1 BACKS2 ¦ 82¦169.31-3¦77.1-5¦56.7-2¦ 68.7¦95.2-3¦84.6-4¦91.1-4¦ 7¦PRE¦
-+-----------+---+--------+------+------+-----+------+------+------+---+---¦
3¦ 1 BACKS3 ¦ 74¦167.72-6¦72.3-9¦55.7-7¦*70.1¦95.1-4¦83.2-8¦90.3-8¦ 12¦EAR¦
-+-----------+---+--------+------+------+-----+------+------+------+---
 

Answer:copy/paste from dos 2 word/excel ?

Can this dos program save results? What about print them?
 

11 more replies
Relevance 72.16%

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

Thanks!!!
 

Answer: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
 

1 more replies
Relevance 72.16%

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.

ok

so now from B - Z : WHY WHEN I COPY / PASTE TO WORD NOT ONLY WILL IT KEEP THE GRIDLINES BUT THERE IS NNNNNOOOOOOOOOOO WAAAAAAYYYYYYYY IT WILL CHANGE SPACES, ALTER ANYTHING - IT MAINTAINS ITS EXCEL LOOK!!!!!!!!!

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

[ ]

Dd
 

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

6 more replies
Relevance 72.16%

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.
 

Answer:Excel - Find, Copy paste ??

9 more replies
Relevance 71.75%

Hello,

I am totally a beginner with VBA so I hope you guys could help me!

I have a collection of data in excel in which I should search for a certain "name". Once the name is found, the macro should be able to select the entire row of the match and then copy to another sheet (could be in the same workbook).
I try to use the code described on this topic (already closed): http://forums.techguy.org/business-applications/703562-search-macro-excel-2003-a.html

However, my problem when using this code is that it is only copying the first "occuring" of the "name" and in a sheet I have, for example, 42 occurences for a name "example" and I want to copy all of them, not only the first.

So, could you help me please?
I am using winXP with excel 2003.

Thank you,
Agatha
 

Answer:Find, copy and paste macro in Excel

16 more replies
Relevance 71.75%

When I copy and paste a cell under Excel 2010 I get a small 'Ctrl' message below and to the right of the target cell -- the one I am pasting to. The message's drop down list contains all of the paste functions. The only way I can clear the message is to use ESC or copy another cell.

I've lived with this for a couple of years now and it finally has begun to irritate me.

Is there any way I can prevent the little message from appearing?

Thank you.

Answer:Annoying Excel Copy/Paste Problem

Hi,

Turn the option off as shown below.

Regards,
Golden

3 more replies
Relevance 71.75%

I am extremely new to VBA. I have a basic program where a person will enter details into worksheet "Survey". Once done entering the information, they click the button "Add to Database". This will execute a macro that copies the different cells from the "Survey" sheet and places them in the the "Database" sheet on the next available row. Then the cells on the "Survey" sheet are cleared out.The cells that are copied are not continuous. There are 156 cells of information of varying sizes and types that need to be copied.Once clicking on the button, I receive an error that says:Run-time error '1004':Method 'Range' of object '_Worksheet' failedWhen I debug the code, it highlights the line "Set myRng = .Range(myCopy)" as wrongI believe the "String" is too long so the "Range" cannot be made. Please help...Option ExplicitSub UpdateLogWorksheet() Dim Database As Worksheet Dim Survey As Worksheet Dim nextRow As Long Dim oCol As Long Dim myRng As Range Dim myCopy As String Dim myCell As Range 'cells to copy from Input sheet - some contain formulas myCopy = "C4,C6,C8,C10,C12,C14,C16,C19,C20,C21,C22,C23,C24,C25,C26,C27,C28,D28,C29,D29,C30,C31,C32,C33,C34,C35,C36,C37,C38,C39,D39,C42,C43,C44,C45,C46,C47,C48,C49,C50,C51,C52,C53,C54,C55,C56,C57,C58,C59,C60,C61,C62,D62,C63,C65,C68,C69,C70,C73,C75,C76,C77,C78,C80,C81,C82,C83,C84,C85,C86,C87,C88,C89,C91,C92,C93,C94,C95,C96,C97,C99,D99,C102,C103,C104,C105,C108,C109,C110,C111,C112,C113,C114,C115,C116,D116,C119,... Read more

Answer:VBA in Excel 2003 - copy and paste then clear

Have you tried just making a named range, and referring to that in your VBA?How To Ask Questions The Smart Way

3 more replies
Relevance 71.75%

Using Excel 2010, I noticed what I can only call a 'Quirk'
Try this:Enter
Cell a1 enter 5
Cell a2 enter 6
Cell a3 enter 7
Cell a4 enter calculation =sum(a1:c1) and you will get 18, which is correct.
Now copy the contents of cell a4 to cell a5 and you get 31, as the formula has changed to =sum(b1:d1).
The same applies if you do =a1+a2+a3.
Is there a way to stop this apart from using absolutes?.
Terry

Answer:EXCEL 2010 Quirk Copy Paste

Shouldn't cell A4 be sum(a1:a3)? Sum (a1:c1) if there is nothing in columns b and c should result in 5.

4 more replies
Relevance 71.75%

hello,

I've used this code below (found on this forum) in a worksheet to successfully ignore the source formatting when copying/pasting into the spreadsheet, however as stated on the thread i found it on, it disables the undo/redo options (and possibly more??).

Private Sub Worksheet_Change(ByVal Target As Range)
Dim myValue
With Application
.EnableEvents = False
myValue = Target.Formula
.Undo
Target.Formula = myValue
.EnableEvents = True
End With
Application.CutCopyMode = False
End Sub

Any ideas on how to modify it to allow the use of undo/redo? And i've actually just realised that macros reset the undo/redo function when they run and because this is a macro that runs all the time it will always reset undo/redo. Any ideas on a modification to run on open/close or something? or even better, to do this without a macro?

Cheers
 

More replies
Relevance 71.75%

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
 

Answer: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
 

1 more replies
Relevance 71.75%

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.
 

Answer: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.
 

2 more replies
Relevance 71.75%

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?

Answer: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)?

4 more replies
Relevance 71.75%

I have created webapges that I use excel files to copy and paste to my website. For some un known reason I can no longer do this. I use excel 2003 with service pack 3. I was able to copy the file and just paste it into the webpage. I use IE8. I also use Norton Internet Security from Comcast. Norton turned off my Windows firewall and I can't turn it back on. I think this is my problem.
 

More replies
Relevance 71.75%

Is there a way of copying & pasting just the filename (& not the file itself)from Windows Explorer into an Excel spreadsheet or Word document?

Answer:Copy & paste filename into Excel or Word

Right-click the file and choose Rename. Press Ctrl+C to copy the highlighted filename then press Esc to abort the rename. In your document press Ctrl+V to paste.

2 more replies
Relevance 71.75%

Hello,

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
1
1
2
3
3
3
4

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
 

Answer:Solved: Excel Copy paste macro

6 more replies
Relevance 71.75%

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?
 

More replies
Relevance 71.75%

Hi,

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%
 

Answer: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)
col=rng.columns.count
nextcol =col+1
for i=2 to lastrow
range(cells(i,1),cells(i,col)).copy cells(1,nextcol)
nextcol=nextcol+col
next
rng.delete
end sub
 

1 more replies
Relevance 71.75%

I have a acer axc-603g-uw13 with excel 2016. When I copy/paste the copied cells have a dotted border. When I used to paste and then go to the next cell task, the dotted border would just go away. Now, (I have probably pressed a key unintentionally) the dotted border stays and will not go away. Can anyone help?
 

More replies
Relevance 71.75%

Hello,I am trying to do the following - I have a data sheet with about 100 rows, and would like to write a macro where it copies a selected row and inserts /pastes directly underneath it a specified number of times.e.g. user selects row 5 and wants that data to be repeated 17 times underneath it.Any help you can give would be great,thanks, Ricky

Answer:Macro to copy, paste, insert in Excel

Sub InsertRows()
'Make sure user has selected 1 entire row
If Selection.Cells.Count <> Selection.Resize(1).EntireRow.Cells.Count Then
MsgBox "Please select 1 entire row, then rerun macro."
Exit Sub
End If
'Get number of rows to insert from user
getNum:
myCopyNum = Application.InputBox("How Many Times Do You Want the Row Copied", Type:=1, Default:=0)
'Make sure sneaky users can only enter integer values
If Int(myCopyNum) <> myCopyNum Then
MsgBox "Enter Integer Value or Click Cancel"
GoTo getNum
End If
'Quit if Cancelled
If myCopyNum = False Then Exit Sub 'Copy and Insert Rows
Selection.Copy
Rows(Selection.Row + 1 & ":" & Selection.Row + myCopyNum).Insert Shift:=xlDown
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 71.75%

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.
 

More replies
Relevance 71.75%

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.EntireRow.Insert
ActiveCell.Offset(5, 0).Select
Loop
 

Answer:Excel Macro Insert/Copy Paste

11 more replies
Relevance 71.75%

Hi, I hope you can help me. One of my users is having problems with an excel sheet (it is only 115Kb), Whenever she wants to copy something from it either to another excel file (the document is one that is copied and amended for the next week) it takes about 5 mins to copy the data. It is the same if the info is copied into Outlook, whether it be the whole document or a snippet of info. The document has no formulas in it and it is a simple log wherby she adds data to it each week and at the end of the week she copied the main fields and creates a new file for the next week.I cannot understand why it is taking SO long to copy and paste such a simple document / data contained within such a simple document. Any advice is appreciated.Thanks

Answer:Excel 2007 very slow copy/paste

First thing to try is a Diagnostic:Running Microsoft Office Diagnostics from within Excel/WordClick the Microsoft Office buttonClick on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)Click on the Resources button in the left hand paneClick on the Diagnose button in the right hand paneClick ContinueClick Run DiagnosticsRunning Microsoft Office Diagnostics from the Start MenuClick on the Start buttonClick All ProgramsClick Microsoft Office folderClick Microsoft Office ToolsClick Microsoft Office DiagnosticsClick ContinueClick Run DiagnosticsSee if that helps.MIKEhttp://www.skeptic.com/

2 more replies
Relevance 71.75%

Whenever I copy & paste in Word or Excel, they always (always) crash. I have to restart the program and loose everything not saved.
Anyone else experiencing this?

Win 7 / Office 2003
 

Answer:Word/Excel crashes when copy & paste

What are you copying and from where?

Does this happen on the Copy or the Paste?
 

2 more replies
Relevance 71.75%

Hi

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!

Thanks

C
 

Answer:Solved: Excel Copy and Paste Macro

MacShand, welcome to the forum.

Try This:
Code:

Range("A6").Copy
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.
 

3 more replies
Relevance 71.75%

Hi,

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
 

Answer:Solved: Excel Insert Copy Paste

is this part of the solution required for
http://forums.techguy.org/business-applications/868445-excel-data-sort.html
or a different issue
 

1 more replies
Relevance 71.75%

I have a bunch of Excel cells that are spread out across several columns.

Is there a quick way to "move" these cells so they are all in the same column, with different Rows instead?
 

Answer:Solved: copy/paste excel cells

9 more replies
Relevance 71.75%

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.

More replies
Relevance 71.75%

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?
Code:
Sub proWord()
Dim varDoc As Object
Set varDoc = CreateObject("Word.Application")
varDoc.Visible = True
Sheets("Rapportgegevens").Range("... Read more

Answer:(Macro?) Copy Paste Excel to Word

9 more replies
Relevance 71.75%

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!
 

Answer: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.
 

1 more replies
Relevance 71.75%

http://www.computing.net/answers/of...is that still not solved?I got this bizarre error for excel, I am using Office 2013 on Win7 I' have tried all almost every method except clean OS install.. Repairing Office - does not helpUninstalled Skype and click to call feature - does not helpAfter uninstalling Skype and click to call feature, re-installed chrome latest browser - temporary helps...Guys, anyone here manage to solve this problem?? . There is no more information about this error on whole web..

Answer:Excel Copy Paste Bizarre Error

There were a few issues/problems stated in that thread. Which problem are you having?

6 more replies
Relevance 71.75%

hello Dear Champs,How to copy and paste entire column after a specific header column in excel using VBA Micro ,please help with code it very urgent Thanks a lotRegardsAnil

More replies
Relevance 71.75%

I have developed a very strange error. When using Excel 2010; and copying the machine behaves strangely.Say I want to copy a cell or range of cells, even within the same worksheet - I highlight the selection; and hit ctrl-c. The clipping mask flashes briefly; but doesn't persist like it used to.when hitting ctrl-v; it pastes - but values only; not any formulas.Paste Special offers a hint - it gives me the text options, unicode/unformatted text - almost as if it thinks the source cells are from a different file type. Even if this is attempted within the SAME worksheet!No systems running in the background except for the usual workplace anti-virus etc. Any ideas?

Answer:excel copy paste bizarre error

Have you tried a Repair:Go to StartControl PanelProgram & Features (That's the old Add Programs)Select MS program, but DO NOT double click, simply select it.On the Task Bar near the top you should be given the option to Change/Repair.MIKEMIKEhttp://www.skeptic.com/

8 more replies
Relevance 71.75%

Hi,I was very happy copying and pasting my bank statements onto a 2003 Excel spreadsheet - so I can keep good records for business. I used to highlight a section of my bank statement, say 6 rows x 5 columns, copy it, then paste into 2003 Excel - no problem. The data would appear in the right cells - 6 rows x 5 columns.Now I?ve started to use 2007 Excel. When I try to paste the same data into a 2007 spreadsheet it populates just the first column. I get all my data in column A. I've tried Paste Special - no joy. I don't know what to do or if anyone else has this problem? It's making my work really hard and very time consuming.Any help would be a life saver!Thanks a lotPaul

Answer:microsoft excel copy and paste problems

Under the DATA tab, try Text To Columns.Highlight the data Select DATASelect Text To ColumnsRead the directions on the wizard that appears.MIKEhttp://www.skeptic.com/

15 more replies
Relevance 71.75%

I am running Excel 2007 and have run into an annoying little issue relating to copying and pasting data either from one worksheet to another or one workbook to another. When I highlight my selection hit control C than go to another worksheet and hit control V -- about 90% of the time nothing is in the clipboard to paste -- and I have to go back to the original and hit control C again than go back and hit control V (second attempt always works) --- at first I thought I may have an error in my keyboard buttons but this never occurs in word or Access outlook or even this forum. I mentioned it is about 80% of the time I have tested a spreadsheet it always happens in, by moving it to another computer running 2007 and do not have a problem -- Any ideas, as mentioned I can get around it but it very aggravating.

Thanks

J.T.
 

More replies
Relevance 71.75%

I have a column of data that is sorted by the date. I want to create a formula to have this data pulled into another sheet but the data sorted by the date in multiple columns not just the single column.Ex.1/1/01 21/1/01 51/1/01 61/2/01 71/2/01 8need data to look like1/1/01 2 1/2/01 71/1/01 5 1/2/01 81/1/01 6

Answer:Excel Copy Data Rearrange Paste

re: "I want to create a formula... "We all want something.Posting tip:If you are asking for help, try actually asking as opposed to just telling us what you want.

6 more replies
Relevance 71.75%

I have created several spreadsheets representing a dog's pedigree and statistics. What I would like to do now is be able to choose 2 dog's spreadsheets, and then copy and paste both of their pedigrees/data into a new spreadsheet to evaluate a test breeding between the 2 dogs. I No calculations are needed, I just need a way to create an organized and temporary way to present the data for both dogs.All the worksheets are identical in structure. The data is arranged in blocks. I know where I would like each block of data to be positioned on the new 'Test Breeding' worksheet. Unfortunately, I have no clue how to do this. Any assistance would be greatly appreciated!

Answer:Need Excel Macro: Copy/Paste to new Worksheet

Keep in mind that we can't see your spreadsheets from where we're sitting, so it's kind of hard to give a specific answer.It sounds as if VLOOKUP would work, except the VLOOKUP doesn't work across multiple sheets. However, there is User Defined Function at the Ozgrid site that will do VLOOKUP's across all sheets in a workbook.Are you ready for a interesting coincidence? The example they use is:=VLOOKAllSheets("Dog", C1:E20, 2, FALSE) As I said, not knowing the layout of your sheets, but using the fact that you said that all sheets are laid out the same, I'm thinking that you might be able to use this UDF to accomplish your task.Let us know if that helps.

3 more replies
Relevance 70.93%

Hello all

I'm playing around with the idea of using the BeforeDoubleClick event to copy and paste the contents of cells. Is it possible to copy and paste two adjacent cells at the same time by double clicking on one of the cells? Here's the scenario:

Sheet 1
Column A contains item description
Column B contains price of item
I want to double click on any cell in column A, say, A10 and have the contents of A10 and B10 copied and pasted into columns A and B on sheet 2.

The data in columns A:B is constantly changing, with items being added or removed all the time. I don't want to have to keep amending the code to take into account fluctuations in the numbers of new lines.

At the moment I can get the contents of a single cell copied and pasted into the required place on sheet 2. Here's my code, which also highlights in red the cells on sheet 1 that have been copied:

[code starts]
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
With ActiveCell
.Copy Sheets("Sheet2").Range("A65536").End(xlUp).Offset(1)
Cancel = True
Sheets("Sheet1").Activate
.Font.ColorIndex = 3
Range("A1").Select
End With
End Sub
[code ends]

Columns D:E and G:H on sheet 1 also contain similar data to columns A:B. Is it possible for me to apply the same double click principle to these columns but have the contents of the selected cells pasted into their respective columns in sheet 2, for example, double click on, say... Read more

Answer:Solved: Excel 2003: using BeforeDoubleClick to copy and paste

This works for me:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 1 Or Target.Column = 4 Or Target.Column = 7 Then
Cancel = True
Target.Resize(, 2).Copy Sheets("Sheet2").Range(Mid(Target.Address, 2, 1) & Rows.Count).End(xlUp).Offset(1)
Target.Resize(, 2).Font.ColorIndex = 3
Else
End If
End Sub
 

2 more replies
Relevance 70.93%

Hey there!I am looking for a way to automatically copy paste values from one sheet to another based on the contents of the column in the following way:- If a cell in column M in Sheet 1 mentions "Phase 1", I want to copy the contents of Columns A, C and D of the same row and paste them to cells F4, G4, H4, I4 of Sheet 2. (F4 being Phase 1 and G4,H4,I4 being the column A,C and D entries respectively)- I want this to be repeated until the last "Phase 1" value on column M is found and I want the data to be pasted in the next row each time (so if the first "Phase 1" row gets pasted to F4, G4, H4, I4, I want the second row to be pasted to F5, G5, H5, I5) in the same worksheet.) - Then I want to do the same with "Phase 2" but starting 4 rows below where the "Phase 1" entries ended in Sheet 2.I am new to VBA so let me know whether this is clear - happy to provide any extra information if otherwise. message edited by Odysseus

More replies
Relevance 70.93%

Excel 2007, two separate worksheets. Copying a range of cell data (no formula) e.g. values from D2:D100 from one sheet to another, the paste results in blank cells (no data copied). This is often followed by Excel crashing.I have tried using two separate instances of excel (separate monitors), one instance with both sheets open, same result.I have tried resetting my PC, and only having excel running to ensure its not a memory problem (3.4GHz Intel with 3Gb ram) but this didn't help. I've also used a format cleaner to remove any superflouous formatting from the sheets - nothing seems to work.Short of uninstalling and re-instaliing Excel I'm running out of ideas, can anyone offer any suggestions?

Answer:Excel 2007, Copy/Paste problem between worksh

Does this happen with all worksheets or just a specific one?If it's a specific file, try it on a different machine (but expect a crash)If it's a specific file, try copying a smaller range, like D2:D50, then D51:D100. If it crashes with one section but not the other, narrow it down even farther (e.g. D2:D25).I've narrowed down worksheet corruption to a single cell by using this method.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 70.93%

Hi

This is very frustrating for me but probably very easy for someone with the know!

I use excel for accounts and enter the relevant details along a row; 1 row for each transaction. I want to be able to select specific cells from that row and paste them into an Excel invoice template i have.

I have used the macro record button to do this and it works fine except for one thing; it always copies the cells from the row i created the macro from. I would like it to copy the cells from the row i have selected. Hope this makes sense.

It obviously selects the cell (c4 etc) in the code but i want it to select based on the row of the cell selected if you know what i mean.

Here is the basic code i have
Sub CreateInvoice()
'
' CreateInvoice Macro
' Macro recorded 01/09/2007 by User
'
' Keyboard Shortcut: Ctrl+i
'
ChDir "X:\Accounting\Customer Accounts\Invoices"
Workbooks.Open Filename:= _
"X:\Accounting\Customer Accounts\Invoices\Blank Invoice.xls", UpdateLinks:=3
Windows("Accounts September 2007.xls").Activate
Range("B8").Select
Selection.Copy
Windows("Blank Invoice.xls").Activate
Range("B4").Select
ActiveSheet.Paste
Windows("Accounts September 2007.xls").Activate
Range("C8").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Blank Invoice.xls").Activate
Range("B2").Select
ActiveSheet.Paste
Application.CutCopyMode = False
With Selection
.H... Read more

Answer:Excel copy & paste Macro for selected cells

16 more replies
Relevance 70.93%

update on the below question:I think something is wrong when I opened the .csv file.If I leave the file open then run the macro, it works ok. If I open the file within the macro, I get the format problem.Any advice?Thanks!Hi,

Please can someone give me some advice on this?

I am writing a vba code in Excel 2003 to copy from a source .csv file and paste into xls file.

First, I tried this using macro recording, it worked fine. so I recorded the macro and tried to apply it. Something strange happened.

One of the columns is date, and originally is format Date (*01/01/01). If I manually copy and paste, the format is fine. If I use the macro, some (and only some) of the cells in this column will change format to General and align to the right, while the others keep the original Date format and align to the left.

How did this happen?

I viewed the .csv file using Notepad, and cannot see any difference between these dates that end up in different format.
And if I manually copy/paste, there will be no format issue at all.

Please can someone help?

Thanks!
 

Answer:copy/paste in excel macro changes cell format

upon a closer look, i think I found some clue, but still far from a solution, here is what I observed.

for date 09/07/2006, excel interpret it as Sept 07 06
for date 20/06/2012, excel interpret it as June 20 2012

please note the year format is different!

any advice pls?
 

1 more replies
Relevance 70.93%

I get the following message, if I open a workbook with different sized cells and data, select all[Complete Sheet] in the left corner[...A1]...................and.............then open a new workbook from an EXCEL ICON on my desktop...............and..............paste the contents into it by select this complete sheet[...A1...].........


Message:"Data on the clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway ?"

If I now paste the data, I end up with a very wide sheet with default column sizes....All our computers behave like this.
Note:If I do not open a 2nd new workbook from the desktop icon/excel, but rather go...
...>FILE......NEW....and open a new workbook from here, then this function does work.


Why is this, I always worked like described originally...?
 

Answer:EXCEL:Copy & Paste sheet between two workbooks, one original and new ?

I'm guessing here, but i think it's because when you open Excel by clicking on the desktop icon, you're opening a new instance of Excel. When you're working in a the same instance of Excel with multiple workbooks open, Excel is able to keep track of and transfer a lot of information between workbooks. However, it can't do as much when working between multiple instances. Each instance is like a walled off garden, and only limited copy/paste functions work between them.

Hopefully that makes sense.

And you used way too many ".........................."
 

2 more replies
Relevance 70.93%

Greetings.

I have a pivot table that I'm trying to pull a sample from. It is 1800 rows, of which about 400 have data that I want to use for my sample selection. I'm trying to generate my sample randomly. I've hidden the empty rows. I tried to copy this into another file, but the hidden rows are included as well. Data sort doesn't work, or I can't get it to work.

Any ideas? I was hoping to just copy the data only rows into a new file and generate random numbers for my sample, using the row #s as my selection criteria.
 

Answer:Solved: Excel- copy and paste without hidden rows?

6 more replies
Relevance 70.93%

Hi,

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.

Help!

Thanks in advance
 

Answer: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.
 

3 more replies
Relevance 70.93%

I have a macro that I have used for a very long time with no issues. It appears to be something with the number of records. I use it to copy and paste from one worksheet to the bottom of the other. I used it with no problem yesterday when I had 31896 records but with 31982 records today, it errors out with copy and paste are not the same size and shape.

code
Dim UsedRng As Range
Dim FirstRow As Long, LastRow As Long, FirstCol As Long, LastCol As Long
Set UsedRng = ActiveSheet.UsedRange
FirstRow = 2
FirstCol = UsedRng(1).Column
LastRow = UsedRng(UsedRng.Cells.Count).Row - 2
LastCol = UsedRng(UsedRng.Cells.Count).Column
ActiveSheet.Range(Cells(FirstRow, FirstCol), _
Cells(LastRow, LastCol)).Select
ActiveSheet.Range(Cells(FirstRow, FirstCol), _
Cells(LastRow, LastCol)).Name = "END"
ActiveSheet.Range("END").Copy Destination:=Sheets("CANOPI - Link report").Range("A" & Rows.Count).End(xlUp)
\code
 

Answer:Solved: Excel VBA Copy & Paste no longer works

Well, I just tried it manually and it did the same thing. The only difference I can see is the number of records.
 

2 more replies
Relevance 70.93%

Hey everyone,

We have a tool that we send out to our customers that they enter information about orders. The file is saved in Office 2000-2003 format but I am editing it in Office 2007. Is there a way to eliminate the ability to right click and to keep our customers from copying and pasting.

When they copy and paste it screws up the calculations that are done behind the scenes.

Can someone please help me?
 

Answer:Disabling Right Click and Copy Paste options in Excel

If you use a macro the user will be prompted to allow macros. Is there a way to have this done behind the scenes so that the user can't continue to do what they want to do? Without this it kind of defeats the purpose.
 

2 more replies
Relevance 70.93%

Hi - This is a problem occurring at work.

We use Windows XP and Office 2007 (although our managers are on Office 2010, they have also experienced this same issue). We use two monitors, so we can use two programs side by side. One fairly common use is to have two instances of Excel open, one on each monitor. We want to be able to copy a range of cells from one workbook to another. This sometimes works, but more often than not, on the second C&P action, the paste only selects the same range of cells, but pastes nothing.

I'm really hoping this question makes sense.

Can anyone suggest why this is happening? It is confusing in its inconsistency.

I can't think of any other technical information to provide, but if there is something extra that is needed to resolve this, please let me know and I will check when I get back to the office tomorrow morning.

Thanks!
 

Answer:Excel 2007 Copy & Paste between Workbooks Problem

11 more replies
Relevance 70.93%

Hi Guys

I exported price data from a trading application and tried to paste it on excel but the numbers changed.
I tried to paste the data on notepad. Everything ok. All data the same as source.
Then I tried to copy paste from notepad to excel, again the numbers changed.

Example:

In notepad:
2016.09.21 00:00 0.7552 0.7636 0.7534 0.7632 13177
2016.09.22 00:00 0.7633 0.7674 0.7625 0.7643 8973
2016.09.23 00:00 0.7644 0.7653 0.7608 0.7622 8215

In Excel become :
2016.09.21 00.00 5,244444 5,302778 5,231944 5,3 13177
2016.09.22 00.00 5,300694 5,329167 5,295139 5,307639 8973
2016.09.23 00.00 5,308333 5,314583 5,283333 5,293056 8215

Please help
 

More replies
Relevance 70.93%

Hi,
I am trying to sort the colored rows, copy and paste it in particular format.
I have attached a sample excel file.
1. A cell has values which are Purple in color.
2. B cell has values, yellow, Blue and White in color.
3. I want concatenate A-Purple, B Yellow and paste it in next work sheet "Result"- Col2
4. Blue rows need to be copied and pasted to Col2
5. White row need to get pasted to Col4
6. Want to repeat this for whole worksheet.
Can you please suggest a macro for this?
Thanks,
 

Answer:Need excel Macro for copy paste colored rows

7 more replies
Relevance 70.93%

Hi,

I would like to be able to input a number into a cell B3 on sheet 1 - 'Head Count'. Then get the macro to look up the number that was input and copy and paste all the rows relating to it from sheet 2 - 'Data' and paste them on 'Head Count' next to the input cell.

I am having trouble with getting the macro to copy and paste depending on the target cell. This is what i have so far:

Sheets("Data").Select
'Copy cells of Data from rows containing cost centre in col G of the active worksheet (source sheet) to cols
'of Head count (destination sheet)
Dim DestSheet As Worksheet
Set DestSheet = Worksheets("Head Count")

Dim sRow As Long 'row index on source worksheet
Dim dRow As Long 'row index on destination worksheet
Dim sCount As Long
sCount = 0
dRow = 1
For sRow = 1 To Range("G65536").End(xlUp).Row
'use pattern matching to find "Significant" anywhere in cell
If Cells(sRow, "G") Like "Worksheets("Head Count")Range("B3")" Then
sCount = sCount + 1
dRow = dRow + 1
'copy cols

' With Range("A14:AA14", Range("A65536").End(xlUp))
'.Paste

Cells(sRow, "A").Copy Destination:=DestSheet.Cells(dRow, "A")
Cells(sRow, "B").Copy Destination:=DestSheet.Cells(dRow, "B")
Cells(sRow, "C").Copy Destination:=DestSheet.Cells(dRow, "C")
Cells(sRow, "D").Copy Des... Read more

Answer:Excel macro copy and paste depending on a cell

Can you upload a workbook with dummy data so we can see how you've structured the data.
 

1 more replies
Relevance 70.93%

Copy paste from html Internet Explorer to Excel 2003 gets Non Responding. I deleted temporary internet files. I can copy paste from email to Excel without issues or from Excel to Excel. For example, I tried to copy and paste my Visa statements online and it froze when I tried to paste. In the past, I was able to do this without incident. Same when I try to copy and paste from an investment which has html language in it. I uninstalled and reinstalled Office 2003 but that didn't fix it. I downloaded RegCure which said it guaranteed to fix non responding errors but it didn't. What could be causing this? I have McAfee as my virus software and firewall. This is a Dell Quad core machine 1 yr old.
 

Answer:copy paste to Excel 2003 using Windows Vista

8 more replies
Relevance 70.93%

This started in win 7 and continues in win 10. After pasting into range shows original value in the entire range. This happens with Excel functions and VBA. The error can be easily corrected with search set to = and replace set to =. I would prefer correcting the problem. I frequently change formulas. Am running Enterprise 2010 of Office.

More replies
Relevance 70.93%

Hello everybody,I would be really happy if someone helps me with this macro. I have 4 columns: A, B, K, L.A and B are full of data (thousands of rows) in K there are key words (about 10 but this number vary). I need macro, which will check word in K (for example K3) and then it will run through column A and if there is match (e.g. A200) then it will copy data from cell next to it (B200) and then it will paste it to L column (L3). Afterward it checks K4, K5....This would save me literally hundreds hours of my time. Thanks a lot!

Answer:Excel macro - copy/paste if there is match in text

Have you tried a =VLOOKUP() function?MIKEhttp://www.skeptic.com/

5 more replies
Relevance 70.93%

Hi ,

I have the code for triggering an outlook email, if i click on a button . I have attached the code for this in the bottom of this message . I would like to add one more functionality for this code . I want to copy several columns in the excel file and paste it in the email body . The excel file is attached for your reference. I would like to know , how to copy the contents of the excel worksheet and paste it in email body. please help.
Sub GenerateEmail()
Dim olApp As Object, olMail As Object
Dim ws As Worksheet
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
End If
Set olMail = olApp.CreateItem(0)
olMail.To = "[email protected]"
olMail.Cc = "[email protected]"
olMail.Subject = "Macro for mailing"
olMail.Body = "Test Macro" & vbCrLf & vbCrLf & "See our double space?"
'olMail.Attachments.Add strFullPathNameHere
olMail.Display

End Sub
 

Answer:How to copy the contents of excel and paste it to email body ?

6 more replies
Relevance 70.93%

Hi. I am trying to run a macro to copy items on 1 sheet and have it paste them on the 2nd and 3rd sheet. I am trying but can't quite seem to get the excel code to do what I want. I can't post a copy of it because I accidentally deleted it.

Can anyone help me?
 

Answer:Solved: Excel: Copy/Paste Macro Code Help

9 more replies
Relevance 70.93%

Hi,

I'm running a Win7 32-bit system with Office 2003 installed, all latest patches are installed as well. I have these periodic (and very sporadic) errors when working in a spreadsheet or document where the application stops working when copying and pasting information between sheets, cells, documents etc. and the computer freezes up and I have to reboot. The error is "Microsoft Office has encountered an error and needs to close". This has become very frustrating when working on templates and losing large amounts of information. I haven't been able to find any troubleshooting tips pertaining to these issues and it is happening across 3 or 4 computers in our network now. These are new Dell Latitude E6410 laptops with clean installs on them.

Anyone have any ideas?

Thanks,
~Chris
 

Answer:Excel/Word 2003 copy and paste crash

Have you ever sent an "error report" to MS? (I certainly never do, I'll admit.) I am curious as to what the error report generated would be - something to do with your anti-virus, perhaps?
 

3 more replies
Relevance 70.93%

Hi everyone!So I was wondering if there was a way to do the following. Saying I want to make monthly reports for a country (Italy) and two product categories (Juice & Water) but the worksheet containing the data is massive and I have to do that every week. The rows look something as following:Country - Product - OtherstuffWould there be a macro in the way "If Italy and Juice" cut paste whole row in a different workbook? Cheers!message edited by Odysseus

Answer:Excel Macro for conditional Copy/Paste for whole rows

Since you still haven't told me how you want to pass the country names to the macro (even though I've asked twice) I once again have make an assumption. This code will work for the criteria that you posted in Response #8 since I assume that you want the country names hard coded into the macro.The code creates an Array with the county names that you provided and then loops through the array searching for each element.(Note: This code still copies the rows to Sheet2 of the same workbook. I'll leave it up to you to modify it so that it copies the rows to your other workbook. Practice is good.)
Option Explicit
Sub CopyData()
Dim c As Range
Dim firstAddress As String
Dim nxtRw As Long
Dim cNum As Integer
Dim Country_Arr() As Variant

'Build array of Country names
Country_Arr = Array("Italy", "Slovakia", "Switzerland")

'Loop through Country names Array
For cNum = 0 To 2

'Search Sheet 1 Column A for array elements.
With Sheets(1).Columns(1)
Set c = .Find(Country_Arr(cNum), LookIn:=xlValues)

'If found, Check Sheet 1 Column B for Juice or Water
If Not c Is Nothing Then
firstAddress = c.Address
Do
If c.Offset(0, 1) = "Juice" Or _
c.Offset(0, 1) = "Water" Then

'If True, determine next empty Row in Sheet2, copy Row Values from Sheet1
nxtRw = Sheets(2).Range("A" & Rows.Count).End(xlUp).Row + 1
c.EntireRow.Copy
Sheets(2).Range("A" & nxtRw).PasteSpecial Paste:=xlValues
End If... Read more

14 more replies
Relevance 70.93%

copy and paste formula will not work suddenly I am unable to copy and paste a formula in a cell to a new sheet. Nor can I copy and paste a formula one row down from the original formula. example A1 has formula of sum(d1:f1) when I try copy paste formula in a1 to b1 it does not copy over.

Answer:excel 2010 will not copy & paste a formula to new sheet

What version of Excel?What does happen, if anything, when you copy/paste?Have you tried Copy / Paste Special / Formula?Do you have Skype or have recently installed Skype?MIKEhttp://www.skeptic.com/

13 more replies
Relevance 70.93%

I am in excel and have an incident record number that I want to search on in Outlook. I click on the cell in excel that has the record number. I go up to the formula bar and copy (hit control C), then I go to Outlook in the folder I want to search in. I go to the search bar and hit control V or try to right click and hit paste. Either way, nothing appears.

Answer:I can't copy & paste text from Excel into Outlook search

While you are waiting for further advice, with the same reference please confirm that you can copy it into Notepad or Word using Control V.Always pop back and let us know the outcome - thanks

6 more replies
Relevance 70.11%

I'll try to be as descriptive as possible.

Current Status:
I have an excel file with two sheets: sheet1 and sheet2.
Column "A" will have lots of data.
Some rows in column "A" (or the first cell for that row) will have the word "Directory".

Intent:
I need to search sheet2, only in column "A", for the row that contains the word "Directory" and copy that whole row onto sheet1 in the same row. Continue doing that until it completes through all of the rows.

Example Data:

(Before)
sheet2
Row Column A Column B Column C
1 blah blah blah blah blah blah
2 blah blah blah blah blah blah
3 blah blah blah blah blah blah
4 Directory cool text huh?????
5 blah blah blah blah blah blah

sheet1
Row Column A
Row Column A Column B Column C
1 blah blah blah blah blah blah
2 blah blah blah blah blah blah
3 blah blah blah blah blah blah
4 blah blah blah blah blah blah
5 blah blah blah blah blah blah

*Action: Column "A" find "Directory" Copy Row 4 to sheet1

(After)
sheet1
Row Column A
1 blah blah blah blah blah blah
2 blah blah blah blah blah blah
3 blah blah blah blah blah blah
4 Directory cool text huh?????
5 blah blah blah blah blah blah
 

Answer:Simple Excel Macro to Copy Row from one Sheet to Another

"copy that whole row onto sheet1 in the same row"

Do you mean like this?

(make sure what you already have is "safe" before you try, obviously)

Sub test()
If ActiveSheet.Name <> "Sheet2" Then Exit Sub
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For Each Cell In Range("A1:A" & LastRow)
If InStr("Directory", Cell.Value) <> 0 Then
x = Cell.Row
Rows(x).Copy
Sheets("Sheet1").Cells(x, 1).Insert Shift:=xlDown
End If
Next Cell
Application.CutCopyMode = False
End Sub
 

1 more replies