august

Hi, Struggling with this and not sure why. I want to look through the range of cells and offset any cell with essentially a date in it. ie. B3 contains Saturday 26 August 2017, B11 contains Sunday 27 August 2017. There is no regular pattern to this so need to look within all cells in the...

Dears, I'm a super noob with excel vba macro, I was able to write some codes time to time by adapting already existing ones from the net or via macro recording. This time I was not able to find a solution wandering through the net, I'll try to explain what I would like to achieve. I have an...

Is there anyway I can have a hyperlink reference a cell which stays on the same sheet it's on? So for example, if I have a hyperlink going to cell B28 in the sheet named 'August', I want to be able to copy that sheet and name it 'September'. However the link stays with the B28 cell in the...

Hi Guys! I feel that this is a simple problem, but I am unable to fix my formula. Say, on A1 I have 1 date, another date on A2. e.g A1 date = August 4, 2017 A2 date = August 5, 2017 on A3, I have this formula: =IF(A1="","",TEXT(A1,"mmmm dd, yyyy")&" until "&TEXT(A2,"mmmm dd, yyyy")) On...

Hi, I am still looking for an answer to the below issue that I can work in to the actual spreadsheet The master version has many columns that I have listed below Master workbook <tbody> July July July August August August Client Agency BDM Value Format NEW Status Media...

Hi, I am looking for an answer to the below issue that I can work in to the actual spreadsheet The master version has many columns that I have listed below Master workbook <tbody> July July July August August August Client Agency BDM Value Format NEW Status Media Production...