newbie ask for help-is this possible

[compitus]

Hi! I want to use Excel as table for my work schedule. I will few field
names. My questions are:
-can I use formula to copy same name (city or company) to 1-5 different
cells on different sheets, depending on number I will put in original cell
(from 1 to 5)
-if not, can I do same thing on one sheet
Basically I wanted to to put name of employee, contractor and site where he
will work. Than, if I put ie. 5, same record will be copied automatically to
5 next sheets, or 5 cell in the same sheet. Same thing aply to different
number, 3 to 3 cells and so on.
If this is not possible, can I use Visual Basic 6 for that?
Thank You for any help

[Bernie Deitrick]

You can do it using the worksheet change event. Post back with more details
and we can help you write the code.

HTH,
Bernie
MS Excel MVP

"compitus" <[email protected]> wrote in message
news:[email protected]...
> Hi! I want to use Excel as table for my work schedule. I will few field
> names. My questions are:
> -can I use formula to copy same name (city or company) to 1-5 different
> cells on different sheets, depending on number I will put in original cell
> (from 1 to 5)
> -if not, can I do same thing on one sheet
> Basically I wanted to to put name of employee, contractor and site where
he
> will work. Than, if I put ie. 5, same record will be copied automatically
to
> 5 next sheets, or 5 cell in the same sheet. Same thing aply to different
> number, 3 to 3 cells and so on.
> If this is not possible, can I use Visual Basic 6 for that?
> Thank You for any help
>
>