Over 1 million tech questions and answers.

Copy & paste html hangs from Internet Explorer to Excel 2003

Q: Copy & paste html hangs from Internet Explorer to Excel 2003

Running Windows Vista Home Premium edition on my desktop Dell quad core processor that is only 1 year old, for the past month, trying to copy and paste from Internet Explorer to Office Excel 2003 it just hangs. If I put data in an Excel cell and copy and paste to a new Excel, it works fine. I tried repairing and reinstalling to no avail. In the past it worked just fine, the exact copying of data. I tried on my 7 yr. old Compaq laptop running Windows XP and it worked fine. What is causing this and how can I fix this?

RELEVANCY SCORE 200
Preferred Solution: Copy & paste html hangs from Internet Explorer to Excel 2003

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: Copy & paste html hangs from Internet Explorer to Excel 2003

Have you checked to see the size of your Temp internet files and have you deleted the temp internet files or temp system files recently? You can use CCleaner to delete both of these temp file types. Seems simple but I always like to start at the most obvious.

Read other 2 answers
RELEVANCY SCORE 90.4

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

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

Read other 2 answers
RELEVANCY SCORE 90.4

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
 

A: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?
 

Read other 3 answers
RELEVANCY SCORE 90.4

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.
 

A:copy paste to Excel 2003 using Windows Vista

Read other 8 answers
RELEVANCY SCORE 82

hey can anyone help me? for some reason my clipboard don*s work for internet explorer. it works for everything else but not ie.

i have done the following already:
- reinstalled ie...
- downloaded an advanced clipboard
- resetted my web settings

anyone know what i can do? isn*t there sposed to be the clipboard thing when you go to START all programs accessories system toOls or something? cuz i can*t find my clipboard anywhere.

please help!
 

A:COPY AND PASTE for internet explorer

Read other 16 answers
RELEVANCY SCORE 82

hey can anyone help me? for some reason my clipboard don*s work for internet explorer. it works for everything else but not ie.

i have done the following already:
- reinstalled ie...
- downloaded an advanced clipboard
- resetted my web settings

anyone know what i can do? isn*t there sposed to be the clipboard thing when you go to START all programs accessories system toOls or something? cuz i can*t find my clipboard anywhere.

please help!
 

A:COPY AND PASTE for internet explorer

Read other 16 answers
RELEVANCY SCORE 81.2

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

Pedro
 

Read other 1 answers
RELEVANCY SCORE 80.8

I know some images you can't copy and paste, but I use to go to free clip art sites and would be able to copy and paste into Word for kids school projects. Now I can't and I have not been able to for a while now. I think it is an Internet Explorer problem, but I could be wrong. I just recently installed Service Pack 2 for Internet Explorer and still does not work. I am able to copy and paste text, but not images. Can anyone help. mom22
 

A:Can't copy or paste images from Internet Explorer

If you have your Microsoft Internet Explorer security set high, you may not be able to copy and paste in the PureCMS editor. You can fix this by changing one small setting.

To allow copy and paste function in PureCMS
Open Internet Explorer.

1.On the menu bar, choose Tools > Internet Options.

2.Click the Security tab.

3.Select the Internet zone and click the Custom Level button. The Security Settings window opens.

4.Scroll down to the Scripting section of Settings.

5.Under Allow paste operations via script select Enable or Prompt.

6.Click OK to close the Security Settings window.

7.Click Yes when asked if you want to change security settings for this zone.

8.Click OK again to close the Internet Options window.
 

Read other 1 answers
RELEVANCY SCORE 80

We use ms shareoint at work (accessed from internet explorer 8) and are constantly copying and pasting within Internet Explorer - to and from ms office docs, etc. Formatting of text very often gets dorked up moving between these and takes considerable time to clean up.

Is there a way to do copy and or paste plain text in internet explorer 8? (without having to use notepad as an intermediary) Is there a user level plugin or add-on to do this?

In Firefox (which we are not allowed to use at work) one of the most useful plugins for me is "Copy Plain Text" - I just right click and 'copy as plain text' or 'paste as plain text' - hoping there is something equivalent for IE8 (that is installable without administrator privileges).

