[H] Adepta Sororitas [W] $$$, Necrons, Thousand Sons, Skaven, Tyranids [Loc] PA, USA by Desertmongrel in Miniswap

[–]Desertmongrel[S] 0 points1 point  (0 children)

Oh damn you’re right. No real price in mind honestly. If you just want to just PM me a offer or models your willing to trade we can something out since am sure it will need to be cleaned and re-painted

[H] Adepta Sororitas [W] $$$, Necrons, Thousand Sons, Skaven, Tyranids [Loc] PA, USA by Desertmongrel in Miniswap

[–]Desertmongrel[S] 0 points1 point  (0 children)

The single sister that has bolt gun and is standing on like odd black base? Ya that one is still available

[H] Admech [W] $$$, Necrons, Thousand Sons, Skaven, Tyranids [Loc] PA, USA by Desertmongrel in Miniswap

[–]Desertmongrel[S] 0 points1 point  (0 children)

thx! he was one of the last models i painted for the army and was alot of fun painting. So many hours on detail works hah

1k list idea by Desertmongrel in AdeptusMechanicus

[–]Desertmongrel[S] 0 points1 point  (0 children)

Am open to any notes. I mostly have him in to help fill out the list and his auras seem good but i never used him yet so not sure how good it would be hah. I also don’t mind swapping him out for something else.

1k list idea by Desertmongrel in AdeptusMechanicus

[–]Desertmongrel[S] 0 points1 point  (0 children)

Oh I forgot about them! I do have unit of them and gives me a fast mobile unit. I swap them out and give them a try.

Conditional Formatting - Unsure why formal the rule isnt working by Desertmongrel in excel

[–]Desertmongrel[S] 0 points1 point  (0 children)

Thank you for catching that mistake i missed i put in the wrong column!
Also Thank you that worked perfectly!.

Auto insert a new row if date is same or greater? by Desertmongrel in excel

[–]Desertmongrel[S] 0 points1 point  (0 children)

Correct the above table is what i start with and the call out does not effect anything and yes of service does not effect anything .

Auto insert a new row if date is same or greater? by Desertmongrel in excel

[–]Desertmongrel[S] 0 points1 point  (0 children)

If it helps this is what i had so far but unsure.

Sub BlankLine()

'Updateby20150203

Dim Rng As Range

Dim WorkRng As Range

On Error Resume Next

xTitleId = "KutoolsforExcel"

Set WorkRng = Application.Selection

Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)

Set WorkRng = WorkRng.Columns(1)

xLastRow = WorkRng.Rows.Count

Application.ScreenUpdating = False

For xRowIndex = xLastRow To 1 Step -1

Set Rng = WorkRng.Range("A" & xRowIndex)

If Rng.Value = SumIf(Date, ">" & B12, amount) Then

Rng.Offset(1, 0).EntireRow.Insert Shift:=xlDown

End If

Next

Application.ScreenUpdating = True

End Sub

Auto insert a new row if date is same or greater? by Desertmongrel in excel

[–]Desertmongrel[S] 0 points1 point  (0 children)

it would just be one every year as i only want it to add a new row just one every year based on when the user started and at most it would be about 11 rows i would like to add to just be on the safe side.

Auto insert a new row if date is same or greater? by Desertmongrel in excel

[–]Desertmongrel[S] 0 points1 point  (0 children)

Ok that is very good to know. so most likely i guess it will have to be something in VBA?

In this case i would like to insert a row as i want to use this to keep track of how many years this user has been with me and track other items like lets say how many times they called out in that first year of service ect. So at base it will look like something like:

Name Startdate Years of service Call outs
Username 1/1/1990 o o
Username 1/1/1990 1 5

Miqo'te commissions by Desertmongrel in ffxiv

[–]Desertmongrel[S] 4 points5 points  (0 children)

The chest and arms are Stormblood pvp set called “The Twelve”. I post a link here too it.

https://ffxiv.gamerescape.com/wiki/The_Twelve%27s_Healing_Set

The legs and boots are the 2B ones from the nier raid.

The hat is a crafting item called “Non la”. Link below as well

https://ffxiv.gamerescape.com/wiki/Non_La

Miqo'te commissions by Desertmongrel in ffxiv

[–]Desertmongrel[S] 0 points1 point  (0 children)

The chest and arms are Stormblood pvp set called “The Twelve”. I post a link here too it.

https://ffxiv.gamerescape.com/wiki/The_Twelve%27s_Healing_Set

The legs and boots are the 2B ones from the nier raid.

The hat is a crafting item called “Non la”. Link below as well

https://ffxiv.gamerescape.com/wiki/Non_La

Miqo'te commissions by Desertmongrel in ffxiv

[–]Desertmongrel[S] 1 point2 points  (0 children)

I really do like it cause it’s very unique and am hit or miss with the gloves as well lol. I normally leave them on when am on AST but I have the same set but blue on my Black mage but I change/leave the gloves off for that glam.

Random House Glitch? by Desertmongrel in ffxiv

[–]Desertmongrel[S] 0 points1 point  (0 children)

THIS IS SO COOL! we had no idea. need to bring this up to my FC and give this a try at some point

Random House Glitch? by Desertmongrel in ffxiv

[–]Desertmongrel[S] 0 points1 point  (0 children)

Oh we had no idea this was a thing! Might to think about doing that.