Hey, I have this problem with Excel at work and I have no idea how to solve it. I would really appreciate it if you could at least point me into the right direction.
So I have an extra sheet with values like
A1: 2007
A2: 2008
A3: 2009
and then I have another sheet where raw data will be entered, and there should be on column, for every year available in that extra sheet. So, for example, if I added A4: 2010 in the extra sheet, then another column should with '2010' on top should be added to the data sheet.
If VBA is needed, can you tell me the code?
Thank you very much for you help!
Alex
Bookmarks