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. :
https://docs.google.com/
Thanks in advance for the help. It would be very helpful to me.
------------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment