Search results

@Smallman thank you! That makes total sense. You = awesome

Good evening all, I'm working on a file that automatically sends two files to multiple To: recipients, based off of emails in column I, I'd like to also CC: the emails in columns J and K (because those will vary depending on the recipient) but I have no idea how to do that. Any help would be...

@SirJB7 it's impossible isn't it? I've been looking around and I haven't seen anything that would help me.

@SirJB7 Now servers and data centers are right up my alley! Those pictures do look much more enticing than what I'm used to though. Honestly hadn't heard of Carlsberg and I had to google it... (sorry)

SirJB7, Thanks again! I apologize, I don't think I explained well enough as to what I was trying to do. My end goal is to get separate workbooks by the person's name, each with two worksheets (Account Summary and Account Details), saved out in a designated folder.

Good morning SirJB7, thanks for all of your work on this! My goal was actually to have the "desired output" files saved separately by the person's name, ideally in a designated folder. Let me know if you have any ideas, I'm going to sit and stare at this code to try and figure something out...

And the code... Option Explicit Sub ParseItemsAcctSumm() Dim LR As Long, Itm As Long, MyCount As Long, vCol As Long Dim ws As Worksheet, MyArr As Variant, vTitles As String, SvPath As String Set ws = Sheets("Account Summary") SvPath =...

Desired Output

Sample file

Awesome, thanks! Posting a sample workbook now...

Good morning all, I think I have the meat and potatoes for this from my extensive Google research, just need a little help combining what I have. Currently I have two macros that look at two separate worksheets and parse them into separate files based off of common values. My first macro does...

To clarify, the tables I'm looking up may or may not contain relevant data (hence the IFERROR statement).

Help! Totally lost here...For this equation I'm trying to take a value (N9) and subtract the amount of that value that is pending deactivation(I9), then from that amount I want to subtract values prior to applying a discount (1-$O$3), and then adding those values back and then multiplying by the...

Thanks Narayan! It works perfectly. You = awesome.

=IFERROR(IF($E9="","",IF(AND(VLOOKUP($A9,PIVOTS.LOOKUPS!$BP:$BP,1,FALSE)=$A9,VLOOKUP($A9,PIVOTS.LOOKUPS!$BS:$BS,1,FALSE)=$A9),"DP & KM",IF(VLOOKUP($A9,PIVOTS.LOOKUPS!$BP:$BP,1,FALSE)=$A9,"CONVERT TO KM",IF(VLOOKUP($A9,PIVOTS.LOOKUPS!$BS:$BS,1,FALSE)=$A9,"CONVERT TO DP","")))),"") This formula...

Hey! I'm really new to VBA but so far I'm in love! I work for a tech company in St. Louis.

I'm working on developing a sales tool to be distributed to various sales teams, currently I have it set where you can select the sales person by a drop down list. I'd like to make it require a unique password on a per sales person basis, so the different sales people can't see each other's...