Alice has attended:
Excel Intermediate course
Copying Complex Formula
Hi,
I need to copy a whole line with various functions and formulas into a number of rows. How do I do this and keep the formula the same?
I cant seem to make it work?!
Thanks,
Alice
RE: Copying Complex Formula
Hi Alice,
Thank you for your question.
By the sounds of it, you might need to 'lock' some or all the cell references inside some of all of the formulas, with $ symbols before copying them. It will help me more if I could see the spreadsheet. You're welcome to email me a copy or extract of the spreadsheet, then I can have a better understanding.
You can email it to forum@stl-training.co.uk
Kind regards
Marius
Best STL