View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Michael Wise[_29_] Michael Wise[_29_] is offline
external usenet poster
 
Posts: 1
Default Using checkboxes to determine what data to carry over


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