Final Stretch △ Event for Columns / Pull Data Separate Wkst △ Values ►►►

**xsoldoutx** · 08-22-2012, 08:37 AM

Reason:
Ok please see my spreadsheet below for what I would like, but would prefer a VBA alternative. The spreadsheet works fine for the given example because I have used several array formulas to pull in my information. My problem occurs when I create several hundred array formulas (drag the formula down 500 some lines), which slows down the entire process and has caused box checker macro not to work.

Question:
Therefore would it be possible to have an event change every time someone double clicks in column A or B to have the entire row go into the correct tab? In additiion to if a box is unchecked then have it be removed from the tabs? If you have an alternative way or a better way to implement this task I am more than willing to listen.

In addition:
Would it be possible to have the information go into alternating rows by skipping a row for Reverse Transaction tab, but in order for Exclude Transaction tab?

Help:
The font in column A & B is Marlett in order to get the ✓, which is really an "a"

Thank you in advance for your help!

**xsoldoutx** · 08-22-2012, 09:22 AM

I'm not sure if this is helpful or not, but if you don't have a fully complete solution that's perfect too, I'm hoping someone can get me started on the right path in order to tweak it down the road. Thank you!