Forum

You don't need a script. All the users run the networked copy of the add-in so, when changes are made to that, they automatically get them the next ti...

I'd suggest you read Ken's article here:

Like this: Open LOutputPath & "" & format(now, "hh-mm-ss"".txt""") For Output As #1

I think you'd just use an XY scatter chart and add a dummy series to label the vertical axis. See attached example.

You could check to see if the sheets already exist like this: Sub test() Dim template As Range Dim tabblad As Worksheet Set tabblad = ThisW...

Are the sites always in the same order as in your example? I'd suggest using a couple of helper columns and a helper row to avoid repeated loo...

This part: ((acuriteweather[Date]=D5)*(acuriteweather[Outdoor Temperature]=G5)) creates an array of 1s and 0s. Multiplying by the time stamp ret...

If you mean the password to open the file, simply open it (supplying the password) then select File - Protect Workbook, Encrypt with password and clea...

What exactly is the issue? If it's just getting them on the same row, set the pivot table layout to tabular.

You can also fix it by not clearing cells that are actually empty (which is after all fairly pointless) by making a small change to the condition: ...

For your max temp time: =AGGREGATE(15,6,1/1/((acuriteweather[Date]=D5)*(acuriteweather[Outdoor Temperature]=E5))*acuriteweather[Timestamp],1) Fo...

Hi Anders, You are correct. It’s force of habit I think that made me write 1E100! In truth, you could either use: =IFERROR(LOOKUP(1E+100,SE...

You could also use LOOKUP like this: =IFERROR(LOOKUP(1E+100,1/SEARCH(list,A2),list),"No match")

Purely for information, you could also write that like this: =G2*IF(OR(C2={"Service Fee","Credit"}),8%,4%)

You're welcome.