Wednesday, July 31, 2013

Filtering Data of Master Sheet

Question:

( by tony.silveira )


all,
 
I have a form sheet that 2 employees use to input data into a master record.  then i have separate worksheets for each of the 2 employees to track their custom data for each customer.
 
My question, is it possible to pull specific client data into a worksheet based on who input it.  As an example:
 
My Spreadsheet has 3 worksheets:
"master"
"tony"
"sergio"
 
all data is input into the "master" sheet and both Tony and Sergoio enter their name when inputting a customer, so:
 
"customer A" was input by "sergio" and his name is in column A
"customer B" was input by "tony" and his name is in column A
 
so based on "column A" (either tony or sergio), "customer A" will only appear on "sergio's" worksheet.  "customer B" will only appear on "tony's" worksheet.
 
any thoughts?  many many thanks up front!

Solution:

Have a look at the following screenshot of Sheet 'Master' of my Spreadsheet:



And following is the screenshot of Sheet 'Tony':



I have the following formula in Cell A1:
=filter('Master'!A:E;'Master'!A:A="Tony")

And following is the screenshot of Sheet 'Sergio':


I have the following formula in Cell A1:
=filter('Master'!A:E;'Master'!A:A="Sergio")


I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.


I also take up private and confidential projects:
If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,

No comments:

Post a Comment