Most probably the simplest solution to this but my heads gone blank
B1 > F1 are the trials
B2 > F2 are the results from each trial
I need to keep the trial results, so when a new trial result is placed in A1 the whole range of A1 > F2 is moved right 1 cell and copied over existing cells
\1
so the result looks like
\1
This is what I tried using it will copy but not paste using A2 as activecell
Different trials are going to be used in Cells below at a later date and looped through so each row has to be row specific.
Thanks in advance for any help.
Bookmarks