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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy rows to new sheet based on variable cell reference
John, et al;
Sorry, I didn't think about the sheet names when I made the file available for download. Sheet1 in my file would be 'Printable Report'. The certifications are entered into A9:A24 on that sheet. They are referred to on the subsequent four sheets in cells D1:K1. For arguments sake, lets say "EMT" is in Sheets(Printable Report)"A9" and there is one entry on each of the subsequent pages (Classroom, CBT, Journals & Magazines, Other Training) that is applicable to the EMT certification (indicated by a checked box and relative TRUE value in the underlying cell). I want the user to be able to select "EMT" (the value of A9) from a combobox in a userform (I know how to do that) and then have a routine that would select all the rows on the subsequent sheets that have a TRUE value in that column (would be column D in our example) and copy them to another worksheet (will be 'Individual Summary') In short, the routine would need to find the matching rows and copy them into the next available empty row of the output sheet. Does that help? Thanks again, John Bundy wrote: I have your sheet but can't figure out what your asking. What data do you need and on what sheet do you need it? What sheet are you considering Sheet1? |
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 |