Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy rows to new sheet based on variable cell reference
I wasn't really sure how to search this in the archives so I didn't
find much, but here goes: I have created a workbook to track continuing education hours/credits for different certifications. There are two variable components: There are blanks on one sheet for up to eight different certifications, and then four other workseets to track different kinds of CE seperately (classroom, cbt, etc). The certifications are variable throughout the entire workbook based on a cell reference on the certification sheet (A1:A8) The values of these cells enter automatically on the subsequent sheets with checkboxes below to indicate if the CE is applicable to the corresponding certification above. The checkboxes are linked to the cells immediately beneath them, so a running hour total at the bottom for the individual certification is based on a SUMIF (TRUE) formula. I would like for the user to be able to generate a summary of all the individual training items that are applicable to the individual certifications in sheet1(A1:A8). On the sheet with the individual training items, they are laid out like this: Date Class Hours =Sheet1(A1) =Sheet1(A2) etc... The cell references are easy, the variable will always be a cell reference(Sheet1-A1) and the criteria for inclusion will be a TRUE value, but I've got no idea how to put that together. I've likely not explained this very well, so anyone willing to help can download the work in progress to see what I need he http://upload2.net/page/download/GO4...Blank.xls.html Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows to new sheet based on specific cell value | Excel Worksheet Functions | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
Copy rows to new sheet based cell reference, not value | Excel Discussion (Misc queries) | |||
Copy rows from one sheet to another based on a cell value | Excel Worksheet Functions | |||
Copy rows from one sheet to another based on a cell value | New Users to Excel |