View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Uma Nandan Uma Nandan is offline
external usenet poster
 
Posts: 27
Default Copy from Internet Explorer & Paste in Excel

Hi,

I would want some one to help me with the following:

we hv huge date to copy from internet explorer to Excel not with one click
however with many by selecting what is required.

I am doing the following as of now:
Select the data from IE by highlighting it and then do ctrl+c and go to
Excel and do ctrl+v or f4.

Internet Explorer: MS Excel:
A
B
1 Company Name Name
Copy " citigroup" 2 Paste "Citigroup" Paste "Pandit"
copy " Pandit" 3 Paste "Lehman" Paste
"David Wishon"
copy "Lehman"
Copy "David Wishon"

Is there any way that i can do this copy past in single click instead doing :
select - rightclick - copy - go to excel - rightclick-paste
Select - ctrl+C, go to excel, select the cell, ctrl+v or use F4.

is ther any way i can just put a button in excel to copy from IE & paste the
same in Excel - current active cell.

Thanks in advance for your help.

Regards,
Uma