Posts by Daniel Bennett76

Need some help here 🙂
I need to compare Sheet 1 and Sheet 2 to find discrepancies in column B. For example, in column A, XXX has a value of 100.00 on Sheet 1 and the same on Sheet 2, but YYY has different values (Sheet 1 shows 200, while Sheet 2 shows 250). I'm trying to identify which items don't match.

A B
XXX 100.00
YYY 200.00
ZZZ 300.00

A B
ZZZ 300.00
XXX 100.00
YYY 250.00

I know there's a way to do this using VLOOKUP or LOOKUP, but I'm just not sure how to set it up.

Nicholas King said:Nobody is attacking you. If you look through this thread, you'll see nobody ever gets attacked here, no matter how basic their question might be (back when I was learning this stuff, people were always willing to help me out, so I guess you just feel an obligation to pay it forward to those learning now). But, I agree, the way you handled yourself could have been better.

I don't think attaching actual data is the best move unless there's absolutely no other way to show the problem. 🙂

From what I can see, the link I posted does exactly what you need, and the dialog box for setting things up is pretty intuitive. You can pick which sheet to pull from, the merge method, all that stuff.

I used your link to get it done. Thanks!!! 🙏

1. I need to copy data from 654 different Workbooks into a new SUMMARY.xls Workbook. None of them are open, and they’re all sitting in the same folder as the SUMMARY.xls
2. I only need the data from Sheet 2. All the sheet names are identical.
3. The table layouts are pretty much the same across all files.

Since you guys shut me down right out of the gate, I'm actually kind of embarrassed to even attach my "work" here. 😁

I'll try to figure it out using the links you provided. Thanks a lot!

😕

If anyone actually knows how to fix this and is willing to lend a hand, I’d really appreciate it.

Aha. I need to merge about 500 to 600 documents into one single file. We're talking roughly 150 docs every month.
Do you actually have a suggestion, or are you just curious?

Can anyone help me out here?
I'm trying to figure out how to merge multiple Excel files into one single workbook, where the data from each subsequent file just gets appended directly underneath the previous one.
Hopefully, that makes sense.

Great post and thanks for such a detailed breakdown. 🙏
My mom used to say something similar... she mentioned that the water color isn't always the same once you're finished.
If you don't mind me asking, how much did that device set you back?

Angela Wright, I'm dying to see how this turns out. Don't forget to give me an update.

So, my mom tried these treatments and claims they actually worked for her. She usually struggles with swelling in her legs, which makes walking pretty rough, but after a few sessions, she says she was practically sprinting up the stairs. Now she's thinking about buying a machine herself, so I've started doing some "research" into whether this stuff actually does anything.

The thing is, I've been browsing some international sites that claim this is all just a massive scam...

How reliable is this source?

I really can't stand the worldview of the people I know who listen to mainstream country music.
There’s just something about that genre that gets under my skin; after being exposed to it for more than a few minutes, I start feeling genuinely agitated...

Richard Murphy6 said:Hey man (Thomas Harris), just tell me, do you have any siblings? I'm working on a theory about how these character traits develop.
I'm guessing you've got at least two—a brother or a sister. Correct me if I'm wrong.

I have a younger brother and an older brother. 👍

I've copied over everything I deal with regarding my OCD:

-superstitious beliefs
-tics
-avoiding stepping on cracks
-being distracted by things that aren't perfectly aligned—like a floorboard being slightly uneven, which I can't stop thinking about.
-hand washing (it used to be more frequent, but I've got it under "control" now)
-counting my steps while walking
-an obsession with symmetry; everything needs to be symmetrical and parallel
-everything has to be a round number, or an even number, or unwashed if it's a number like 7. There are "good" and "bad" numbers. For example, 7 and 15 are good, but 6, 16, and 13 are bad—ugh. Just writing them down makes me feel uneasy and I'd rather delete this, but I won't—I'm fighting it. J
-always turning around to check if someone is behind me.
-compulsive touching of various objects
-repeating movements multiple times
-depression
-sometimes a specific word pops into my head and I feel this overwhelming urge to say it out loud; I just have to.
-repeating words internally several times

I went to see a psychiatrist to talk things through because my symptoms get a lot worse whenever I'm stressed. For instance, I'll sit down to study and realize I'm counting lines on the page instead of actually reading.
Basically, the doctor said it's only classified as Obsessive-Compulsive Disorder when it interferes with your "normal" daily functioning and lasts for more than... I don't remember the exact timeframe, but maybe more than an hour a day. Everything else is just obsessive-compulsive behaviors.
She compared it to how some people just stare out the window when they're bored, whereas people with compulsive behaviors are doing something else—counting, making sure they don't step on cracks, etc. Anyway, she sent me home and told me not to worry too much about it, but said if things get worse, I could always come back to talk.
I have to say, that conversation really calmed me down, and the compulsions have actually decreased since then; I feel like I can control them. Unfortunately, they do flare up under stress.
And yeah—my mother has compulsive behaviors too. She only admitted it after I opened up to her first.