autoflow

Hi
Please refer to the attached calender.
In the data sheet against the descriptions, the last column will be date. There will be a corrosponding or the next sheet will be a calender.
Now the function should be in the data sheet if we give a specific date say 11 May then the corrosponding 3 cells needs to be copied and pasted in the calender sheet against 11 May date.
So whatever datas we give a date, it should autoflow in the calender. And if for the same date there are multiple entries, then it should be taken or entered in the next cell.
Pls help if this can be solved.

Take a look at this thread:

http://www.excelforum.com/excel-new-...readsheet.html

Please also read the Forum Rules as your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution., Use terms appropriate to a Google search.

To change a Title on your post, click EDIT then Go Advanced and change your title.

Hope this helps.

Pete