Can i insert one ms excel sheet in all my ms excel files? read more details i'vegiven?

Question

i have more then 200 ms excel files. now i want to add a new sheet in all of them. if i copy and paste one shee 200 times it is very tedious . can i insert the sheet in all of them instantly?

Answer 1

First open two Excel files one which you want to empty it and the other you want it to be loaded on to.

Right click on sheet which u want to be transferred at the bottom tab ( where it is written Sheet 1 or if you have renamed it) .

It will show u different options like rename , delete , copy or move etc....
Go to move or copy click on that it will open another box ,select first which file you want to shift the page to , and below that another option between which pages you want it to be placed .... give move to the end it at the bottom of the list and then click ok
that sheet will move with all the formula's etc to the file u choose.

When you have finished let me know .....
all the best ..

Answer 2

You can do it only in VBA (Named MACRO or Excel), if you are intersting, this is the code you need

sub InsertSheet()
dim X1,St1, Added as workbook
x1=0
st1=sheet1.range("A1").offset(x1).value
do until st1=""
set added=workbooks.open(st1)
added.worksheets.add
added.close true
x1=x1+1
st1=sheet1.range("A1").offset(x1).value
loop
end sub

Before running, type the names of the files you want to add sheets to (With full path) in the row A starting from A1 in Sheet1

good luck

contact me for more info

Read my profile, I am the XLMan