Monday, June 2, 2014

yogi_Pull From 'Transaction Log' sheet Data By Client And Rearrange Per Specification


                                         Google Spreadsheet   Post  #1662
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-02-2014
post by Polish user: (https://productforums.google.com/forum/#!msg/docs/mlv8M9M7pIE/otx4ni6p5YwJ)
How to automatically copy data from one sheet to other sheets based on criteria
Hi,

I have been stuck with this issue for a while now. I have been trying to explore some formula / script that could help me copy data from a log, that acts as a database, where daily records are kept, and copy certain cells to other sheets, based on certain matching criteria.

For example, I have a transaction log, where I record daily transactions with certain fixed clients. I have Client A and Client B, that do various transactions daily. I maintain a separate sheet for each client, where I am able to view transactions related to that client only.

Currently, at the end of each day, I manually make reference to each cell on the transaction log, to be able to have this data related to each client on their respective sheet. I am looking for a way, in which data related to each respective client could be copied / referenced automatically, each time I add new data to the Transaction Log.

I am posting the link to the Test page, to be able to better understand the issue. : 


Thanks in advance for the help. It would be very helpful  to me.
------------------------------------------------------------------------------------------------------------------------------------------------------