copy one sheet to other excel workbook

N

Narendra Boga

hiii all..
I have one workbook with 5 sheets. I need to open one new excel workbook
with only one sheet that includes data from my existing workbook sheet 2.

pls help...

narendra
 
M

MartinW

Hi Narendra,

Have both workbooks open, right click on Sheet 2 tab in your first
workbook and select 'move or copy' , select your other workbook
from the pulldown menu, select move to end and then check 'create a copy'
and OK out.

HTH
Martin
 
N

Narendra Boga

Thank You Martin.w

i done

MartinW said:
Hi Narendra,

Have both workbooks open, right click on Sheet 2 tab in your first
workbook and select 'move or copy' , select your other workbook
from the pulldown menu, select move to end and then check 'create a copy'
and OK out.

HTH
Martin
Click to expand...
 
Top