Hi I'm trying to copy a cell in 2 directions but the formula has links that don't follow
here's an example :
A1(value)
A2(Value) C2(= $A$1*A2)
If I drag A2 and C2 down it works they all relate to A1 because of the $ and to the cell beside because of the lack of $.
When A2 and C2 are dragged and filled with multiple data I want to copy all of it to the right (A1, A2 and C2 become H1, H2 and J2 etc) but when I do that I need to fix the formula to every beginning of the selection and redrag everything down....
Is there a way to automate that? It's something that should exist and and tired of searching everywhere.....
Thanks
Bruno
Bookmarks