cellphones232
New Member
- Joined
- Oct 5, 2017
- Messages
- 1
So I have a pricelist on one sheet and I'm looking to make it my master sheet.
Then I'd like to import it to another sheet, so any time I make a change on my master sheet, it changes my imported sheet.
I'd then like to put certain ranges, like if under $10, subtract 20%, if under $20 subtract 20%.
Before, I was told to use =..... and then I would have to copy it and then paste it. Is there a way I can just put percentages and it changes the full sheets.
Master Sheet
https://docs.google.com/spreadsheets/d/1V3yTc5YEnMhvbFb8hVNxGIo7fkwSqTdbxPtj5T7TQkM/edit?usp=sharing
Imported Sheet
https://docs.google.com/spreadsheets/d/1UXGYi4BRFb00yAS7brbJVqYcSS5wXhohTpQrMb-dhQU/edit?usp=sharing
Then I'd like to import it to another sheet, so any time I make a change on my master sheet, it changes my imported sheet.
I'd then like to put certain ranges, like if under $10, subtract 20%, if under $20 subtract 20%.
Before, I was told to use =..... and then I would have to copy it and then paste it. Is there a way I can just put percentages and it changes the full sheets.
Master Sheet
https://docs.google.com/spreadsheets/d/1V3yTc5YEnMhvbFb8hVNxGIo7fkwSqTdbxPtj5T7TQkM/edit?usp=sharing
Imported Sheet
https://docs.google.com/spreadsheets/d/1UXGYi4BRFb00yAS7brbJVqYcSS5wXhohTpQrMb-dhQU/edit?usp=sharing