Thank you.

A:Copy/Paste plain text in Internet Explorer 8

Hi Eric,

Most (all?) Office apps allow you to use Paste Special|Unformatted text, or something equivalent to achieve what you're after. Is that not suitable for your needs?

Read other 1 answers
RELEVANCY SCORE 80

My daughters pc boots up ok. If I try internet explorer 7 it flashes up and it starts and closes immediatley. .exe files dont seem to run. If I try and copy data off to save it, I cant paste it. Cant drag items to copy.
I've deleted temp files and delete all browsing via the control panel. I've run AVG and spybot and it reports nothing. Can't do updates on AVG or spybot.
When I boot into safe mode with networking it shuts ie down again and I still can't copy and paste. exe's wont run .. System restore wont run.

Its Windows xp Media center version 2002 with service pack 3. on a Dell dimension pc with 1gig of ram. She had a virus a while back but she said that AVg got rid of it.

Can anyone help please.

Sati

A:exe's, internet explorer, copy and paste wont work

Hi, welcome to TSF!

Please follow our pre-posting process outlined here:

http://www.techsupportforum.com/f50/...lp-305963.html

After running through all the steps, you shall have a proper set of logs. Please post them.

If you have trouble with one of the steps, simply move on to the next one, and make note of it in your reply.

Please note that the forum is very busy and if I don't hear from you within three days this thread will be closed.

Read other 15 answers
RELEVANCY SCORE 79.2

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

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
RELEVANCY SCORE 78.4

Hello, I have Office 2003, everything works fine until the moment when I go to the web, then in Word 2003 can not load table inside the data transferred only text or numbers, and tables are not in themselves.
for example: a document with a table inside, which is filled with some data if I want to copy this table and add to the same document or a new document be transferred only text, no tables. But things have to be well until the moment comes to the Internet, such as I turned on her computer and does not bind to the internet everything works fine in Word 2003 and copies of all data and loads the tables, but only to a web wxplorer, just a normal word I can not load data. If Restart kompiureti and not connect to the Internet, then Word is running perfectly.
 

A:I cant paste on word 2003 then open the internet explorer

don't mean to sound rude, but I haven't the foggiest idea of what you are talking about. Internet and Word are two separate apps. Are you copying from the internet into MS Word?
 

Read other 1 answers
RELEVANCY SCORE 72

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
RELEVANCY SCORE 71.6

This sounds absurd, but I just noticed I can't do what I have done without problems for years.
Essentially when I copy a part or whole web "document" & paste into Word 2003, I get the text & just empty boxes where the images should be.
Now this simple copy-paste routine has worked before in XP & I am pretty sure in Windows 7 (64 bit) which I now have.
It looks as though something has changed, but despite my best efforts & ages spent Googling for a solution, nothing seems to work.
This is really inconvenient because I use this approach a good deal & it allows me to edit, & even change image position & size when I wish to do that.
BTW I always note in copied stuff the original URL & the name of the author.
Is this a Word 2003 settings issue or is something more sinister likely the cause.

A:Can't copy paste images from web to Word 2003

- can you give an actual example of the type of "document" that you wish to copy?

Read other 3 answers
RELEVANCY SCORE 71.6

it has been ages since i have said hi to all you wonderful people, so HI! do hope all have a great summer, vacation, etc. it's been great here! no vacation, but still had/have a great time playing with my ball of foil!!

ya know all of us have been on a deadline to get a report, etc. done and right in the short time you have your pc gets stupid. well mine has gone stupid and i had to laugh that such a simple thing went haywire but I AM CLOSE TO MY DEADLINE AND DON'T NEED THIS CRAP!

I volunteer at the resale shop that sells things to raise money for our animal shelter. I can't begin to tell you how fantastic the resale shop is! all the proceeds (the sales are two weekends a month 6 hours each day and they make $1200-1500 each weekend) go directly to the feeding and care of the zillion of animals in the shelter and zip goes to admin cost!!!

