Hello,
I have an issue i have been struggling with for a year now, and it makes my work task take days instead of minutes.
I have about 100 Excel sheets i need to edit every month so if someone could help me with this one i would be forever grateful!
The question :
i have a graph, and my wish is to have a macro button that when pressed, it makes a line from the top of the latest collum in the sheet to the one one year prior (example shown in the picture with purple ring)
when a new collume comes cos i added more data, i wish to press the macro button again, to make the line then set itself again from the last collum to the one a year prior.
even better if this were to happen automatically... but i haven't found such a function in Excel.
i have added the file so you can download the excel file to play around with.
any help would be very much appreciated.
Untitled.jpg
Bookmarks