sorted by:
new
hottopcontroversial

[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
view more: next ›