Forum Discussion
Creating a calendar; moving data within it
I am trying to create a calendar for work that will help me keep track of my projects and enable me to easily share with my manager what I'm working on day-by-day. I need the calendar to traverse...
P.s. I tried to use a workaround that entailed putting all the data I needed in a separate sheet in a column and then using the calendar sheet to correlate each cell with a cell in the separate sheet. But when I would delete and shift data in the separate sheet, the corresponding cell in the calendar sheet would say "#REF!". :(
Could you post a couple of screen shots to help explain what you are trying to do
Thanks
Wyn
- Hi Jazzmine,
That's not an easy task unfortunately. It might be possible with VBA (Macros) but it would be complex code.