sequential auto-populate

Hi. I have a worksheet where each row lists a staff name and their supervisor. Some supervisors have multiple people reporting to them. I am wondering if it's possible to do the following on a separate worksheet: When I type in the name of a supervisor, each of their direct reports...

Hi Excel Experts, Am trying to find a macro that auto-generate doc ref number sequentially (at the last 3 digits on the right) based on same student's name everytime I click a button. (numbers in the middle are generated randomly). Expected output : Name RefNum (cell A2) Darwin...

Hey guys Firstimer here! Woohoo! I got an interesting problem. What I am trying is to do create a formula for which VLOOKUP will use column A in Exhibit 1, vlookup the info from Exhibit 2 and return the value in column B Exhibit 2. There is an extra vlookup that will use the contract number...

Hi, I am creating a master register for internal business documents, each shall have their own unique document number. I have a dropdown for cells under DIV and DOC, with list parameters on separate datasheet. I have a partial formula within DOCUMENT NUMBER column of =($A2&"-"&$B2&"-"&$C2)...

Hello, I am trying to do some basic VBA in my spreadheet, I just want to create an auto-open statement that inputs then next sequential number in column A1 every time the s/s is opened i.e.1,2,3,4 ..... I am using excel 2007 and my knowledge is very limited. I used a code already posted...