Fill down and select multiple cells
Can't find this info in previous posts -
How can I select multiple cells in table view, then do a fill down, or fill right?
A little more info-
I am trying to replicate Excel functionality, and am new to FM and NOT a software developer (although I am getting the hang of scripting).
We use Excel for resource allocation but have pushed Excel to it's limits with lookup fields and named fields that constantly break due to multiple users of the file.
So far I have just re-created the spreadsheet layout with deliverables/resources in rows and months in columns, we then specify percentage of resource per deliverable per month, then subtotal a range of month columns. However, we like the fill-down and fill-right functions in Excel which allow speedy entry of repeating values.
The suggestions so far sound more complex than just selecting a range of fields and filling.
Any other ideas, or any other suggestions for designing this database to do what I need it to do?