Max's Excel Samples Archive [Excel Newsgroups]

Title: Max's Excel Samples Archive [Excel Newsgroups]

Description:
Hi, here's a d/l listing of Excel samples complementing some of my responses made in various xl newsgroups. Zippacks (zp) are *separate* collections of samples. Pl post queries in the excel newsgroups, not via private email to me. Enjoy.
Max, Singapore

[link to this project] [link to Savefile.com]

1_zp_56 Samples_Max_04Nov2005.zip

filetype: .zip
|
filesize: 0.96MB
|
date: 01.09.2009

2 variable data table example.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 08.09.2009

2_zp_27 Samples_Max_08Dec2005.zip

filetype: .zip
|
filesize: 0.25MB
|
date: 01.09.2009

3_zp_34 Samples_Max_26Jan2006.zip

filetype: .zip
|
filesize: 0.31MB
|
date: 01.09.2009

4_zp_64 Samples_Max_30Mar2006.zip

filetype: .zip
|
filesize: 0.43MB
|
date: 01.09.2009

5_zp_40 Samples_Max_22Jun2006.zip

filetype: .zip
|
filesize: 0.44MB
|
date: 01.09.2009

6_zp_23 Samples_Max_07Aug2006.zip

filetype: .zip
|
filesize: 1.67MB
|
date: 01.09.2009

Address n Name Manipulations.xls

filetype: .xls
|
filesize: 0.03MB
|
date: 24.10.2009

Apportion days within a date range under month col

filetype: .xls
|
filesize: 0.02MB
|
date: 14.04.2009

Auto consolidate rows by input codes in new sht

filetype: .xls
|
filesize: 0.03MB
|
date: 13.09.2009

Auto sort an array.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 27.02.2009

Auto sorted range above source range.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 06.09.2009

Auto-descending sort by selectable col header

filetype: .xls
|
filesize: 0.02MB
|
date: 09.12.2009

AutoCombine Dynamic Lists.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 06.08.2009

AutoCopy Accepted Lines to MthYr Sht.xls

filetype: .xls
|
filesize: 0.11MB
|
date: 22.09.2009

AutoCopy By Key Col to Resp Shts.xls

filetype: .xls
|
filesize: 0.37MB
|
date: 24.07.2009

AutoCopy data over to monthly sheet positives only

filetype: .xls
|
filesize: 0.04MB
|
date: 12.09.2009

AutoCopy data to separate shts by key col value.xl

filetype: .xls
|
filesize: 0.03MB
|
date: 05.09.2009

AutoCopy Lines by Emp IDs to Resp Shts.xls

filetype: .xls
|
filesize: 0.05MB
|
date: 17.11.2009

AutoCopy Lines by Key Col to Resp Sheets.xls

filetype: .xls
|
filesize: 0.04MB
|
date: 10.06.2009

AutoCopy Lines to Indiv Sheets by Key Col.xls

filetype: .xls
|
filesize: 0.08MB
|
date: 07.07.2009

AutoCopy Lines to Resp Sht Non Array.xls

filetype: .xls
|
filesize: 0.06MB
|
date: 21.01.2009

AutoList_in_Desc_Order_by_GPA.xls

filetype: .xls
|
filesize: 0.03MB
|
date: 04.03.2009

Automated Competency Assmt-Devt Plan.xls

filetype: .xls
|
filesize: 0.1MB
|
date: 17.12.2009

Automated Order Summary.xls

filetype: .xls
|
filesize: 0.03MB
|
date: 22.11.2009

AutoUpdate 12 mth budget.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 26.08.2009

Auto_populate_from_master_to_child_shts.xls

filetype: .xls
|
filesize: 0.05MB
|
date: 17.01.2009

Auto_update_of_sheets.xls

filetype: .xls
|
filesize: 0.04MB
|
date: 04.03.2009

A_simple_enquiry_sys.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 04.03.2009

CF color rows for identical successive col A value

filetype: .xls
|
filesize: 0.02MB
|
date: 15.11.2009

