Forum Discussion

Copper Contributor

Apr 10, 2017

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...

excel

Jazzmine Oshitoye

Copper Contributor

Apr 10, 2017

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!". :(

Wyn Hopkins
MVP
Apr 11, 2017
Hi Jazzmine Oshitoye

Could you post a couple of screen shots to help explain what you are trying to do

Thanks

Wyn
- Jazzmine Oshitoye
  Copper Contributor
  Apr 11, 2017
  Wyn Hopkins
  
  Modified my original post. :) Good idea to supply an example.
  - Wyn Hopkins
    MVP
    Apr 15, 2017
    Hi Jazzmine,
    
    That's not an easy task unfortunately. It might be possible with VBA (Macros) but it would be complex code.