A
alexwren
This is going to be tricky to explain but here goes.
I have a spreadsheet where one sheet (empty to start with) is purely
used for the the client to paste data in. The format will always be the
same and the columns will always be in the same order. The only thing
that will change is that the number of rows will vary.
The second sheet has a row of quite complex formulas (one for each
corresponding column on the first sheet).
Currently we paste data in the first worksheet (from a supplied CSV)
and then have to move to the second sheet and drag the whole set of
formulas down until it reaches the same number of rows as the first
sheet.
Is it possible to do this automatically?
Also does anybody know of a way that I might be able to sort the data
(need to do several levels) automatically?
Thanks in advance
Alex
I have a spreadsheet where one sheet (empty to start with) is purely
used for the the client to paste data in. The format will always be the
same and the columns will always be in the same order. The only thing
that will change is that the number of rows will vary.
The second sheet has a row of quite complex formulas (one for each
corresponding column on the first sheet).
Currently we paste data in the first worksheet (from a supplied CSV)
and then have to move to the second sheet and drag the whole set of
formulas down until it reaches the same number of rows as the first
sheet.
Is it possible to do this automatically?
Also does anybody know of a way that I might be able to sort the data
(need to do several levels) automatically?
Thanks in advance
Alex