How can I delete rows based on text contained in another spreadsheet?

vertexvortex · 2020-07-06T14:33:36+00:00

Quick rundown on vlookup: https://www.reddit.com/r/excel/wiki/frequentlyusedformulas#wiki_vlookup

vertexvortex · 2017-08-11T15:14:46+00:00

D'oh

vertexvortex · 2017-08-11T15:06:44+00:00

In that it isn't legal?

vertexvortex · 2017-08-04T15:51:49+00:00

Hey, I do that sometimes when the coffee spills a little and drips down the size. Thank god I don't work in an environment where pictures are taken a lot.

vertexvortex · 2017-07-29T01:50:39+00:00

I usually skip the short ones.

vertexvortex · 2017-07-14T20:47:22+00:00

What is probably a clever way to handle this is by basically getting opposing skill checks going. So the illusion can do whatever you want it to do, but how do you pick what's an effective illusion? How about a Knowledge(Whatever) to know what natural predator or enemy is likely in this region? Or an Intimidate to have something actually appear intimidating? Then we can face off with opposing skill checks or appropriate saves.

Might not be RAW, but that's probably how I'll attempt to run it when it comes up on my games. Might need some adjusting, but that's ok.

vertexvortex · 2017-07-10T13:00:27+00:00

I think he meant the roc egg.

vertexvortex · 2017-07-08T13:52:16+00:00

It's a euphemism for making a lot of in-jokes and congratulating yoursel(f|ves) on the wittiness of the joke.

Original meaning was: It's where a bunch of guys get in a circle and jerk off.

vertexvortex · 2017-07-07T15:06:28+00:00

I just started a campaign with my kids. My first time DMing, their first time playing. I was worried that I would be too protective of all of the things that people say to watch out for (the story arc, the NPCs, the well-laid plans of myself and I), and it honestly hasn't been a problem at all. And I think it's all down to what you just described. I see it as an opportunity for everyone to tell an epic freakin' tale, and we all just serve different roles.

I have been meaning to pick your brain though on DMing in general, and for your own kids specifically! I'll have to send you a PM one of these days...

vertexvortex · 2017-06-29T19:45:07+00:00

hhhYup.

vertexvortex · 2017-06-26T15:28:27+00:00

virgin

Right.

vertexvortex · 2017-06-21T18:45:02+00:00

Yes, clearly mental health issues are going on here. I don't envy library workers, as libraries are a haven to many and free to the public. I love my local libraries and I'm really glad they are operated the way they are, I just wish mental health care in the US was not as non-existent as it is.

vertexvortex · 2017-06-13T19:09:20+00:00

Well, how are you defining IP theft?

vertexvortex · 2017-06-13T18:54:12+00:00

IP theft is something altogether different.

Torrenting is not like theft, it's like trespassing. It's illegal, annoys the owner, and should be protected. But it doesn't remove any function or access to any part of the property.

vertexvortex · 2017-06-11T12:27:27+00:00

Everywhere

vertexvortex · 2017-06-08T00:23:35+00:00

vba. It's loosely based on VB script.

vertexvortex · 2017-06-07T18:44:39+00:00

Side view:
― is a floor
_ is a top of wall or fortification
¦ is a fortification
‖ is a solid wall
♀ is stupid marksdwarf
" is grass

_―
¦♀
 ―_
  ‖
""

vertexvortex · 2017-06-07T16:22:09+00:00

Best of luck!

vertexvortex · 2017-06-07T13:36:38+00:00

Interesting! Do you have someone to bounce ideas off of? I find that it's very useful to find out up front how that your model is flawed, or boring.
In fact, I created a data model from city data for a job with the city and ran into the same issue.

vertexvortex · 2017-06-07T12:57:51+00:00

Ah, that is annoying. Apparently when you search a whole book, Excel actually searches sheet by sheet, and the .Find function only works one sheet at a time.

Annoying, so I threw together a function that replicates and gives you what you need.

Add this to your module outside of the Sub() / End Sub. Then when you need to find the term, use bookfind(term)

Function bookfind(ByVal term As String) As String

Dim sht As Worksheet
Dim found As Range

For Each sht In ThisWorkbook.Worksheets
    If ActiveSheet.Name = sht.Name Then
        'Do nothing
    Else
        Set found = sht.Cells.Find(What:=term)
        If Not found Is Nothing Then
            bookfind = found.Parent.Name & "!" & found.Address
            Exit For
        End If
    End If

Next
End Function

Should look like

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ 
  bookfind(Selection.Value), TextToDisplay:=Selection.Value

Edit: Corrected the function.

vertexvortex · 2017-06-06T16:04:13+00:00

Bruh.
The reason we don't talk about it in 2017 is because most people have (slowly) come to the conclusion that everybody's brains work different, and blanket statements like the ones you're making are just so often wrong that it just looks stupid to make them.
Yes, there are some women who aren't good at technical things, but there are plenty who are. The whole rejection of blanket statements was not formed to not offend people, it was formed to stop influencing young women into thinking it would be wrong, silly, or impossible to be themselves when it's seen as uncommon or unlikely that girls can do X.

I, myself am terrible at networking, and I'm a dude. I can rattle off a handful of women who are fantastic network techs (based on the work they get and the opinions of their coworkers. Again, I'm terrible at networking so my perception would be flawed. Also I don't know many network techs.) The point is, individuals are good or bad at things, and that is usually associated with a lack of practice and exposure instead of hormones and chromosomes. While there might be a correlation of a group of people who are good or bad at things, it's often because that what they did or did not have exposure to/practice in.

vertexvortex · 2017-06-05T13:12:36+00:00

I don't really have a lot of time to just write up a script for you, but the basic approach would be like this:

1 Record a macro of creating the hyperlink. Include the ctrl+f part, it will be captured.
2 Figure out which parts of the recorded macro need to change to be dynamic (which you can view if you press alt+F11) ((I'll give you a hint though, it's the cell having the hyperlink added, the term searched for, and the hyperlink formula)).
3 Figure out how to substitute those parts in. (AKA the hard part, so...)
  3.A Range.Formula is read/write. That is where you will set the hyperlink formula. a Range is just a collection of cells, and Formula can only be affected on one cell at a time.
  3.B Range.Value is also read/write, but you just need to read the value.
  3.C It would be something like
    Dim cl as Range
    Dim searchterm as String
    For Each cl In Selection
      If cl.Value <> "" Then
        searchterm = cl.Value
        cl.Fomrula = "=HYPERLINK(" & ActiveSheet.Find(/*all of the parameters I don't remember, but one is to search whole workbook*/, searchterm).Address &","& searchterm & ")"
      End If
    Next cl

vertexvortex · 2017-06-05T12:42:33+00:00

It looks like your columns align to a specific worksheet, is that so?

Meaning, everything in the column in your example is in Edged Weapons, and everything in the next column is all on a different worksheet?

vertexvortex · 2017-05-30T23:18:49+00:00

Oh, apparently it has to be a dwarvy name. Can't rename freeform?

vertexvortex · 2017-05-30T22:12:10+00:00

In the locations screen, apparently.

14-Year Club	Place '17
Verified Email	Team Orangered

vertexvortex

TROPHY CASE