There is a macro, but you will have to write it. You can start by recording a macro. 1. Start the Macro Recorder 2. Go to the Sheet you want ...
Hi Lisa, The proper code would be something lika that is triggered the moment to change the contents of the cell with the data. This macro (that...
Thanks to this site and ... everyone here is great, I like to read the posts, but-in once in a while, and learn something every time.
@Anders: I took the liberty to use the formulas from your file to sum the periods from Nov to Oct in the previous file I had attached. This way it'...
I did some playing around with formulas, I do not have 365 but am using version 2021 so many if the new functions are unavaliable to me. The formul...
If you also include the Excel version you're using and a sample file as Anders stated ...
And don't forget to mention the Excel version you're using
I've looked at the files and the what I can tell you is the way I do that monthly calculation. The start value is the value at the min date value o...
Hi there, First, which version of Excel are you using? What do you mean with "ALL THE IMAGES"? A picklist? Can you attach a sample of your fi...
Hi Rena, First do tell us which version of Excel (Office) you're using, this because many new functions are only available in 365 and some of these...
Just to be clear about this. If it's the active sheet you want to rename you can just rename it with the macro ActiveSheet.Name = "ten new name her...
@Anders: this poster has three posts all relating to the same data. Doesn't say which version he's using but this is the file he attached in one o...
Hi, you can determine the quarter using the following formula ROUNDUP(MONTH(A3)/3,0) this will return 2 in your case, then you will have to integra...
If you can do it manually ... then you could also do it with a macro. Start the macro recorder and record every step you do until you reach the des...
Without the file I cannot tell, but the first thing YOU can do is check if the referred sheet "Sept 9th" exists. You cannot select a non-existing s...