vacation

G

ganga

I have two files. One is monthly vacation schedule and other one is weekly
schedule. What I want to do is if I enter a name in monthly vacation I want
that to be show also in weekly shedule.

For eg. If I enter ganga on the 30th of nov(vacation schedule) I want to say
“vac†on nov 30th in weekly schedule.

Thank you in advance
 
D

Daryl S

Ganga -

You haven't given us much to go on, but you can always reference a cell in
one worsheet from another. So if you enter your information on the monthly
worksheet, you can have a reference to that cell in your weekly worksheet.
Just clock on the cell in the weekly worksheet (e.g. Nov 30), type an equal
sign (=), and then navigate to the monthly worksheet and click on the
corresponding cell (e.g. Nov 31).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top