Results 1 to 3 of 3

push data to another worksheet based on a choice of 4 cells being checked

Threaded View

jayers push data to another... 01-01-2009, 02:25 AM
royUK Your post does not comply... 01-01-2009, 04:52 AM
ravishankar Hi try these codes ... 01-02-2009, 09:34 AM
  1. #1
    Registered User
    Join Date
    12-31-2008
    Location
    Chester, CA
    MS-Off Ver
    Excel 2007
    Posts
    20

    push data to another worksheet based on a choice of 4 cells being checked

    Can someone help with a VBA code - here is the scenario

    I am a teacher and have a grade and credit sheet that I need to push or copy
    values (not the formulas) from columns on one sheet to another sheet. I used something like this in my first worksheet (called Grade-
    Credits)
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("T2")) Is Nothing Then
    Sheets("Progress Report").Range("C7:C49", "D7:D49").Value = _
    Me.Range("APR5:AP47", "AR5:AR47").Value
    End If
    End Sub
    BUT - I need ("APR5:AP47", "AR5:AR47") to be copied to different columns if T2 is blank and U2 is checked instead (or has a value in it), the same for V2 and W2. T2, U2, V2, and W2 represent school year quarters.

    Thanks - Jim A
    Attached Files Attached Files
    Last edited by royUK; 01-01-2009 at 04:53 AM.

Thread Information

Users Browsing this Thread

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

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