ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   vacation (https://www.excelbanter.com/excel-discussion-misc-queries/250334-vacation.html)

ganga

vacation
 
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

Daryl S

vacation
 
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).
--
Daryl S


"ganga" wrote:

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



All times are GMT +1. The time now is 07:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com