Reputation: 3
example pic: (https://i.sstatic.net/jxMUF.png)
In Google Sheets, I want to take the data from the 1st tab and transfer only the rows that show monthly expenses to the following tabs. So based on the picture I attached, on the January tab I want the row with Sam/$75/monthly and John/$100/monthly to be copied to the next tabs (Feb, Mar, and the rest of the months when I add them). And then from the February tab, I want to copy the Sam/$75/monthly and John/$100/monthly rows as well as the Mary/$150/monthly row.
Here's the example spreadsheet I was using. https://docs.google.com/spreadsheets/d/1uXoNJh6BH4an3oFD5V-naQo1lG7n5xxxcCCj0noBsH8/edit?usp=sharing
I know I can use "=Sheet1! A1" but the problem with that one is I want it to figure out the rows I want automatically based on the column label "frequency of expenses."
Upvotes: 0
Views: 36