Noob Excel Question
I'm on a make-shift Corp Dev team at a Tech company with no real transactions experience (go figure lol).
Building out a customer forecasting model for a target on Google Sheets. I'll be download as a .XLS and building Data Tables for Sensitivities on the sheet and exporting the values into Google Sheets. (any better way to do this for people who have used sheets?)
I have my model built out with all my assumptions / inputs in the top rows, say rows 1-20, and the actual monthly forecast below it. It looks like shit, especially with all the frozen pains for the line items.
If I move all my assumptions / inputs to a separate sheet before exporting, will I still be able to do the Data tables? From what I understand, the assumptions / inputs need to be on the same sheet as the formula that's driving the data table
Can I build the data tables independtly on a seperate sheet?
Is there a better way to do this given my Google Sheets constraint? I can't have this on an excel sheet because our CEO / CFO / CorpDev prefer to be able to work on things together.