Results 1 to 4 of 4

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

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2012
    Location
    _
    MS-Off Ver
    Excel 2010
    Posts
    31

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

    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!
    Attached Files Attached Files
    Last edited by xsoldoutx; 08-23-2012 at 10:48 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1