CF_Dates_Traffic Lights.xls

filetype: .xls
|
filesize: 0.01MB
|
date: 15.05.2009

Combo box from control toolbox toolbar_Example2

filetype: .xls
|
filesize: 0.02MB
|
date: 03.11.2009

Complex Criteria Report Generation.xls

filetype: .xls
|
filesize: 0.06MB
|
date: 22.04.2009

Complex Lookup - Inventory Matching.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 26.08.2009

Complex lookup on multiple var.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 30.06.2009

Display Multiple Selections wo Blank Columns.xls

filetype: .xls
|
filesize: 0.03MB
|
date: 14.06.2009

DV n vlookup example.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 12.03.2009

Dynamic_DV_over_several_shts_for_unique_selections

filetype: .xls
|
filesize: 0.02MB
|
date: 30.06.2009

Exec Summary.xls

filetype: .xls
|
filesize: 0.04MB
|
date: 11.12.2009

Extract checkbox selections into col.xls

filetype: .xls
|
filesize: 0.03MB
|
date: 22.01.2009

Extracting_from_multiple_shts.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 15.03.2009

Generating combinations from column data.xls

filetype: .xls
|
filesize: 0.18MB
|
date: 24.09.2009

Interactive Summary.xls

filetype: .xls
|
filesize: 0.03MB
|
date: 15.01.2009

Listing duplicates n their row numbers.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 06.11.2009

Lookup_multi-crit_across_multi_shts_v2.zip

filetype: .zip
|
filesize: 0.34MB
|
date: 05.10.2009

Maintenance Contract Tracking Sys.xls

filetype: .xls
|
filesize: 0.25MB
|
date: 22.08.2009

Matching multiple criteria.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 15.03.2009

Merge data rows from 2 sheets at fixed ratio.xls

filetype: .xls
|
filesize: 0.14MB
|
date: 16.12.2009

Military Leave Tracking Model.xls

filetype: .xls
|
filesize: 0.21MB
|
date: 03.01.2009

Multiple criteria match n extract multiple results

filetype: .xls
|
filesize: 0.02MB
|
date: 04.02.2009

Multi_criteria_match_n_extract_multi_results_2.xls

filetype: .xls
|
filesize: 0.03MB
|
date: 04.02.2009

MyrnaLarson_Combination_Permutation.xls

filetype: .xls
|
filesize: 0.05MB
|
date: 26.02.2009

Parent to Child AutoCopy Model based on KeyCol Val

filetype: .xls
|
filesize: 0.04MB
|
date: 23.12.2009

Pivot cum index n match.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 14.12.2009

Plotting risk map w hyperlink to risk register.xls

filetype: .xls
|
filesize: 0.04MB
|
date: 31.05.2009

Project_TimeLining_v2.xls

filetype: .xls
|
filesize: 0.03MB
|
date: 06.04.2009

Property_Maintenance.xls

filetype: .xls
|
filesize: 0.1MB
|
date: 31.05.2009

Query multiple results in other sht.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 16.07.2009

Random scrambling a col list n rearrange into a gr

filetype: .xls
|
filesize: 0.03MB
|
date: 26.08.2009

Random_scramble_in_a_3_x_3_grid_in_other_sht.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 16.12.2009

Simulation using Data Table for optimal lineup_Min

filetype: .xls
|
filesize: 0.14MB
|
date: 14.02.2009

Splitting into TimeSlots.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 17.01.2009

Summary of last data rows.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 14.12.2009

Two_variable_data_table_example.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 13.11.2009

Using_a_one_var_data_table_for_multiple_inputs-out

filetype: .xls
|
filesize: 0.02MB
|
date: 17.01.2009

Workstation Scheduling 24hr x 36 seats x 100 staff

filetype: .xls
|
filesize: 0.46MB
|
date: 31.07.2009

YTD averaging across repeated cols.xls

filetype: .xls
|
filesize: 0.02MB
|
date: 18.09.2009

Type your email adress below to receive notification when the owner updates this project