Enquiry Tracker - Linked sheets

Hi ,

I am working on a enquiry tracking sheet which has tabs Jan to Dec, Yearly enquiry list, Q1-Q4 graphs and Yearly graph . I have included a sample copy of the original sheet( which has more columns and data, but is confidential).

A sample has been uploaded at the below link for more clarity

https://www.dropbox.com/s/x8spcw15uq...ry_tracker.xls


Could anyone kindly help me to figure out the following requirements:

1. There needs to be a Control sheet( a sample is included) - Any changes or updates in this sheet( may be addition or deletion of names or regions) should reflect everywhere in all tabs ( monthly yearly and graph table entries). For Eg: Under enquiries assigned to subteams, if Ramesh is deleted, or say Ramesh is changed to Mahesh, or say a new name is added, it should reflect everywhere- in columns and lists of each tab and the table entries of graphs.

2. Yearly sheet (master sheet)is the main sheet and is filled with data as and when enquiries come in. The data from here has to be transferred (replicated) in individual months Tabs,-Jan, Feb etc automatically and be seen as shown in sample.

3. Graphs need to be also derived from the master sheet itself if possible

Kindly help.

Originally Posted by Pepe Le Mokko

Hi
please post a sample sheet on the forum showing what you already have and where it went wrong

Hi,

I have already included a work sample link. Kindly help

Hi,

I have attached the file here. I am trying to get a macro can copy monthly data(based on enquiry dates) to individual monthly sheets. Kindly help
sample_Enquiry_tracker sheeet.xls
In the sheet:

Data in Yearlist to Jan sheet

Data in Yearlist to Feb and so on.


The data in yearlist should only be copied and not movedAttachment 213793