How to automatically copy a row of data from one worksheet to another according to a cell's value?

%3CLINGO-SUB%20id%3D%22lingo-sub-1151072%22%20slang%3D%22en-US%22%3EHow%20to%20automatically%20copy%20a%20row%20of%20data%20from%20one%20worksheet%20to%20another%20according%20to%20a%20cell's%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1151072%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EQUESTION%3A%20How%20do%20I%20copy%2Fexport%20a%20row%20of%20data%20from%20one%20worksheet%20to%20another%20based%20on%20the%20value%20of%20one%20cell%20in%20the%20row%3F%3C%2FSTRONG%3E%20Here%20is%20an%20example%20of%20what%20I'm%20trying%20to%20do%3A%20I%20want%20to%20chronologically%20track%20how%20many%20apples%2C%20pears%20and%20grapes%20I%20eat.%26nbsp%3B%20I%20also%20want%20to%20determine%20at%20any%20given%20moment%20how%20many%20apples%20or%20pears%20or%20grapes%20I've%20eaten%20and%20on%20what%20dates%20and%20also%26nbsp%3Bchart%20my%20fruit%20consumption%20to%20see%20whether%20my%20apple%20intake%20is%20greater%20at%20certain%20times%20of%20the%20year.%20So%20Sheet1%20is%20my%20data%20entry%20worksheet%2C%20where%20I%20enter%20in%20Column%20A%20the%20date%2C%20in%20Column%20B%20the%20quantity%20and%20in%20Column%20C%2C%26nbsp%3Bthe%20type%20of%20fruit.%26nbsp%3B%20I%20want%20this%26nbsp%3Brow%20data%20(in%20particular%2C%20the%20date%20and%20quantity)%20from%20Sheet1%20to%20be%20copied%2Fexported%20to%20Sheets%202%2C%203%20or%204%20based%20on%20the%20values%20in%20Sheet1's%20Column%20C%20(type%20of%20fruit).%20I%20know%20I%20could%20filter%20Column%20C%20(for%20apples%2C%20pears%20and%20grapes%20as%20the%20case%20may%20be)%20and%20then%20copy-and-paste%20into%20the%20appropriate%20worksheets%20but%20I%20want%20it%20to%20happen%20automatically%26nbsp%3Bwhen%20ever%20I%20make%20a%20new%20entry%26nbsp%3Bon%20Sheet1.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1151072%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1151106%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20automatically%20copy%20a%20row%20of%20data%20from%20one%20worksheet%20to%20another%20according%20to%20a%20cell's%20valu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1151106%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F544944%22%20target%3D%22_blank%22%3E%40Staggerlee123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20the%20FILTER%20function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Ffilter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Ffilter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

QUESTION: How do I copy/export a row of data from one worksheet to another based on the value of one cell in the row? Here is an example of what I'm trying to do: I want to chronologically track how many apples, pears and grapes I eat.  I also want to determine at any given moment how many apples or pears or grapes I've eaten and on what dates and also chart my fruit consumption to see whether my apple intake is greater at certain times of the year. So Sheet1 is my data entry worksheet, where I enter in Column A the date, in Column B the quantity and in Column C, the type of fruit.  I want this row data (in particular, the date and quantity) from Sheet1 to be copied/exported to Sheets 2, 3 or 4 based on the values in Sheet1's Column C (type of fruit). I know I could filter Column C (for apples, pears and grapes as the case may be) and then copy-and-paste into the appropriate worksheets but I want it to happen automatically when ever I make a new entry on Sheet1.

 

 

1 Reply