Create copy of multiple worksheets and automatically fill in datafrom a main sheet
 

What I have is master sheet that I use to generate batch sheets for
lab experiments. Typically I have to create each batch sheet by hand
by using a macro to create multiple copies of a template. Then I go
through to each batch sheet and do a copy and fill operation by hand
to get the information from the main sheet. The problem is that I need
to do this very often with up to 100 experiments. What I want to do is
automate the entire process using a macro that creates the copies and
subsequently auto fills the sheets based upon the tab number. Inside
the attached workbook is a macro that does the copy process, what I
need to do is modify this to also do the copy and fill process.

I don't recall where I came across the copy macro, but I do not know
how to use VBA well at all.

Any help would be appreciated. Thank you.

Bryan

Create copy of multiple worksheets and automatically fill in data
 

Hi Bryan,

If I understand your problem correctly I should think that if you create an
entire workbook as the template and then when you need a new workbook simply
load the template workbook and then use Save As to a new workbook name.

--
Regards,

OssieMac


"allen-nm" wrote:

What I have is master sheet that I use to generate batch sheets for
lab experiments. Typically I have to create each batch sheet by hand
by using a macro to create multiple copies of a template. Then I go
through to each batch sheet and do a copy and fill operation by hand
to get the information from the main sheet. The problem is that I need
to do this very often with up to 100 experiments. What I want to do is
automate the entire process using a macro that creates the copies and
subsequently auto fills the sheets based upon the tab number. Inside
the attached workbook is a macro that does the copy process, what I
need to do is modify this to also do the copy and fill process.

I don't recall where I came across the copy macro, but I do not know
how to use VBA well at all.

Any help would be appreciated. Thank you.

Bryan