Beatrix
12-18-2012, 02:14 AM
Hi Everyone ,
I have a spreadsheet which keeps back up log data. The structure works based on data source held in Planner tab. When you change the year in cover tab then all tabs are updated automatically. However data source needs to be extended for 2015 and onwards as the formula is not working when the year is changed 2014 to 2015. I can't update the formulas manually as the structure follows a logic which I'm lost on it. :doh:I've thought it might be possible to extend it by VBA.:think: If you worked on similar data scenario before could you please help me on this?: pray2:
I attempted to attach the sample file a few times and got this message. There seems to have been a problem with the VBA Express Forum database.:dunno
Any suggestions ??
Many thanks
Yeliz
I have a spreadsheet which keeps back up log data. The structure works based on data source held in Planner tab. When you change the year in cover tab then all tabs are updated automatically. However data source needs to be extended for 2015 and onwards as the formula is not working when the year is changed 2014 to 2015. I can't update the formulas manually as the structure follows a logic which I'm lost on it. :doh:I've thought it might be possible to extend it by VBA.:think: If you worked on similar data scenario before could you please help me on this?: pray2:
I attempted to attach the sample file a few times and got this message. There seems to have been a problem with the VBA Express Forum database.:dunno
Any suggestions ??
Many thanks
Yeliz