august

  1. E

    VBA IF/THEN not working

    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...
  2. M

    VBA to loop among filter criteria in a specific column

    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...
  3. B

    Hyperlink on same sheet

    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...
  4. B

    Show blank if cell is blank

    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...
  5. C

    Need help finding a formula that will work

    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...
  6. C

    Cross workbook referencing without blanks

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top