anyway, i am working on (and have to get them done NOW) the sale date flyer and the xmas flyer and all of a sudden my copy/paste function doesn't work!! Not CTRL C (even when I reset the keyboard command--changed the keys to use for this function..did a system restore, etc.) SO...the people at the resale shop are great people but they will beat me if i don't get these donek I checked the posts about this problem but the threads had expired.

I KNOW and am major confident you all will help/solve this problem..
 

A:copy/paste kaput word 2003

Read other 10 answers
RELEVANCY SCORE 71.2

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
 

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
RELEVANCY SCORE 71.2

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
RELEVANCY SCORE 71.2

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

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
RELEVANCY SCORE 71.2

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

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

Read other 3 answers
RELEVANCY SCORE 71.2

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
RELEVANCY SCORE 71.2

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
RELEVANCY SCORE 71.2

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
RELEVANCY SCORE 71.2

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!
 

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.

HTH

Jerry
 

Read other 1 answers
RELEVANCY SCORE 71.2

Hi

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
RELEVANCY SCORE 71.2

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!
 

A:Excel - Copy/Paste Macro

Read other 6 answers
RELEVANCY SCORE 71.2

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
 

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

Read other 6 answers
RELEVANCY SCORE 71.2

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
RELEVANCY SCORE 70.8

I have a table that includes a column for "Date of Death". In many cases, the date is either unknown or only partially known. I created another column entitled "Date of Death1". DOD1 is mm/dd/yyyy and DOD is text. I copy and pasted all the data from DOD to DOD1 and DOD1 returned a listing of all of the data it could recognize as dates in proper mm/dd/yyyy format. I'm about to convert DOD1 to text so that I can then fill in the remaining missing data (i.e. "1884"; "12/??/1908"; "?? Mar 198?"; "Apr 1779" etc.). The point is to convert everything to a more uniform, condensed format (because some dates were listed as "February 27th, 1893", and some as "6 Nov 1955" and some as "13/aug/1964" etc.). By filtering I can easily sort out all the dates in DOD that are year only ("yyyy"), however the only way it seems to transfer the remaining data from DOD to DOD1 is to type it in manually as I cannot copy and paste multiple cells by highlighting or using CTRL + or SHIFT +, other than to highlight the entire column. Total of about 8000 records, roughly 1200 more dates to transfer, and roughly a half dozen more columns to repeat this process (Date of Birth, Date of Burial, Date of Purchase, etc.). After that is all said and done I will need a way to sort according to date, given that not all of the information is known and that thousands of entries are going to be year only and hundred... Read more

A:Copy and paste multiple cells in access 2003

Read other 6 answers
RELEVANCY SCORE 70.4

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.
 

Read other answers
RELEVANCY SCORE 70.4

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
 

A:Word/Excel crashes when copy & paste

What are you copying and from where?

Does this happen on the Copy or the Paste?
 

Read other 2 answers
RELEVANCY SCORE 70.4

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
RELEVANCY SCORE 70.4

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
RELEVANCY SCORE 70.4

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
 

A:Excel Macro Insert/Copy Paste

Read other 11 answers
RELEVANCY SCORE 70.4

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

A:(Macro?) Copy Paste Excel to Word

Read other 9 answers
RELEVANCY SCORE 70.4

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
RELEVANCY SCORE 70.4

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
RELEVANCY SCORE 70.4

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?
 

Read other answers
RELEVANCY SCORE 70.4

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
 

A:Find, copy and paste macro in Excel

Read other 16 answers
RELEVANCY SCORE 70.4

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.
 

Read other answers
RELEVANCY SCORE 70.4

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
RELEVANCY SCORE 70.4

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.

A:Annoying Excel Copy/Paste Problem

Hi,

Turn the option off as shown below.

Regards,
Golden

Read other 3 answers
RELEVANCY SCORE 70.4

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
 

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

Read other 3 answers
RELEVANCY SCORE 70.4

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?
 

A:Solved: copy/paste excel cells

Read other 9 answers
RELEVANCY SCORE 70.4

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%
 

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

Read other 1 answers
RELEVANCY SCORE 70.4

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
RELEVANCY SCORE 70.4

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
 

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

Read other 1 answers