Results 1 to 12 of 12

Update corresponding cells on master sheet when data entered to filtered sheet

Threaded View

  1. #1
    Registered User
    Join Date
    04-27-2011
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    7

    Update corresponding cells on master sheet when data entered to filtered sheet

    Hi I am new to VBA and have a limited understanding of it’s workings.
    I want filter results from a master sheet onto separate sheets (achieved).
    The results on the filtered sheets have data that needs to be added to the row. So if I updated the filtered sheet , row C cell 2, then the master sheets corresponding row in column E will update the same line of information.
    Does that makes sense?
    The filtered data changes often, each time the macro is run (due to other parts of the master sheet being changed). The data I entered on the filtered results needs to be saved on the master sheet and when the filtered results change column C on the filtered sheet need to correspond with the master. So blank if it’s column E cell is blank or show whatever data is already there (not too important that part)
    Any help would be much appreciated. I have tried a number of things though I think I would confuse things if I quoted what I have tried as I am not a very competent user. Thanks.
    Attached Files Attached Files
    Last edited by Sumatied; 04-28-2011 at 11:51 PM.

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