Saturday, June 11, 2016

yogi_From 'All depots' Sheet Pull Data For Each Depot Into Each Depot's Own Respective Sheet

Google Spreadsheet   Post  #2071
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-11-2016
question by: Jack Bayntun:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/xRjUDhvQTCg;context-place=mydiscussions

Sort spreadsheet rows into different sheets?

Hi all, I'm trying to sort a spreadsheet into different categories, and I would like it so that if a cell in a row contains one thing, it displays the row in another sheet, ie if the cell contains 'BH' then I would like it to be displayed in the sheet/page Bath (BH) which is visible at the bottom, or if it contains WS then to Wells (WS). I hope I've made that clear as it's quite hard to explain, I've attached a screenshot to show what I mean. I'm not sure if this is even possible but any help you can offer is much appreciated!

P.S. The screenshot is from the Sheets app on iPad, but I mostly use a Mac with Safari or Firefox, just to avoid any confusion!
---
Hi all, I'm trying to sort a spreadsheet into different categories, and I would like it so that if a cell in a row contains one thing, it displays the row in another sheet, ie if the cell contains 'BH' then I would like it to be displayed in the sheet/page Bath (BH) which is visible at the bottom, or if it contains WS then to Wells (WS). I hope I've made that clear as it's quite hard to explain, I've attached a screenshot to show what I mean. I'm not sure if this is even possible but any help you can offer is much appreciated!

P.S. The screenshot is from the Sheets app on iPad, but I mostly use a Mac with Safari or Firefox, just to avoid any confusion
-----------------------------------------------------------------------------------------------------------------------