Sheets named from range, and copy data?

[Jason.Alden.Benoit]

Hi,

I really don't know where to start with making what I am trying to
make. I will sum it up as best as I can. I also want to add that I do
not have hardly any experience with macros. I can however learn easily.


I have a sheet with stats for employees. In this workbook I have a
sheet named "Data". I also have a sheet named for a corresponding
supervisor, which is noted next to an employees name. I would like to
set up a macro(s) that will allow me to press a button(how to create
button?), or select a range and then populate a worksheet with that
employee's name and corresponding stats (from the same row where name
is taken from) in different areas to be printed. In other words, I want
to be able to press a button and all stats be printed without having to
compile them on paper. This would allow me and other supervisors to
start Monday morning giving feedback right away and not waste time
going back to it while answering questions, etc.

Any additional information that I need to provide I will respond as
soon as possible.

thanks for anyone's help.

J.B.

 

[Jason.Alden.Benoit]

Thank you for your help Challa. I did this and it copied the cells that
I was looking for data from. What I need is a way to make a sheet from
a template sheet and name it from a list (Range B11-B30).

A B C
....
....
....
11 Name One
12 Name Two
13 Name Three

Then I need to pull data from different cells from the same row as the
persons name , and then port that data onto the new sheet with that
person's name. Cell C1 would NOT go to C1 on the new sheet, etc.

Is that at least a little bit more clear on what I am looking for?

 

[Dave Peterson]

It kind of sounds like you're trying to use the Data worksheet as a database and
merge it into something like a form letter.

If that's what you're doing, you may want to put your form in MSWord and keep
your data in Excel, then use MSWord's mailmerge capability to generate these
"letters".

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

If you really want to keep it in excel, you may want to visit Debra Dalgleish's
site:
http://contextures.com/xlForm03.html

And you may want to look at this, too:
http://www.contextures.com/xlForm02.html