programs

Hello. I'm looking for suggestions on how I would go about modernizing this. In short, I have a table that lists employees and splits their allocations across multiple programs. It is in its own workbook, and I currently link several workbooks to it. Picture this table with many more...

I have about 100 programs that I am testing. I have aspread sheet to track the results. I am trying to execute the programs fromExcel using hyperlinks but that has problems. Would it be possible to do thiswith a VBA? Maybe use a case switch for the programs?.

Hi there, I need to create a few dependent drop down lists driven from the results based on Customers. Example: Customers: Honda, Ford, GM, Vovlo, etc... Honda Plants: HCM, HMIN, KTH,KSM, MAP Honda Programs: Accord, Civic, CRV Ford Plants: Monroe, Dearborn, LAP, KCAP For Programs: V363...

I have a large list of Programs and I need to easily be able to pull the Programs that have the Top 5 variances both positive and negative. Below is the sample data. Any help much appreciated! <colgroup><col><col span="2"><col></colgroup><tbody> Actual Plan Variance Program 1...

I have a daily report that is published every morning - we'll call it "Capital Programs Report". From this report there are 388 columns of data that is ever changing. I need to create my own Tracker to consolidate this data down to about 30 columns that I care about, so I can work off of this...

Hi, I'm trying to set up a budget tracker which could be for up to 10 various programs. Each worksheet has the below information with a list for the service such as DATS (there are also MH & AH). On the summary sheet I will have tables for each of DATS/MH/AH programs etc and want to pull...

Hello! I have about 10,000 rows of data that I need grouped based on certain criteria and I am trying to figure out a way to group them without doing it manually. Below is the sample data and the groupings I am trying to achieve. Any help is much appreciated! Thanks!!! Total Data <tbody>...