Is there any good trick how entering a plus (+) sign to cell opens instantly other spreadsheet where in the table are the values, one needs to copy to this first cell?
That's is entering + and without clicking to sheet tab next, (where the table is located), with mouse - because the task is very repeative.
The sequence is finished with "enter" which enters the copy to the cell.
The idea is to fill in 1st cell from the table, then using lookup function add 2 following columns from the same table, and when all rows have been filled to use copy and paste function to fixate created invoice or perhaps finally just to save as copy of spreadsheet.
Thanks for any ideas!
That's is entering + and without clicking to sheet tab next, (where the table is located), with mouse - because the task is very repeative.
The sequence is finished with "enter" which enters the copy to the cell.
The idea is to fill in 1st cell from the table, then using lookup function add 2 following columns from the same table, and when all rows have been filled to use copy and paste function to fixate created invoice or perhaps finally just to save as copy of spreadsheet.
Thanks for any ideas!