newbie ask for help-is this possible

  • Thread starter Thread starter compitus
  • Start date Start date
C

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
 
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
 
Back
Top