bunch

Hello all, I'm currently running Windows 10 - Office 2013. I'm getting a new machine, is there a way to copy all my new tabs from my customized ribbon to my new machine. Normally, I just take a bunch of screenshots and the redo them on when I get a new machine; but, this is a lengthy process. Brian

I have like 15 Modules in my workbook, I have no idea why 14 of them are there. I don't know that much about VBA so I don't know if they are needed. I do have a bunch of buttons connected to macros. Is this a glitch?

I have this equation {=INDEX(F7:AS7,1,MATCH(MAX(IF(F6:AS6>0,F6:AS6)),F6:AS6,0))} row 7 is a bunch of names what i want returned row 6 is maybe some numbers and maybe 0 and could all be 0 if all of row 6 is 0, i want the equation to return nothing. Now if they all go to 0, it retuns the last...

Been trying to put together a macro that has the ability to send three emails to different addresses. The kicker is I want each email to take a picture of a range in the sheet and add it to the body of the email. I have tried a bunch of ways but continue to run into errors. Any help would be great.

I have a bunch of dates down column E (Due Dates). And I have a bunch of dates down column F (Completion Dates) I am trying to create a CountIfs formulas that would show How many were completed on time and how many were completed late between two date (example 10/1/2018 and 10/31/2018) Or...

Ok, I got a bunch of data rows with the following kind of data: FACILITYID</td><td>H1676</td></ FACILITYID</td><td>PN1354</td> FACILITYID</td><td>61523/54712</ ... and so on. I need to extract the unique data, no matter the length, from each cell. Unfortunately, a lot of characters like "<"...

OK for some reason while using a bunch of named ranges to clear out the data the borders get changed to the heavy border. So after a bunch of playing around with it I see that if I run the sub with nothing in the cells to clear it doesn't change any formatting. But I type something in the top...

Over a couple years, I think a large file that I've created has become corrupt or bloated, and I'm recreating it from scratch in a new .xlsm document. I don't want any vestiges of the old file to remain (since I want the 'cleanest' new file possible). 1) I first Find/Replaced all of the '='...

This can't be complicated... I have a huge amount of cells with figures already inputted into them. I would like to simply add a percentage to those cells. Thanks a bunch L

Hello everyone. I have the following scenario: I have two tabs. In sheet A col C I have a bunch of computer names. In sheet B col B I have a bunch of computer names. What I would like is to compare the two lists, and if there is a match, that match is highlighted in the first sheet. How would...

Hello Guys, I need to create progress bar using userform. I have bunch of macros and using those with Call function to run all macros. I have more than 50 Call functions. I find only simple progress bar codes with basic macros. But i need to accommodate all my macros. Anyone knows how proceed...

Hi all! Love the forum and always get my questions answered through a search, but cannot seem to find an exact answer for what I'm looking for this time. I want to do a sumproduct of the values in columns A*B only if there is text in column C (not blank). I've tried a bunch of variations but I...

I'm having trouble finding a solution to this problem. Basically, I build a bunch of workbooks for colleges and I like to have the colors match the school colors as much as I can. I can make themes for each school, but eventually I lock off a bunch of formatting functionality, so the end result...

Hi all so i need help with something tried for about 3 days now and cannot figure it out, ive tried looking at google but to no avail basically i have a huge spreadsheet with differnet headings i need to compare 2 values of each row. Heading "priority" and heading "pass/fail" so if the row...