Home

Automatically Copy Row to New Sheet if Criteria is Met

%3CLINGO-SUB%20id%3D%22lingo-sub-685042%22%20slang%3D%22en-US%22%3EAutomatically%20Copy%20Row%20to%20New%20Sheet%20if%20Criteria%20is%20Met%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-685042%22%20slang%3D%22en-US%22%3ELooking%20to%20get%20rows%20(only%20columns%20B%3AF)%20to%20automatically%20copy%20themselves%20into%20sheet%20%E2%80%9CHouse%20Piping%E2%80%9D%20from%20sheet%20%E2%80%9CReconnects%E2%80%9D%20if%20G%20value%20is%20Y.%20Preferably%20without%20overwriting%20previous%20data.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-685042%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-685131%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20Copy%20Row%20to%20New%20Sheet%20if%20Criteria%20is%20Met%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-685131%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F358532%22%20target%3D%22_blank%22%3E%40bradahles%3C%2FA%3E%26nbsp%3BThat%20is%20going%20to%20require%20VBA.%20Not%20beginner%20VBA%20either.%20Not%20advanced%2C%20but%20you%20will%20have%20to%20know%20how%20to%20trap%20when%20data%20is%20entered%2C%20validate%20the%20source%20info%2C%20then%20manipulate%20the%20destination%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20wouldn't%20be%20automatic%2C%20but%20you%20could%20use%20Power%20Query%20to%20do%20this%20on%20command%20much%20easier.%3C%2FP%3E%3CUL%3E%3CLI%3EOriginal%20data%20is%20in%20an%20Excel%20Table.%3C%2FLI%3E%3CLI%3ELoad%20that%20table%20into%20Power%20Query.%3C%2FLI%3E%3CLI%3Eif%20the%20G%20column%20has%20%22Y%22%20in%20it%2C%20keep%20that%20data.%3C%2FLI%3E%3CLI%3ELoad%20that%20result%20into%20your%20other%20sheet.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EThen%20just%20hit%20REFRESH%20periodically%20to%20keep%20loading%20that%20data%20to%20the%202nd%20table.%20Your%20source%20data%20will%20never%20be%20impacted%20by%20this.%20Power%20Query%20never%20ever%20edits%20the%20source%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E
bradahles
Occasional Visitor
Looking to get rows (only columns B:F) to automatically copy themselves into sheet “House Piping” from sheet “Reconnects” if G value is Y. Preferably without overwriting previous data.
1 Reply

@bradahles That is going to require VBA. Not beginner VBA either. Not advanced, but you will have to know how to trap when data is entered, validate the source info, then manipulate the destination info.

 

It wouldn't be automatic, but you could use Power Query to do this on command much easier.

  • Original data is in an Excel Table.
  • Load that table into Power Query.
  • if the G column has "Y" in it, keep that data.
  • Load that result into your other sheet.

Then just hit REFRESH periodically to keep loading that data to the 2nd table. Your source data will never be impacted by this. Power Query never ever edits the source table.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies