I use calc to calculate my accounts - and this involves, different sheets, with complex formulas, that are updated.
When I need to link the data, to other sheets, I do so, using “Paste special link” to ensure they update correctly.
This can take some time, when the source data has multiple calculations in a row, and needs to be linked into a similar sheet, so I’d like to know, is it possible to copy and link a range of cells, using “paste special links” so you can paste adjoining cell data - with the differing link data,into another sheet?
Hello
here is the issue:
sample source.ods (19.6 KB)
The sample source data here, is simply a value. The actual sheet is a complex formula, to sort and calculate, live update etc.
My question is I would usually high each individual cell / copy / paste special / into the separate monthly report sheet. That would then live update, when opened.
Because of the large amount of cells, that are linked to the monthly report, I was trying to find a way to copy a selection of cells with data, and then paste link, to speed things up.
What I find, is the copied and pasted cells B4,C4,D4,E4, rather than pasted individually, are collectively grouped “B4:E4” which does not work.
Is there a method to copy multiple formula cells in a sheet, then paste link these, each individual cell in a corresponding sheet?
I’m not quite sure what you mean here. “Adjoining cell data” and “differing link data”. Is it possible to provide a sample of your data (or a mock up) perhaps with the cells you want to copy highlighted and again how you want them pasted?
Hello Ash, thank you for the reply.
I probably could have explained this better.
I use a number of specific spreadsheets, for my accounting and business sales, etc.
Sheet 1 “Balance Sheet”
contains stock purchases / sales / vat / costs / etc
That then links to Sheets for VAT / Reports / P&L etc
Often a lot of the data is ordered by date / and when linking to other sheets, that update automatically, I literally, highlight - copy - paste link - and when its sometimes, several hundred links - simply for one calendar year, it’s tough on the fingers !
I have attempted a few times, to try various methods, of copying several of the data links,
to create monthly financial reports, but I have as yet, not realised how to, or even if it is possible, to highlight - copy - a row or column, of calculated data, and then apply that to a differing sheet, whilst retaining the specific calculating formula, for each individual cell,its been taken from.
I have a basic sample file here.
It’s the method, I am looking to discover.
unfortunately I cannot see how to upload a sample calc file !
When you edit you should see the following icons (upload is right in the middle):
I copied the picture from the instructions for this site: This is the guide - How to use the Ask site?
Thank you Wanderer.
Unfortunately, when i try and edit the question,I simply do not have the upload button displayed. (all the others are displayed, except that one)
ePerhaps it is something, for longstanding members ?
1 Like
Never heard this before, as “we” often ask for uploads…
Sometimes the toolbar here is not expanded, and you have to click (I think) 3 ellipses to show that button. But if you can’t do it to the original post you should be able to add it to a comment.