I'm trying to figure out a way to copy specific fields to other sheets based on IF statements.
I have 4 sheets, the Customer Subscription Sheet (Sheet 1), Month 1 (Sheet 2), Month 2 (Sheet 3) and Month 3 (Sheet 4).
I have customer subscriptions in sheet 1 containing a column that states how long a customer has subscribed for.
What I want to do is copy fields from sheet 1 to the other sheets based on how long the customer has subscribed for.
So if the customer has subscribed for 1 month, what I want to do, is copy that entire row to Month 1 (sheet 2).
If the customer has subscribed for 2 months then I want to copy the row to both Month 1 (sheet 2) and Month 2 (sheet 3).
Similarly, for 3 months, the row will be copied to all the sheets.
Link to sheet: https://docs.google.com/spreadsheets/d/1HPStHwqGOrTTOa07azEg_tQ3OfA0Uq-9ITX3ACaLyqk/edit?usp=sharing
I'd really appreciate it if someone could help me out with this. Any input is welcome :)