Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Your looping over all cells in Sheet All PCE (Columns A to M of th filled rows starting in row 1) and making decisions on data offset from eac cell. (same row). Correct. Your code makes no mention of a sheet named MAIN and you certainl have given no insight into how 13 (or is it 26) checkboxes on MAIN woul relate to conditions on each individual row in ALL PCE. There are in fact 26 checkboxes on MAIN which reside's outside of an current association to what is currently coded. The text that reside in Cells B3:B15 and C3:c15 on (Main) are within one of the cells i each row on ("All PCE"). Hovering to the side is not particularly descriptive - are ther checkboxes in columns A and D, just D, just A The checkboxes are located in column B and C but they are not linked i any way I can select them and move them where I like. How do your checkboxes participate in the decision to copy each row? At this point my checkboxes do not participate at all. That is wher i'm having the trouble. I'm totally unaware how to associate th checkbox to the cell and then get it to relate within the ("All PCE" worksheet code. I'm sure after reading all this your thinking HUH? Because of the wa i've gone about it. I would zip it but the file comes up to big still Michae -- Michael Wis ----------------------------------------------------------------------- Michael Wise's Profile: http://www.excelforum.com/member.php...nfo&userid=699 View this thread: http://www.excelforum.com/showthread.php?threadid=39128 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Carry data into a new budget year w/o original file path name? | Excel Discussion (Misc queries) | |||
carry over data to other sheet - help needed | Excel Discussion (Misc queries) | |||
Use checkboxes with linked external data? | Excel Discussion (Misc queries) | |||
carry over data | Excel Worksheet Functions | |||
how to determine which checkboxes are checked | Excel Programming |