Wednesday, May 29, 2013

yogi_Pull The PaidOut Amounts And Post Those In A Separate Sheet For Each Category

                                          Google Spreadsheet   Post  #1219
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May 29, 2013
user pravrama  (!mydiscussions/docs/hyTGEFYh3Ww)
Copying cell contents to another sheet
Hi all,

I wanted copy cell contents from one sheet to different sheets depending on the category selected.  For example, if I entered a value and categorized it as 'construction costs', i wanted the value to copy to the 'construction costs' sheet.  Any ideas how I can do that?  Thanks so much for any help!!
Thanks Yogi for your reply. 

I'm trying to figure out 2 things:
(1) In 'Paid Out', how to create a drop down box in column A where I can choose Lawyer, Architect or Construction

(2) Once I choose a category, I want to copy the 'Amount', 'Reason' and 'Date' columns over to its respective sheet. 

The first point isn't as critical if we can accomplish the second in an easier way.  Thanks, I appreciate your help with this.